Oracle Announces MySQL HeatWave on AWS (2023)

  • Click to view our Accessibility Policy
  • Skip to content

Press Release

Oracle Announces MySQL HeatWave on AWS

AWS users can now run transaction processing, real-time analytics, and machine learning in one service with MySQL

MySQL HeatWave delivers 7X better price performance compared to Amazon Redshift and 10X better than Snowflake, 25X faster than Redshift ML, and up to 10X higher throughput than Aurora

Austin, TX—September 12, 2022

Oracle Announces MySQL HeatWave on AWS (1)

Oracle today announced that MySQL HeatWave is available on Amazon Web Services (AWS). MySQL HeatWave is the only service that combines OLTP, analytics, machine learning, and machine learning-based automation within a single MySQL database. AWS users can now run transaction processing, analytics, and machine learning workloads in one service, without requiring time-consuming ETL duplication between separate databases such as Amazon Aurora for transaction processing and Amazon Redshift or Snowflake on AWS for analytics and SageMaker for machine learning.

“Oracle believes in giving customers a choice.Many of our MySQL HeatWave customers migrated from AWS.Others wish to continue running parts of their application on AWS. Those customers face serious challenges including exorbitant data egress fees charged by AWS and higher latency when accessing a database service running in Oracle’s cloud,” said Edward Screven, chief corporate architect, Oracle. “We are addressing these issues while delivering outstanding performance and price performance across transaction, analytics, and machine learning compared to other database cloud providers—even Amazon’s own databases running on AWS, where you’d think they would have an advantage.We wanted to offer AWS customers this choice to benefit from MySQL HeatWave innovation without moving their data from AWS, or developers needing to learn a new platform.”

Johnny Bytes is an innovative digital agency for web and app development based in Germany. “MySQL HeatWave on AWS simplifies our data platform with a consolidated database for both transaction processing and analytics,” said Thomas Henz, chief executive officer, Johnny Bytes. “We have seen 60-90X faster complex queries compared to AWS RDS and Aurora that generates real-time analytics we need for targeted, multichannel campaigns. We now have greater scalability to onboard more data and new clients of any size without increasing IT administration.”

As part of today’s news, Oracle is also introducing several new capabilities and benchmarks for MySQL HeatWave on AWS.

  • Unmatched performance and price performance: MySQL HeatWave on AWS is optimized for AWS with a superior architecture that delivers higher performance and lower cost compared to competitive offerings, as demonstrated by industry standard benchmarks. On the 4TB TPC-H* benchmark, MySQL HeatWave on AWS delivers price performance that is 7X better than Amazon Redshift, 10X better than Snowflake, 12X better than Google BigQuery, and 4X better than Azure Synapse. For machine learning, MySQL HeatWave on AWS is 25X faster than Redshift ML. On a 10GB TPC-C* workload, MySQL HeatWave offers up to 10X higher and sustained throughput compared to Amazon Aurora at high concurrency. All of these fully transparent benchmark scripts are available on GitHub for customers to replicate.
  • Native AWS experience: MySQL HeatWave on AWS delivers a true native experience for AWS customers through millisecond-level latencies for applications and a rich interactive console. It facilitates schema and data management, and executes queries interactively from the console. Users can monitor the performance of their queries and monitor the utilization of the provisioned resources. MySQL Autopilot is also integrated with the interactive console, making it easier to use.
  • Advanced security features: MySQL HeatWave service now offers several comprehensive security features which provide additional differentiation with Amazon Aurora. These include server-side data masking and de-identification, asymmetric data encryption, and a database firewall. Asymmetric data encryption enables developers and DBAs to increase the protection of confidential data and implement digital signatures to confirm the identity of people signing documents. Database firewall provides real-time protection against database-specific attacks, such as SQL Injections. These features are designed to provide best in class security for database users and provide a contrast with Aurora, where security methods are layered on top of the database.
  • MySQL Autopilot: Autopilot provides workload-aware, machine learning-based automation of various aspects of the application lifecycle, including provisioning, data management, query execution, and failure handling. Autopilot features include auto provisioning, auto parallel loading, auto encoding, auto data placement, auto scheduling, auto query plan improvement, auto change propagation, and auto error handling. Combined, these features improve performance of the application, reduce cost by predicting the optimal configuration to run a workload, and reduce manual database administration. Today, Oracle is introducing additional Autopilot capabilities designed for OLTP workloads which further improve MySQL HeatWave price performance compared to Amazon Aurora. Auto thread pooling provides higher and sustained throughput at high concurrency by determining the optimal number of transactions which should be executed. Auto shape prediction determines the optimal shape which should be provisioned to provide the best price performance for OLTP workloads. In a running system, the recommendation could be to continue using the existing shape, to upgrade to a larger shape for better performance or to downgrade to a smaller shape to reduce costs—whichever shape provides the best price performance.
  • Machine Learning: HeatWave ML provides in-database machine learning capabilities, including training, inference, and explanations. This enables customers to securely use machine learning on real-time data without the complexity, latency, and cost of ETL. HeatWave ML fully automates the ML lifecycle and stores all trained models inside the MySQL database, eliminating the need to move them to a separate machine learning tool or service. It’s available at no additional charge for MySQL HeatWave customers. No other cloud database vendor or open source database provides such advanced ML capabilities inside the database. On average, HeatWave ML trains models 25 times faster than Redshift ML and scales with the cluster size. MySQL HeatWave customers can now train models more often and keep them updated for increased prediction accuracy.

