Oracle recently announced the general availability (GA) of MySQL Heatwave, a service that combines OLTP, analytics, machine learning, and machine learning-based automation within a single instance on AWS.

The company first released the cloud database service on Oracle Cloud Infrastructure (OCI) in 2020 to provide customers with a managed offering that integrates both online analytics and transaction processing capabilities. Later in 2022, autoML was added to the service. Now, it is available for the first time outside the Oracle Cloud Infrastructure – allowing users to run their transaction processing, analytics, and machine learning workloads in one service on AWS without needing ETL duplication between separate OLTP and OLAP databases.

Source: https://www.oracle.com/mysql/heatwave/

Peter Zaitsev, founder & CEO at Percona, tweeted:

Oracle finally admits nobody cares about Oracle Cloud and takes Heatwave to AWS, where previously it was one of unique "completing" features of OCI.

In a press release, Oracle announced several new capabilities for MySQL HeatWave on AWS. The service offers a native experience on AWS, the ability to monitor performance and the utilization of provisioned resources, and integration with MySQL Autopilot, which provides workload-aware, machine learning-based automation of the application lifecycle, including data management and query execution. In addition, it also offers comprehensive security features such as server-side data masking and de-identification, asymmetric data encryption, and a database firewall.

Sanjeev Mohan, a principal at Sanjmo, explains in a LinkedIn blog post:

The data plane, control plane, and console all run natively on AWS. The code base used for AWS is the same as the one used on OCI. However, Oracle has added several enhancements and integrated with AWS services, such as CloudWatch for monitoring resources and operational logs and metrics.

In the same press release, Oracle claims that MySQL HeatWave compared to other systems on AWS, provides better price performance. For instance, MySQL HeatWave on AWS delivers a price-performance seven times better than Amazon Redshift, ten times better than Snowflake, 12 times better than Google BigQuery, and four times better than Azure Synapse when running queries derived from the 4TB TPC-H benchmark.

Holger Mueller, VP and principal analyst, Constellation Research, said in one of the industry analyst statements on MySQL on AWS: 

The fact that the MySQL Engineering team can not only deliver the MySQL Heatwave offering on AWS but also provide architectural adaptations for better performance and TCO is another proof of the brilliance of the underlying software architecture.

In addition, Mueller told InfoQ:

Oracle is moving its software to the data on AWS, which will make potential adoption of customers on AWS with their data there - managed on competitive platforms - easier to migrate.

Lastly, MySQL HeatWave is now available in multiple clouds, OCI and AWS, with Microsoft Azure following soon.