Creating a MySQL HeatWave Cluster

4.1 Creating a MySQL HeatWave Cluster

A MySQL HeatWave Cluster must be associated with an active DB System, and a DB System can have only one MySQL HeatWave Cluster. Before you create a MySQL HeatWave Cluster, ensure that you have created a DB System and that the DB System does not already have a MySQL HeatWave Cluster. With MySQL HeatWave on AWS, you create a DB System and MySQL HeatWave nodes at the same time, but you can delete the MySQL HeatWave Cluster afterwards if you want to re-create it. See Creating a DB System for instructions.

When you create a MySQL HeatWave Cluster, you are presented with an option to estimate the required MySQL HeatWave Cluster size based on data that is loaded on your DB System (see Estimating Cluster Memory Size with MySQL HeatWave Autopilot). If you have not loaded data into your DB System, and you want to estimate the optimal MySQL HeatWave Cluster size, load data into the DB System before you create a MySQL HeatWave Cluster. See Importing Data.

Note:

Changing the number of nodes in an existing MySQL HeatWave Cluster is not supported. If you require a larger or smaller cluster, you must delete the existing cluster and create a new one with the desired number of nodes.

To create a MySQL HeatWave Cluster, do the following:

In the MySQL HeatWave Console, select the Resources tab, and then the MySQL HeatWave Clusters tab.
Click Create MySQL HeatWave Cluster. The Create MySQL HeatWave Cluster dialog is displayed.
On the Create MySQL HeatWave Cluster dialog, provide the following information:
- Basic Information
  - Display Name: Specify a user-friendly display name for the MySQL HeatWave Cluster.
  - Description: Specify a user-friendly description of the MySQL HeatWave Cluster.
- DB System Name: Select a DB System from the drop down menu.
- Select Enable MySQL HeatWave Lakehouse to support MySQL HeatWave Lakehouse.
- MySQL HeatWave Cluster Configuration: You can select either of the following options by the toggle buttons:
  - Manually configure cluster. Configure the cluster then by filling in the following information.
    - Shape: Select a MySQL HeatWave node shape. For information about supported shapes, see Supported Shapes.
      
      Note:
      If you intend to use the MySQL HeatWave AutoML functionality, the MySQL HeatWave.256GB node shape is recommended when creating a MySQL HeatWave Cluster. The MySQL HeatWave.16GB node shape may not have enough memory for training on large data sets. If you see error messages about this (such as ML003024), use the larger shape instead.
    - Cluster Size: Select the number of MySQL HeatWave nodes. The minimum number is 1, and the maximum number depends on the following conditions:
      
      For the Heatwave.16GB node shape: 16.
      
      For the HeatWave.256GB node shape:
      
      If MySQL HeatWave Lakehouse is not enabled: 128.
      
      If MySQL HeatWave Lakehouse is enabled: 512.
  - Automatically configure cluster. Configure the cluster by clicking Estimate memory size to estimate the required cluster size using MySQL HeatWave Autopilot. See more details in Estimating Cluster Memory Size with MySQL HeatWave Autopilot.
- Check the MySQL HeatWave Cluster configuration in the Summary section. Go back to the steps above to make changes if needed.
Click Create to create the MySQL HeatWave Cluster.

You are returned to the MySQL HeatWave Clusters page where you can monitor the state of the operation, which may take some time to complete. The state changes from Creating to Active when the operation has completed successfully.

Estimating Cluster Memory Size with MySQL HeatWave Autopilot

Parent topic: MySQL HeatWave Clusters