Introduction

MySQL HeatWave is the only MySQL based service that combines transaction processing, real-time analytics, and machine learning within one single database. MySQL HeatWave eliminates the need for complex, time-consuming ETL operations between separate databases and tools for OLTP, analytics, and machine learning use cases. Customers avoid the latency and security risks of data movement between data stores while reducing costs. MySQL HeatWave also includes MySQL Autopilot, providing workload-aware, machine learning-powered automation of various aspects of the database system lifecycle.

All these MySQL HeatWave capabilities, which are built, managed, and continuously supported by the MySQL HeatWave development team, are now available on AWS. All components of the MySQL HeatWave service on AWS, namely the service console, control plane, and data plane, are built and optimized for AWS. MySQL HeatWave runs natively inside AWS which enables customers with applications already deployed in AWS to benefit from MySQL HeatWave without incurring the latency associated with accessing a database service running outside of AWS. Customers also don’t incur the high data egress fees charged by AWS that would be necessary to migrate data to a service running outside of AWS. Lastly, the tight integration of MySQL HeatWave with the AWS infrastructure, e.g. Amazon S3, CloudWatch, PrivateLink, makes it easy for developers to rely on MySQL HeatWave for new applications.

With its superior data-processing architecture and optimization for AWS infrastructure, MySQL HeatWave on AWS delivers unmatched performance and price-performance. On the 4TB TPC-H benchmark, MySQL HeatWave on AWS delivers 7x better price performance than Amazon Redshift, 10x better than Snowflake, 12x better than Google BigQuery and 4x better than Azure Synapse. For machine learning. For machine learning, MySQL HeatWave on AWS is 25X faster than Redshift ML. On a 10GB TPC-C workload, MySQL HeatWave offers up to 10X higher and sustained throughput compared to Amazon Aurora at high concurrency. All of these fully transparent benchmark scripts are available on GitHub for customers to replicate.

Native Integration with AWS

MySQL HeatWave on AWS delivers a true native experience for AWS customers. The console, control plane, and data plane completely reside in AWS and are responsible for managing the MySQL HeatWave database resources in AWS. The control plane communicates with Oracle Cloud Infrastructure (OCI) Identity for account management, and with OCI metering & billing for monitoring and managing the usage and expenses associated with the customer’s account.

Once the user signs up for an OCI cloud account and registers their OCI account with MySQL HeatWave on AWS, the main interactions with the MySQL HeatWave service take place in AWS, through the service console hosted at cloud.mysql.com. The MySQL HeatWave console relies on the RESTful API provided by the MySQL HeatWave control plane to handle the user requests.

MySQL HeatWave on AWS hosts all of the customer databases components in a dedicated AWS account and strictly isolates them from the service control plane components and other database systems managed by the control plane.

MySQL HeatWave databases are hosted on AWS services, which are publicly available to AWS customers, such as Elastic Compute Cloud (EC2) for data processing, Elastic Block Storage (EBS) for storage, and VPC for resource isolation. Customers do not have access to the infrastructure on which the database runs, such as the database host machines or storage; they are provided with a MySQL endpoint, which can be accessed by a standard MySQL client. Customers can restrict the client addresses that can access their database systems through the MySQL endpoint and the connection between the client and database system is secured with TLSv1.2. Using the MySQL endpoint, customers can run any application against their MySQL HeatWave database systems.

MySQL HeatWave Console

MySQL HeatWave has a new console which is designed to facilitate:

• Lifecycle management of the MySQL HeatWave resources, such as MySQL Database systems, MySQL backups, and HeatWave clusters.
• Ability to load data and execute queries from the console
• Integration of MySQL Autopilot capabilities in the console.
• Workload monitoring through visualization of the schema metadata and statistics that are stored on the MySQL server.
• Management and visualization of machine learning training, inference, and explanations

Interactive Query Interface & Workload Monitoring

Performance Monitoring

MySQL HeatWave Features on AWS

MySQL HeatWave provides a single database system for high-performance and secure transaction processing, real-time analytics, and machine learning. Each MySQL HeatWave database system consists of a MySQL Database node, mainly targeting transaction processing, and a configurable number of HeatWave nodes for analytical processing and machine learning tasks. MySQL HeatWave on AWS provides the best price/performance by optimizing all components of the underlying AWS infrastructure—while keeping costs as low as possible.

The built-in MySQL Autopilot provides workload-aware, machine learning-based automation of various aspects of the application lifecycle, including provisioning, data management, query execution, and failure handling. MySQL Autopilot features include auto provisioning, auto parallel loading, auto encoding, auto data placement, auto scheduling, auto query plan improvement, auto change propagation, and auto error handling. Combined, these features improve the performance of the application, reduce cost by predicting the optimal configuration to run a workload, and reduce manual database administration. MySQL Autopilot’s machine learning models, hosted in the database system, leverage the run time information like data and query statistics, memory, and network usage, providing continuous improvements over time. In addition to the automation features offered for the HeatWave analytics engine, MySQL Autopilot includes capabilities designed for OLTP workloads, which further improve the MySQL HeatWave price performance (more information provided further below).