Ready for the Distributed Cloud

MySQL HeatWave is available in multiple clouds today, including OCI, AWS, and Microsoft Azure in the near future. It’s available on-premises as part of Oracle Dedicated Region Cloud@Customer for organizations that cannot move their database workloads to the public cloud. Customers can also replicate data from their on-premises MySQL OLTP applications to MySQL HeatWave on AWS or OCI to obtain near real-time analytics. MySQL HeatWave is always running the latest version of the MySQL database which is not the case for many of the other MySQL based services.

“While AWS offers a smorgasbord of cloud database services specialized for each data type and capability, MySQL HeatWave on AWS follows Oracle’s converged database strategy—offering transaction, analytics, ML, and Autopilot automation all in one. For AWS users, this means no charges for add-on services, extra storage, data egress fees, connectors, and more. For cost conscious IT teams and developers, MySQL HeatWave on AWS represents a whole new TCO calculation with zero cost for what are add-on services on AWS and no data egress fees,” said Marc Staimer, senior analyst, Wikibon. “And just as Usain Bolt left all of his competitors in the dust and set new world records that have yet to be broken, the latest price performance benchmark results demonstrate that MySQL HeatWave on AWS is 7X better than Amazon Redshift. If you follow the money, the choice is easy.”

Customer Commentary

Additional customers commenting on today’s news include:

(Video) Johnny Bytes boosts data and analytics with MySQL HeatWave on AWS

Anish Kumar, associate vice president at 6D Technologies, an India-based high-tech solution provider in the telecom industry with customers in over 80 countries, said “MySQL HeatWave on AWS has 139X faster complex queries compared to Amazon RDS and Aurora that gives us a great opportunity to simplify our data infrastructure for both OLTP and OLAP with sub-second response time. Also, the web console is easy to configure and provides us the visibility to workload-related performance metrics with interactive reporting. MySQL HeatWave is a great fit for our microservices and cloud native product roadmap to deliver a superior experience and performance for our customers.”

ITSP, Inc. is a high-tech solution provider and Oracle partner, based in Canada. “MySQL HeatWave on AWS is a game changer. We were pleasantly surprised with the ease-of-use and performance with 10-30X faster queries without complicated database tuning and performance improvement, using a similar database configuration,” said Wenjin Zhou, PhD, chief technology officer, ITSP, Inc. “With a single database for OLTP and OLAP workloads for large volume of data sets, we no longer need index creation and maintenance which accelerates time-to-value for our clients.”

U.S.-based Centroid Systems is a leading cloud services and technology company with over 200 customers and is an Oracle partner for more than 20 years. “We found MySQL HeatWave on AWS improved query performance by 15X with no changes to our application compared to using MariaDB on AWS RDS,” said Ajay Arora, chief technology officer, Centroid. “With MariaDB for analytics along with Tableau for visualization, we had been experiencing multiple outages because of the volume of data and patches impacting the SQL query performance. The performance gains from MySQL HeatWave gave our business confidence to expand and bring more offerings to the market.”

LeanTaaS is a predictive analytics and machine learning company that transforms healthcare operations through its platform, iQueue, for over 490 hospitals and 125 health systems in the United States. “MySQL HeatWave on AWS is an excellent solution for us as a small team. Having one database for both OLTP and OLAP workloads with 6X better performance compared to AWS RDS delivers real-time insights that helps us to continually enhance our iQueue platform, improve the user experience, and reduce complexity and administrative overhead for our team,” said Gokhan Oner, senior engineering manager, LeanTaaS.

Bionime is a Taiwan-based, leading medical device manufacturer for diabetes monitoring systems in more than 100 countries. “MySQL HeatWave on AWS has 50X faster complex queries compared to AWS RDS and that not only provides us with real-time insights to accelerate application development, but also helps us improve patients’ lives,” said Kyle Yang, assistant manager, Bionime.

Additional Resources

* Benchmark queries are derived from the TPC benchmarks, but results are not comparable to published TPC benchmarks results since these do not comply with the TPC specifications.

(Video) Oracle Announces MySQL HeatWave on AWS | #oracle #mysql #aws

