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. The minimum is 1 node and the maximum depends to the following:
      • HeatWave.Free shape: 1 node
      • HeatWave.32GB shape: 16 nodes
      • HeatWave.512GB or MySQL.HeatWave.VM.Standard shape: 64 nodes
      • HeatWave.512GB or MySQL.HeatWave.VM.Standard shape with Lakehouse enabled: 512 nodes
    • HeatWave Lakehouse: Enable query processing on the data residing in Object Storage. Prior to MySQL 8.4.0-u3, 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 .