MySQL Shell for Visual Studio Code - MySQL HeatWave's best companion for developers

MySQL Belgian Days 2024 - Learn how MySQL Shell for Visual Studio Code is the best companion of MySQL HeatWave Database service in OCI

Transcript

1. 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
2. Who am I ? about.me/lefred Copyright @ 2024 Oracle and/or its affiliates. 2
3. @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
4. MySQL HeatWave Terminology Copyright @ 2024 Oracle and/or its affiliates. 4
5. 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
6. MySQL Shell for Visual Studio Code Integration with MySQL HeatWave on OCI Copyright @ 2024 Oracle and/or its affiliates. 6
7. Installation Copyright @ 2024 Oracle and/or its affiliates. 7
8. Installation Copyright @ 2024 Oracle and/or its affiliates. 8
9. 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
10. Installation Copyright @ 2024 Oracle and/or its affiliates. 10
11. Installation Copyright @ 2024 Oracle and/or its affiliates. 11
12. Installation Copyright @ 2024 Oracle and/or its affiliates. 12
13. Installation Copyright @ 2024 Oracle and/or its affiliates. 13
14. Installation Copyright @ 2024 Oracle and/or its affiliates. 14
15. Installation Copyright @ 2024 Oracle and/or its affiliates. 15
16. Installation Copyright @ 2024 Oracle and/or its affiliates. 16
17. Installation Copyright @ 2024 Oracle and/or its affiliates. 17
18. OCI Setup Copyright @ 2024 Oracle and/or its affiliates. 18
19. OCI Setup Copyright @ 2024 Oracle and/or its affiliates. 19
20. OCI Setup Copyright @ 2024 Oracle and/or its affiliates. 20
21. OCI Setup Copyright @ 2024 Oracle and/or its affiliates. 21
22. OCI Setup Copyright @ 2024 Oracle and/or its affiliates. 22
23. 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
24. MySQL HeatWave Instance Operations Copyright @ 2024 Oracle and/or its affiliates. 24
25. 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
26. Connection - Bastion Service Copyright @ 2024 Oracle and/or its affiliates. 26
27. Connection - Bastion Service Copyright @ 2024 Oracle and/or its affiliates. 27
28. Connection - Bastion Service Copyright @ 2024 Oracle and/or its affiliates. 28
29. Connection - Bastion Service Copyright @ 2024 Oracle and/or its affiliates. 29
30. MySQL Shell for Visual Studio Code MySQL Administration Copyright @ 2024 Oracle and/or its affiliates. 30
31. Administration - Server Status Copyright @ 2024 Oracle and/or its affiliates. 31
32. Administration - Client Connections Copyright @ 2024 Oracle and/or its affiliates. 32
33. Administration - Performance Dashboard Copyright @ 2024 Oracle and/or its affiliates. 33
34. Administration - Performance Dashboard Copyright @ 2024 Oracle and/or its affiliates. 34
35. MySQL Shell for Visual Studio Code Dump & Load Data Copyright @ 2024 Oracle and/or its affiliates. 35
36. 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
37. 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
38. Load the Dump to a DB System Copyright @ 2024 Oracle and/or its affiliates. 38
39. Load the Dump to a DB System Copyright @ 2024 Oracle and/or its affiliates. 39
40. MySQL Shell for Visual Studio Code MySQL HeatWave Cluster Copyright @ 2024 Oracle and/or its affiliates. 40
41. 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
42. MySQL HeatWave Cluster - Operations Copyright @ 2024 Oracle and/or its affiliates. 42
43. MySQL HeatWave Cluster - Rescale Copyright @ 2024 Oracle and/or its affiliates. 43
44. MySQL HeatWave Cluster - Rescale Copyright @ 2024 Oracle and/or its affiliates. 44
45. MySQL HeatWave Cluster - Rescale Copyright @ 2024 Oracle and/or its affiliates. 45
46. 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
47. 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
48. 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
49. Loading Data to HeatWave Cluster Or use MySQL Shell for VS Code: Copyright @ 2024 Oracle and/or its affiliates. 47
50. Loading Data to HeatWave Cluster Copyright @ 2024 Oracle and/or its affiliates. 48
51. Loading Data to HeatWave Cluster Copyright @ 2024 Oracle and/or its affiliates. 49
52. MySQL Shell for Visual Studio Code Extending the friendship ? Copyright @ 2024 Oracle and/or its affiliates. 50
53. 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
54. MySQL Shell Extensions - example Copyright @ 2024 Oracle and/or its affiliates. 52
55. Share your ❤ to MySQL #mysql #MySQLCommunity Join our slack channel! bit.ly/mysql-slack Copyright @ 2024 Oracle and/or its affiliates. 53
56. Questions ? Copyright @ 2024 Oracle and/or its affiliates. 54