Re: Hands-On Lab on 4 August 2022: MySQL HeatWave and Analytical Data Visualization on Oracle Cloud

[Micky Martain]

How to Add HeatWave Cluster into Database System: Step by Step
Before adding HeatWave Cluster into the Database System you must Ensure the DB System was created using MySQL.HeatWave.VM.Standard.E3 shape.

1) Register & Log in to the Oracle free Cloud account.
2) To add a HeatWave cluster to an existing MySQL DB System:
Open the navigation menu and select Databases. Under MySQL, click DB Systems.
2. Add your HeatWave cluster in one of the following ways:

Select the DB System and choose Add HeatWave Cluster from the Actions icon (three dots) on the same line as your DB System
Open the DB System and select HeatWave Cluster from the Resources list. On the HeatWave Cluster Information frame, select Add HeatWave Cluster.
The Add HeatWave Cluster dialog is displayed.
3. On the Add HeatWave Cluster dialog, provide the following details:
Shape: The shape for the HeatWave nodes. Shapes are resource templates, defining the number of OCPUs, RAM, and so on. Click Change Shape to select a shape for your HeatWave nodes. You must use the same shape as that used by the associated DB System.
Node Count: The number of HeatWave nodes to create. Optionally, click Estimate Node Count to generate a node count estimate to determine the number of nodes required based on the shape you selected and the size of your data.
4.Click Add HeatWave Cluster to create the HeatWave cluster.
Managing HeatWave Cluster
1.How to load Data into the HeatWave Cluster

Before loading data into the HeatWave cluster, the data/tables have to be prepared.
Preparing tables involves:
Modifying table definitions to exclude certain columns, define string column encodings, add data placement keys.
Specify HeatWave (RAPID) as the secondary engine for the table (Note that InnoDB is the primary engine).
Loading a table into a HeatWave cluster requires executing an ALTER TABLE operation with the SECONDARY_LOAD keyword.
mysql> ALTER TABLE sales SECONDARY_UNLOAD;
2. How to query data using the HeatWave cluster

If a query accesses a table that is not loaded, the query is not offloaded to the HeatWave cluster for processing
Queries that meet certain prerequisites are automatically offloaded from the MySQL DB System to the HeatWave cluster for accelerated processing
Results are returned to the MySQL DB System node and to the MySQL client or application that issued the query
When a table is loaded, data is sliced horizontally and distributed among HeatWave nodes
After a table is loaded, changes to a table’s data on the MySQL DB System node are automatically propagated to the HeatWave nodes