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.

mysql

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.

mysql

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.

Banner


AI Breakthrough For Robot Surgery
17/11/2024

Using imitation learning, a robot has learned to perform surgical procedures as skillfully as human surgeons, bringing the field of robotic surgery closer to true autonomy.



Apache Releases Tomcat 11
07/11/2024

Apache has announced the release of Tomcat 11, as well as marking the 25th anniversary of the first commit to the Apache Tomcat source code repository since becoming an ASF project.


More News

espbook

 

Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Friday, 30 September 2022 )