Contact Info

  • Acacia Krebs

  • Oracle PR
  • +1.406.550.2724
(Video) What is MySQL HeatWave?

About Oracle

Oracle offers integrated suites of applications plus secure, autonomous infrastructure in the Oracle Cloud. For more information about Oracle (NYSE: ORCL), please visit us at


Oracle, Java, and MySQL are registered trademarks of Oracle Corporation.

“Safe Harbor” Statement

Statements in this press release relating to Oracle’s future plans, expectations, beliefs, intentions and prospects are “forward-looking statements” and are subject to material risks and uncertainties. A detailed discussion of these factors and other risks that affect our business is contained in Oracle’s Securities and Exchange Commission (SEC) filings, including our most recent reports on Form 10-K and Form 10-Q under the heading “Risk Factors.” These filings are available on the SEC’s website or on Oracle’s website at All information in this press release is current as of September 12, 2022, and Oracle undertakes no duty to update any statement in light of new information or future events.

(Video) MySQL Heatwave Overview

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, timing, and pricing of any features or functionality described for Oracle’s products may change and remains at the sole discretion of Oracle Corporation.

(Video) Oracle Announces MySQL HeatWave on AWS


What is Oracle MySQL HeatWave? ›

Oracle MySQL HeatWave is the only MySQL cloud service with a built-in, high performance, in-memory query accelerator—HeatWave. It increases MySQL performance by orders of magnitude for analytics and mixed workloads without any changes to current applications.

Who owns MySQL HeatWave? ›

Sept 12 (Reuters) - Oracle Corp (ORCL. N) has started to offer MySQL HeatWave, its cloud database service for transactions, analytics and machine learning, on Amazon's AWS cloud, allowing customers whose data is already parked there to use the service, the U.S. company said on Monday.

Is MySQL HeatWave good? ›

TCO/Performance Analysis

Based on TPC-DS and TPC-H benchmarks for OLAP, MySQL HeatWave has demonstrated a performance advantage of 58% over AWS, 154% over Snowflake, 293% over GCP, and 347% over Azure. And again, that is without the ongoing ETL process latencies and added cost.

Why is MySQL a dolphin? ›

The MySQL logo is a dolphin named Sakila. The name was chosen from a large list suggested by users during the “Name the Dolphin” contest. The winning name was submitted by Ambrose Twebaze, an open source software developer from Eswatini (formerly Swaziland), Africa.

Is Snowflake better than Oracle? ›

Snowflake might be easier to use and work out cheaper because of its ability to pause clusters when not running queries. However, Oracle comes with support for cursors and in-built machine learning capabilities, helping you program and generate advanced insights from workloads.

Who bought MariaDB? ›

On 16 January 2008, MySQL AB announced that it had agreed to be acquired by Sun Microsystems for approximately $1 billion. The acquisition completed on 26 February 2008. Sun was then bought the following year by Oracle Corporation.
Available inEnglish
LicenseGPLv2, LGPLv2.1 (client libraries)
12 more rows

Who owns heat waves? ›

Each pair of glasses is fully customizable with swappable lenses, arms and frames for a truly unique product. A little bit about Heat Wave Visual®: Heat Wave Visual®, founded by two individuals Justin Hertel, and Doug Karlson who sought to bring something more to the table in the eyewear market.

Is MySQL HeatWave free? ›

Try MySQL HeatWave for free.

Is MySQL better than Oracle? ›

In terms of software, Oracle is the more powerful one because of its extra features over the basic MySQL. It also supports parallel and distributed Databases and offers better indexing because of which can have a competitive advantage over MySQL.

Is MySQL end of life? ›

MySQL 5.7 – Community end of life planned until October, 2023. Amazon RDS for MySQL will continue to support until the community EOL date. MySQL 8.0 – Community end of life planned until April, 2026.
Version upgrade choices in Amazon RDS for MySQL.
Current VersionMajor Version Upgrade Path
MySQL 5.7MySQL 8.0
2 more rows
21 Jan 2021

Does Netflix use MySQL? ›

Migrating Data To SimpleDB and S3

In the Netflix data center, we primarily use Oracle to persist data. In parts of the movie recommendation infrastructure, we use MySQL. Both are relational databases.

Is MariaDB replacing MySQL? ›

Yes, it is possible to replace MySQL with MariaDB. MariaDB is considered to be a drop-in replacement for the corresponding MySQL version (i.e MariaDB 10.2 and MySQL 5.7). Please review feature differences between MariaDB and MySQL to make sure the switch won't affect applications using database server.

Is snowflake like MySQL? ›

For all other functions like aggregate functions and window functions, snowflake performs faster than mysql. For scalar functions like logarithmic, trigonometric and rounding functions, there is not a significant difference in the performance between snowflake and mysql.

