4 MySQL HeatWave Clusters
This chapter describes how to create and manage MySQL HeatWave Clusters.
A MySQL HeatWave Cluster consists of one or more MySQL HeatWave nodes. The MySQL DB System includes a MySQL HeatWave plugin that is responsible for cluster management, query scheduling, and returning query results to the MySQL DB System. MySQL HeatWave nodes store data in memory and process queries.
When a MySQL HeatWave Cluster is enabled and data is loaded, queries that meet certain prerequisites are automatically offloaded from the MySQL DB System to the MySQL HeatWave Cluster for accelerated processing.
MySQL 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
theMySQL HeatWave format, stored in the MySQL HeatWave persistence storage
layer, and then loaded to the MySQL HeatWave Cluster memory. MySQL HeatWave Lakehouse supports
structured and relational data in CSV and Parquet formats. It is supported on the MySQL HeatWave.256GB node shape only. Lakehouse supports a maximum of 512 MySQL HeatWave nodes.