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


Traffic Light Security For IoT
09/11/2022

The US is set to introduce user friendly labeling for IoT devices - as if labeling solved the problem. It may sound like a good idea but there are big problems. Labeling for energy consumption is easy [ ... ]



Neo4j 5 Adds Autonomous Clustering
11/11/2022

There's a new version of Neo4j with improvements to its query performance, and the addition of support for autonomous clusters.  The Community Edition has received particular attention and the Ne [ ... ]


More News

picobook

 



 

Comments




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

Last Updated ( Friday, 30 September 2022 )