Oracle Cloud Infrastructure Documentation

Adding a HeatWave Cluster

You can add a HeatWave cluster to a DB system created with a shape that supports HeatWave cluster. When you add a HeatWave cluster to a high availability DB system, the HeatWave cluster is added to the primary MySQL instance.

Using the Console

Use the Console to add a HeatWave cluster to the DB system.

This task requires the following:
  • A DB system with HeatWave cluster supported shapes. For data sets of 10 TB or more, it is recommended to use the MySQL.HeatWave.BM.Standard shape. See Supported Shapes.
Do the following to add a HeatWave cluster to an existing DB system:
Note

If you encounter OutOfHostCapacity work request error while adding a HeatWave cluster to a DB system, see Resolving OutOfHostCapacity Error.
  1. Open the navigation menu and select Databases. Under HeatWave, click DB systems.
  2. Do one of the following:
    • Choose Add HeatWave cluster from the Actions menu on the same line as your DB system.
    • Click the name of the DB system to open the DB system details page. Select HeatWave cluster from the Resources list. Under HeatWave cluster information frame, click Add HeatWave cluster.
    • Click the name of the DB system to open the DB system details page. Click More actions, and select Add HeatWave cluster.
  3. On the Add HeatWave cluster panel, do the following:
    • Select a shape: Select the shape for the HeatWave nodes. Click Change shape to select a shape for the HeatWave nodes. You cannot select MySQL.HeatWave.BM.* shapes for a HeatWave node. See Supported Shapes.
    • Node : Specify the number of HeatWave nodes to create. A minimum of 1 is supported and a maximum of 64 nodes are supported. If you enable HeatWave Lakehouse, a maximum of 512 nodes are supported.
      Note

      The HeatWave.32GB shape supports a maximum of 16 nodes only.
    • HeatWave Lakehouse: Enable query processing on the data residing in Object Storage. HeatWave Lakehouse is supported on the MySQL.HeatWave.VM.Standard and HeatWave.512GB shapes only. See HeatWave Lakehouse.
      Note

      Prior to MySQL 8.3.0-u2, you must disable point-in-time recovery, high availability, read replicas, and outbound replication in order to enable HeatWave Lakehouse.
    • Estimate node count: (Optional) Click it to estimate the number of nodes required based on the shape you selected and the size of your data. See Generating a Node Count Estimate.
  4. Click Add HeatWave cluster .