1.1 MySQL HeatWave

MySQL HeatWave is a massively parallel, high performance, in-memory query accelerator that accelerates MySQL performance by orders of magnitude for analytics and mixed workloads. With MySQL HeatWave, you can provision DB Systems and MySQL HeatWave Clusters.

MySQL HeatWave consists of a DB System and one or more MySQL HeatWave nodes that form a MySQL HeatWave Clusters. The DB System is responsible for cluster management, query scheduling, and returning query results. MySQL HeatWave nodes store data in memory and process analytics queries.

When a MySQL HeatWave Cluster is enabled, queries that meet certain prerequisites are automatically offloaded from the DB System to the MySQL HeatWave Cluster for accelerated processing. Queries are issued from Query Editor in the MySQL HeatWave Console or from a MySQL client or application that interacts with the MySQL HeatWave Cluster by connecting to the DB System.

Tip:

This MySQL HeatWave on AWS Service Guide covers what you need to know to set up and use DB Systems and MySQL HeatWave Clusters on AWS, mainly using the MySQL HeatWave Console. For more detailed information about using MySQL HeatWave and related utilities, refer to the MySQL HeatWave User Guide . Some of that information does not apply to MySQL HeatWave on AWS, so be sure to check the MySQL HeatWave on AWS Service Guide first for the most relevant information.