Tweet
Tweet

Slide 1

Slide 1 text

Frédéric Descamps Community Manager Oracle MySQL MySQL Belgian Days - February 2024 MySQL Shell for Visual Studio Code MySQL HeatWave's best companion for developers

Slide 2

Slide 2 text

Who am I ? about.me/lefred Copyright @ 2024 Oracle and/or its affiliates. 2

Slide 3

Slide 3 text

@lefred MySQL Evangelist using MySQL since version 3.20 devops believer likes living in h ps://lefred.be Frédéric Descamps Copyright @ 2024 Oracle and/or its affiliates. 3

Slide 4

Slide 4 text

MySQL HeatWave Terminology Copyright @ 2024 Oracle and/or its affiliates. 4

Slide 5

Slide 5 text

Terminology OCI: Oracle Cloud Infrastructure MySQL HeatWave: MySQL HeatWave Database Service (MHS) MySQL Database Service (MDS) MySQL HeatWave Cluster: OLTP and OLAP query accelerator RAPID secondary engine Copyright @ 2024 Oracle and/or its affiliates. 5

Slide 6

Slide 6 text

MySQL Shell for Visual Studio Code Integration with MySQL HeatWave on OCI Copyright @ 2024 Oracle and/or its affiliates. 6

Slide 7

Slide 7 text

Installation Copyright @ 2024 Oracle and/or its affiliates. 7

Slide 8

Slide 8 text

Installation Copyright @ 2024 Oracle and/or its affiliates. 8

Slide 9

Slide 9 text

Installation Or just use CTRL-P in Visual Studio code and paste the following command: ext install Oracle.mysql-shell-for-vs-code Copyright @ 2024 Oracle and/or its affiliates. 9

Slide 10

Slide 10 text

Installation Copyright @ 2024 Oracle and/or its affiliates. 10

Slide 11

Slide 11 text

Installation Copyright @ 2024 Oracle and/or its affiliates. 11

Slide 12

Slide 12 text

Installation Copyright @ 2024 Oracle and/or its affiliates. 12

Slide 13

Slide 13 text

Installation Copyright @ 2024 Oracle and/or its affiliates. 13

Slide 14

Slide 14 text

Installation Copyright @ 2024 Oracle and/or its affiliates. 14

Slide 15

Slide 15 text

Installation Copyright @ 2024 Oracle and/or its affiliates. 15

Slide 16

Slide 16 text

Installation Copyright @ 2024 Oracle and/or its affiliates. 16

Slide 17

Slide 17 text

Installation Copyright @ 2024 Oracle and/or its affiliates. 17

Slide 18

Slide 18 text

OCI Setup Copyright @ 2024 Oracle and/or its affiliates. 18

Slide 19

Slide 19 text

OCI Setup Copyright @ 2024 Oracle and/or its affiliates. 19

Slide 20

Slide 20 text

OCI Setup Copyright @ 2024 Oracle and/or its affiliates. 20

Slide 21

Slide 21 text

OCI Setup Copyright @ 2024 Oracle and/or its affiliates. 21

Slide 22

Slide 22 text

OCI Setup Copyright @ 2024 Oracle and/or its affiliates. 22

Slide 23

Slide 23 text

MySQL DB System MySQL DB System with HeatWave Cluster Compute Instance / HeatWave Cluster Node Bastion Host OCI Load Balancer MySQL Router List of instances Copyright @ 2024 Oracle and/or its affiliates. 23

Slide 24

Slide 24 text

MySQL HeatWave Instance Operations Copyright @ 2024 Oracle and/or its affiliates. 24

Slide 25

Slide 25 text

Connection As Developer, the easiest way to connect to your MySQL DB System if you don't have any VPN to your OCI tenancy, it to use the Bastion Service: Copyright @ 2024 Oracle and/or its affiliates. 25

Slide 26

Slide 26 text

Connection - Bastion Service Copyright @ 2024 Oracle and/or its affiliates. 26

Slide 27

Slide 27 text

Connection - Bastion Service Copyright @ 2024 Oracle and/or its affiliates. 27

Slide 28

Slide 28 text

Connection - Bastion Service Copyright @ 2024 Oracle and/or its affiliates. 28

Slide 29

Slide 29 text

Connection - Bastion Service Copyright @ 2024 Oracle and/or its affiliates. 29

Slide 30

Slide 30 text

MySQL Shell for Visual Studio Code MySQL Administration Copyright @ 2024 Oracle and/or its affiliates. 30

Slide 31

Slide 31 text

Administration - Server Status Copyright @ 2024 Oracle and/or its affiliates. 31

Slide 32

Slide 32 text

Administration - Client Connections Copyright @ 2024 Oracle and/or its affiliates. 32

