MySQL Heatwave Available On AWS
Written by Alex Denham   
Thursday, 29 September 2022

Oracle has announced that MySQL Heatwave is now available on Amazon AWS. MySQL Heatwave is a massively parallel, high performance, in-memory query accelerator for Oracle MySQL Database Service.

MySQL Database is a fully-managed Oracle Cloud Infrastructure service, developed, managed, and supported by the MySQL team in Oracle.


Heatwave is a MySQL Database service for transactions, analytics, and machine learning (ML) that until now has only been available on Oracle Cloud Infrastructure (OCI).

Heatwave is described by Oracle as accelerating MySQL performance by orders of magnitude for analytics and mixed workloads. MySQL Database Service with HeatWave can be used to run OLTP and OLAP workloads directly from a MySQL database, rather than having to move data and integrate with a separate analytics database.

Oracle says that on a 4 TB TPC-H benchmark, MySQL HeatWave on AWS provides price performance that is seven times better than Amazon Redshift, ten times better than Snowflake, twelve better than Google BigQuery, and four time better than Azure Synapse Analytics.  

Oracle has also introduced several new features for MySQL HeatWave on AWS, starting with an enhanced version of MySQL Autopilot that uses machine-learning techniques to automate HeatWave, making it easier to use. Autopilot provides workload-aware, machine learning-based automation of various aspects of the application lifecycle, including provisioning, data management, query execution, and failure handling. Oracle has now added extras options for OLTP workloads, including auto thread pooling for higher and sustained throughput at high concurrency, and auto shape prediction that works out the optimal shape which should be provisioned to provide the best price performance for OLTP workloads.

The new service also includes security features including server-side data masking and de-identification, asymmetric data encryption, and a database firewall. Asymmetric data encryption lets developers and DBAs increase the protection of confidential data and implement digital signatures. The database firewall provides real-time protection against database-specific attacks, such as SQL Injections.

MySQL Heatwave is available on Amazon AWS now.


More Information

MySQL site

Related Articles

 MySQL Reaches Milestone 8 Release

MySQL 5.7

Improved Performance In MySQL Developer Milestone Release

MySQL 5.7 Hits 1 million NoSQL Queries per Second

Amazon Launches Supercharged MySQL Alternative



To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.


Linus Torvalds Over Flows On Overflows In C

You may think of Linus Torvalds as the Linux guru, but he is also a leading expert on C and often ignored and misunderstood in this role. A recent exchange on the Linux Kernel mailing list demonstrate [ ... ]

Turing Chatbot Is Chief AI Officer

It was only a matter of time before it happened. A company has created an Alan Turing chatbot and has installed it as its Chief AI officer. A distasteful PR stunt to many, but it's more complicated th [ ... ]

More News

raspberry pi books



or email your comment to:

Last Updated ( Friday, 30 September 2022 )