Oracle provides the latest MySQL Enterprise Edition version in MySQL HeatWave on AWS, which contains the state-of-the-art performance, functionalities and security features developed, maintained, and supported by the MySQL team at Oracle. With each new release of the MySQL server, customers of MySQL HeatWave on AWS will have immediate access to the new features that are developed and tailored for the AWS infrastructure to maximize performance and security. Some of the performance and security features in the first release of MySQL HeatWave on AWS are presented in the following sections.

A number of new features have been introduced as a part of this service:

• New MySQL Autopilot features for OLTP: MySQL Autopilot is now enhanced with two new features to provide workload-aware, machine learning-powered automation capabilities for OLTP workloads—to further improve performance and throughput while enabling cost savings:

  • Auto Shape Prediction: To alleviate the burden of experimenting with different MySQL shapes to determine the most performant shape for a given workload, Auto Shape Prediction provides suggestions for the right MySQL server shape, based on highly accurate predictions from machine-learning models inside the MySQL server and the most recent query execution metrics and traces. SInce Auto Shape Prediction continuously collects workload execution statistics, it can adapt to the evolving workload patterns and hence provide the customer with suggestions based on the most recent workload.

  • Auto Thread Pooling: With Auto Thread Pooling, MySQL HeatWave prioritizes not only peak single-thread performance, but also high throughput in the presence of concurrent clients running concurrent queries on a MySQL server. With this feature, the MySQL server now can perform workload-aware admission control of the incoming transactions. It eliminates the resource contention created by too many awaiting transactions, automatically queuing them to maximize performance while sustaining the throughput in the face of high concurrency.

• Advanced security and compliance features: MySQL HeatWave on AWS includes several comprehensive security features natively implemented in the MySQL server, as opposed to other services such as Amazon Aurora, which provide security methods as an additional layer on top of the database.

  • Data masking and de-identification: Helps organizations protect sensitive data from unauthorized users by hiding and replacing real values with substitutes.

  • Asymmetric encryption: Enables developers and DBAs to increase the protection of confidential data and comply with regulatory requirements including HIPAA, Sarbanes-Oxley, and the PCI Data Security Standard, through encryption, key generation, digital signatures, and other cryptographic features.

  • Database firewall: Provides real-time protection against database-specific attacks such as SQL injections, by monitoring, alerting, and blocking unauthorized database activity without any changes in the application.

Analytic Processing

• Optimized and tuned for peak performance and best price performance: As the MySQL server, the HeatWave analytical processing engine is tuned to achieve the best performance on the AWS infrastructure. To minimize costs on AWS, the HeatWave processing engine is enhanced with aggressive compression of the in-memory data, which helps to reduce the memory footprint, hence the number of required processing nodes, without sacrificing peak performance.
• Support for smaller datasets: HeatWave has been mainly designed to meet the needs of very large datasets by utilizing many processing nodes with large memory capacities. To enable OLTP databases with smaller datasets to benefit from the capabilities of the HeatWave engine, MySQL HeatWave on AWS provides customers the option of selecting a smaller HeatWave cluster shape, enabling them to benefit from the high performance of HeatWave at a lower cost.

With its superior data-processing architecture and optimization for AWS infrastructure, MySQL HeatWave on AWS delivers unmatched performance and price-performance. On the 4TB TPC-H benchmark, MySQL HeatWave on AWS delivers 7x better price performance than Amazon Redshift, 10x better than Snowflake, 12x better than Google BigQuery and 4x better than Azure Synapse. For machine learning. For machine learning, MySQL HeatWave on AWS is 25X faster than Redshift ML. On a 10GB TPC-C workload, MySQL HeatWave offers up to 10X higher and sustained throughput compared to Amazon Aurora at high concurrency. All of these fully transparent benchmark scripts are available on GitHub for customers to replicate.

Machine Learning

HeatWave ML, integrated in the MySQL HeatWave service, provides fully automated in-database machine learning capabilities including training, inference, and explanation. This allows customers to securely leverage machine learning on real-time data without the complexity, latency, and cost of ETL. Since HeatWave ML stores all trained models inside the MySQL database, it eliminates the need for moving the models out of the MySQL HeatWave database system to an external machine learning tool or service.

In addition to enabling all the existing HeatWave ML features on AWS through the SQL interface, the MySQL HeatWave console on AWS enables HeatWave ML features through a user-friendly interface, further increasing the ease of use of the advanced HeatWave ML capabilities. To learn more about HeatWave ML, download our technical brief.

Conclusion

Oracle believes in giving customers a choice. By making MySQL HeatWave natively available on AWS, customers can very easily benefit from the only cloud database service that combines transactions, analytics, and machine learning services into one MySQL Database, delivering real-time, secure analytics without the complexity, latency, and cost of ETL duplication—on AWS. Customers don’t have to face exorbitant data egress fees charged by AWS and higher latency when accessing a database service running in Oracle’s cloud. MySQL HeatWave on AWS is optimized for AWS with a superior architecture that delivers higher performance and lower cost, as demonstrated by industry-standard benchmarks.