4 HeatWave Clusters

This chapter describes how to create and manage HeatWave Clusters.

A HeatWave Cluster consists of one or more HeatWave nodes. The MySQL DB System includes a HeatWave plugin that is responsible for cluster management, query scheduling, and returning query results to the MySQL DB System. HeatWave nodes store data in memory and process queries.

When a HeatWave Cluster is enabled and data is loaded, queries that meet certain prerequisites are automatically offloaded from the MySQL DB System to the HeatWave Cluster for accelerated processing.

HeatWave Clusters support Lakehouse. Lakehouse enables query processing on the data residing in Amazon S3. The source data is read from Amazon S3, transformed to theHeatWave format, stored in the HeatWave persistence storage layer, and then loaded to the HeatWave Cluster memory. HeatWave Lakehouse supports structured and relational data in CSV and Parquet formats. It is supported on the HeatWave.256GB node shape only. Lakehouse supports a maximum of 512 HeatWave nodes.

• Creating a HeatWave Cluster
  
• Managing a HeatWave Cluster
  
• Viewing HeatWave Cluster Details
  
• HeatWave Cluster Data Recovery