Oracle Cloud Infrastructure Documentation

Overview of HeatWave

HeatWave provisions HeatWave clusters for accelerated processing of analytic queries.

Note

This guide describes how to deploy and manage HeatWave clusters on Oracle Cloud Infrastructure. For deploying and managing MySQL HeatWave on Amazon Web Services, see MySQL HeatWave on AWS, and for provisioning MySQL HeatWave in Oracle Database Service in Azure (ODSA), see Provisioning MySQL HeatWave.

A HeatWave cluster consists of one or more HeatWave nodes. HeatWave nodes store data in memory and process queries. 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.

When you enable a HeatWave cluster, queries that meet certain prerequisites are automatically offloaded from the MySQL DB system to the HeatWave cluster for accelerated execution. The queries that you issue from a MySQL Client or application interacts with the HeatWave cluster by connecting to the MySQL DB system. The HeatWave cluster returns the results to the MySQL DB system and to the MySQL Client or application that issued the query.

MySQL HeatWave Lakehouse

MySQL HeatWave Lakehouse enables query processing on the data residing in Object Storage. The source data is read from Object Storage, transformed to the HeatWave 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.

HeatWave Lakehouse is supported on the MySQL.HeatWave.VM.Standard and HeatWave.512GB shapes only. Lakehouse supports a maximum of 512 HeatWave nodes. To enable Lakehouse, you must disable point-in-time recovery, high availability, read replicas, and outbound replication. See MySQL HeatWave Lakehouse.

Additional HeatWave Information

After deploying a HeatWave cluster, refer to the following:

  • HeatWave User Guide: Describes how to load data and run queries.
  • HeatWave tpch Quickstart: Describes how to add a HeatWave cluster to a MySQL DB system, import the tpch sample database into the DB system using the MySQL Shell Parallel Table Import utility, manually load data into HeatWave, and run queries.
  • HeatWave airportdb Quickstart: Describes how to add a HeatWave cluster to a MySQL DB system, import the airportdb sample database into the DB system using the MySQL Shell Dump Load utility, load data into HeatWave using Auto Parallel Load, and run queries.