What is MySQL HeatWave?

MySQL HeatWave is a cloud database service that integrates enhanced analytics processing capabilities directly into the MySQL database engine. It is part of the Oracle MySQL Database Service available on Oracle Cloud Infrastructure (OCI), Amazon Web Services (AWS), and Microsoft Azure.

How MySQL HeatWave Works

Traditionally, MySQL has been focused on online transaction processing (OLTP) workloads for applications and services. HeatWave adds the ability to run complex operational analytics queries at high speed on the same live MySQL database by incorporating an in-memory parallel query accelerator.

The core of HeatWave is a high-performance query processing engine that processes analytical SQL queries entirely in cloud memory, without requiring a separate analytics database or data duplication through extract, transform, load (ETL) processes. It uses massively parallel processing to scan and compute on raw MySQL database records loaded into a distributed in-memory storage area.

By avoiding data movement and keeping analytics processing within the MySQL database, HeatWave can query data at high speeds with minimal latency. MySQL HeatWave also comes loaded with MySQL Enterprise feature sets and functionality. Oracle claims HeatWave provides 1,400x faster analytics performance than Amazon RDS Aurora and 6-7x faster than AWS Redshift and Snowflake, based on their benchmarks.

Key Capabilities of MySQL HeatWave

Some of the key capabilities and attributes of MySQL HeatWave include:

• Process high-speed SQL queries on live transactional MySQL data using massively parallel in-memory processing.
• Linearly scale analytics performance by adding more cloud compute and memory resources
• Unified architecture combining OLTP and analytics on the same MySQL database instance
• Machine learning capabilities to develop, train, explain, and deploy models on database data
• Automated management of in-memory data buffering, memory usage, and query execution
• Leverages existing MySQL database security capabilities like encryption and access control
• Support for Javascript
• Support for JSON acceleration functions in HeatWave

What is MySQL HeatWave Lakehouse?

MySQL HeatWave Lakehouse enables the processing and querying of hundreds of terabytes of data stored in object storage, including diverse file formats such as CSV, Parquet, and more. This technology facilitates a unified approach to managing transaction processing, analytics, and machine learning.

What is MySQL HeatWave AutoML?

HeatWave AutoML is designed to optimize the machine learning lifecycle, leveraging Oracle AutoML technology to automate the training process of machine learning models, from preprocessing, automated model selection to hyper parameter auto tuning.

This technology not only simplifies the model development process but also enhances its efficiency by enabling the analysis and utilization of data without the necessity of exporting it from the database. This in-situ processing ensures data security, maintains integrity, and accelerates the time-to-insight for businesses aiming to leverage their data assets for competitive advantage.

MySQL HeatWave Use Cases

MySQL HeatWave is targeted at enterprises aiming to simplify their database architecture while gaining faster operational analytics on live transaction data. Use cases include:

• Real-time analysis on frequently changing transaction data like sales, logistics, etc.
• Embedding analytics directly in data-intensive applications and services
• Consolidating OLTP and OLAP for reduced complexity and costs
• Accelerating existing MySQL-based business intelligence/analytics workloads
• Running operational machine learning models on live database data
• Innovating with AI applications through HeatWave’s support for Vector Store and Search.

While offering performance advantages, HeatWave does introduce new architectural considerations around data integration, resource allocation, and oversight of the in-memory processing that enterprises will need to evaluate. Connect with our experts to learn more about how to get the most out of MySQL HeatWave. We’ll help you explore options for your specific use case and work with you to develop proof of concepts.