What is hot block in Oracle? ›

A hot block is one that is accessed disproportionately often. One example would be an index block where the index is generated via a sequence; the database will need to write to the same block with the next value over and over again. This can make parallel operations difficult.

What is hot cloning in Oracle Database? ›

Oracle Database Cloning is nothing but a procedure that is used to create an identical database of the existing Oracle database. The cloning technique is used to make a copy of the existing Database to perform various test activities by DBA like backup and recovery.

What is hot backup in MySQL? ›

Hot Backups

The mysqlbackup command, part of the MySQL Enterprise Backup component, lets you back up a running MySQL instance, including InnoDB tables, with minimal disruption to operations while producing a consistent snapshot of the database.

What happens during hot backup in Oracle? ›

* During the hot backups the entire block containing a changed record, not just the changed record, is written to the archive log, requiring more archive space for this period. The hot backup consists of three processes: The tablespace data files are backed up. The archived redo logs are backed up.

How many types of blocks are there in Oracle? ›

There are three types of blocks that make up a PL/SQL program: Anonymous blocks: These are the unnamed PL/SQL blocks that are embedded within an application or are issued interactively. Procedures: These are the named PL/SQL blocks.

What is temp space in Oracle? ›

Temporary tablespaces are used for storing temporary data, as would be created when SQL statements perform sort operations. An Oracle database gets a temporary tablespace when the database is created. You would create another temporary tablespace if you were creating a temporary tablespace group.

What are three types of PL SQL blocks? ›

A PL/SQL block is defined by the keywords DECLARE , BEGIN , EXCEPTION , and END . These keywords partition the block into a declarative part, an executable part, and an exception-handling part. Only the executable part is required.

What is hot backup and cold backup in Oracle? ›

A hot backup is used when a full backup is needed and the service level does not allow system downtime for a cold backup. Cold backup—Users cannot modify the database during a cold backup, so the database and the backup copy are always synchronized.

How do you clone a CDB? ›

To clone a PDB to a different CDB, we may take the following steps:
  1. Close the source PDB.
  2. Open the source PDB to READ ONLY.
  3. Create a database link to the source CDB.
  4. Clone the target PDB from the remote database via a database link.
  5. Open the target PDB to READ WRITE.
21 Oct 2015

Why do we clone a database? ›

Database cloning is the process of creating a point-in-time copy of a production database or its backup set. Cloned databases can be used for multiple purposes: During application development cycles for testing functionality that has to be implemented using the current database structure and content.

What are the 3 types of backups? ›

The most common backup types are a full backup, incremental backup and differential backup. Other backup types include synthetic full backups and mirroring.

What are the 4 types backup? ›

Each backup program has its own approach in executing the backup, but there are four common types of backup implemented and generally used in most of these programs: full backup, differential backup, incremental backup and mirror backup.

What are the main 3 types of backups in SQL? ›

A backup of data in a complete database (a database backup), a partial database (a partial backup), or a set of data files or filegroups (a file backup).

Which tool is used for hot backup? ›

As you can see, the powerful hot backup software AOMEI Backupper can help you perform hot backup in an easy and quick way.

Is Mysqldump a hot backup? ›

mysqldump is also an option - note that mysqldump is not a hot backup tool by default (especially if your tables are using multiple storage engines or the tables are being locked during the backup), but if your tables are only using the InnoDB storage engine and you use the --single-transaction option when using ...

What are the 3 different Oracle Database shutdown modes? ›

You cannot shut down a database if you are connected to the database through a shared server process. There are several modes for shutting down a database: normal, immediate, transactional, and abort.


1. 6D Technologies demystifies data with MySQL HeatWave on AWS
2. Oracle Brings HeatWave To AWS
(Business News)
3. How to Import Data from AWS to MySQL HeatWave
4. Video Exclusive: Oracle Announces New MySQL HeatWave Capabilities
(SiliconANGLE theCUBE)
5. Bionime modernizes data and analytics with MySQL HeatWave on AWS
6. The Truth About MySQL HeatWave
(SiliconANGLE theCUBE)
Top Articles
Latest Posts
Article information

Author: Msgr. Refugio Daniel

Last Updated: 05/16/2023

Views: 6403

Rating: 4.3 / 5 (74 voted)

Reviews: 89% of readers found this page helpful

Author information

Name: Msgr. Refugio Daniel

Birthday: 1999-09-15

Address: 8416 Beatty Center, Derekfort, VA 72092-0500

Phone: +6838967160603

Job: Mining Executive

Hobby: Woodworking, Knitting, Fishing, Coffee roasting, Kayaking, Horseback riding, Kite flying

Introduction: My name is Msgr. Refugio Daniel, I am a fine, precious, encouraging, calm, glamorous, vivacious, friendly person who loves writing and wants to share my knowledge and understanding with you.