Table of Contents
HeatWave is a massively parallel, high performance, in-memory query accelerator that accelerates MySQL performance by orders of magnitude for analytics workloads, mixed workloads, and machine learning. HeatWave can be accessed through Oracle Cloud Infrastructure (OCI), Amazon Web Services (AWS), and Oracle Database Service for Azure (ODSA).
HeatWave consists of a MySQL DB System and HeatWave nodes. Analytics queries that meet certain prerequisites are automatically offloaded from the MySQL DB System to the HeatWave Cluster for accelerated processing. With a HeatWave Cluster, you can run online transaction processing (OLTP), online analytical processing (OLAP), and mixed workloads from the same MySQL database without requiring extract, transfer, and load (ETL), and without modifying your applications. For more information about the analytical capabilities of HeatWave, see Chapter 2, HeatWave.
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. The HeatWave nodes store data in memory
and process analytics and machine learning queries. Each HeatWave node
hosts an instance of the HeatWave query processing engine
(RAPID
).
Enabling a HeatWave Cluster also provides access to HeatWave AutoML, which is a
fully managed, highly scalable, cost-efficient, machine learning
solution for data stored in MySQL. HeatWave AutoML provides a simple SQL
interface for training and using predictive machine learning
models, which can be used by novice and experienced ML
practitioners alike. Machine learning expertise, specialized
tools, and algorithms are not required. With HeatWave AutoML, you can
train a model with a single call to an SQL routine. Similarly, you
can generate predictions with a single CALL
or
SELECT
statement which can be easily integrated
with your applications.