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


Black Friday/Cyber Monday Offer For Coursera Plus
24/11/2022

Coursera is the leading provider of online Computer Science and Data Science courses, at all levels beginner to advanced. An annual Coursera Plus subscription gives access to the majority of Coursera' [ ... ]



JetBrains Releases Aqua Preview
07/11/2022

JetBrains has released a public preview of a new test automation product. Aqua is described as providing powerful tools for test automation engineers, along with a combination of language-specifi [ ... ]


More News

picobook

 



 

Comments




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

Last Updated ( Friday, 30 September 2022 )