Slide 33

Slide 33 text

Administration - Performance Dashboard Copyright @ 2024 Oracle and/or its affiliates. 33

Slide 34

Slide 34 text

Administration - Performance Dashboard Copyright @ 2024 Oracle and/or its affiliates. 34

Slide 35

Slide 35 text

MySQL Shell for Visual Studio Code Dump & Load Data Copyright @ 2024 Oracle and/or its affiliates. 35

Slide 36

Slide 36 text

Dump a Schema locally to be imported in OCI It's possible to dump a schema from an instance locally to be imported to a MySQL HeatWave DB System in OCI: Copyright @ 2024 Oracle and/or its affiliates. 36

Slide 37

Slide 37 text

Dump a Schema locally to be imported in OCI It creates a MySQL Shell parallel dump using the following options: "options": { "compatibility": [ "create_invisible_pks", "force_innodb", "skip_invalid_accounts", "strip_definers", "strip_restricted_grants", "strip_tablespaces" ], "ocimds": true } Copyright @ 2024 Oracle and/or its affiliates. 37

Slide 38

Slide 38 text

Load the Dump to a DB System Copyright @ 2024 Oracle and/or its affiliates. 38

Slide 39

Slide 39 text

Load the Dump to a DB System Copyright @ 2024 Oracle and/or its affiliates. 39

Slide 40

Slide 40 text

MySQL Shell for Visual Studio Code MySQL HeatWave Cluster Copyright @ 2024 Oracle and/or its affiliates. 40

Slide 41

Slide 41 text

MySQL HeatWave Cluster If the instance's shape supports MySQL HeatWave Cluster, the cluster can be added from the MySQL Shell for Visual Studio Code's interface: Copyright @ 2024 Oracle and/or its affiliates. 41

Slide 42

Slide 42 text

MySQL HeatWave Cluster - Operations Copyright @ 2024 Oracle and/or its affiliates. 42

Slide 43

Slide 43 text

MySQL HeatWave Cluster - Rescale Copyright @ 2024 Oracle and/or its affiliates. 43

Slide 44

Slide 44 text

MySQL HeatWave Cluster - Rescale Copyright @ 2024 Oracle and/or its affiliates. 44

Slide 45

Slide 45 text

MySQL HeatWave Cluster - Rescale Copyright @ 2024 Oracle and/or its affiliates. 45

Slide 46

Slide 46 text

Loading Data to HeatWave Cluster If you want to load data to HeatWave Cluster, the manual operation is the following to use the Auto Parallel Load command: call sys.heatwave_load(JSON_ARRAY('menagerie'), NULL); Copyright @ 2024 Oracle and/or its affiliates. 46

Slide 47

Slide 47 text

Loading Data to HeatWave Cluster If you want to load data to HeatWave Cluster, the manual operation is the following to use the Auto Parallel Load command: call sys.heatwave_load(JSON_ARRAY('menagerie'), NULL); and I forgot about the options :-( Copyright @ 2024 Oracle and/or its affiliates. 46

Slide 48

Slide 48 text

Loading Data to HeatWave Cluster If you want to load data to HeatWave Cluster, the manual operation is the following to use the Auto Parallel Load command: call sys.heatwave_load(JSON_ARRAY('menagerie'), NULL); and I forgot about the options :-( Use this command to get the full help: CALL sys.heatwave_load(JSON_ARRAY("sys"),JSON_OBJECT("output","help")); Copyright @ 2024 Oracle and/or its affiliates. 46

Slide 49

Slide 49 text

Loading Data to HeatWave Cluster Or use MySQL Shell for VS Code: Copyright @ 2024 Oracle and/or its affiliates. 47

Slide 50

Slide 50 text

Loading Data to HeatWave Cluster Copyright @ 2024 Oracle and/or its affiliates. 48

Slide 51

Slide 51 text

Loading Data to HeatWave Cluster Copyright @ 2024 Oracle and/or its affiliates. 49

Slide 52

Slide 52 text

MySQL Shell for Visual Studio Code Extending the friendship ? Copyright @ 2024 Oracle and/or its affiliates. 50

Slide 53

Slide 53 text

You can still use and extend MySQL Shell for VS Code with your own plugins ! You can get more... Copyright @ 2024 Oracle and/or its affiliates. 51

Slide 54

Slide 54 text

MySQL Shell Extensions - example Copyright @ 2024 Oracle and/or its affiliates. 52

Slide 55

Slide 55 text

Share your ❤ to MySQL #mysql #MySQLCommunity Join our slack channel! bit.ly/mysql-slack Copyright @ 2024 Oracle and/or its affiliates. 53

Slide 56

Slide 56 text

Questions ? Copyright @ 2024 Oracle and/or its affiliates. 54