HeatWave Release Notes
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 MySQL.
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.