HeatWave is a massively parallel, high performance, in-memory query accelerator for Oracle MySQL Database Service that accelerates MySQL performance by orders of magnitude for analytics and mixed workloads. HeatWave is 6.5X faster than Amazon Redshift at half the cost, 7X faster than Snowflake at one-fifth the cost, and 1400X faster than Amazon Aurora at half the cost. MySQL Database Service with HeatWave is the only service that enables customers to run OLTP and OLAP workloads directly from their MySQL database. This eliminates the need for complex, time-consuming, and expensive data movement and integration with a separate analytics database. The new MySQL Autopilot uses advanced machine-learning techniques to automate HeatWave, which make it easier to use and further improves performance and scalability. HeatWave is optimized for Oracle Cloud Infrastructure (OCI).
Wikibon "strongly recommends that enterprise IT departments set a three-year plan to eliminate separate OLAP databases and ETL from MySQL transactional databases".
Constellation Research concludes "Customers using MySQL or MySQL-compatible databases should evaluate MySQL Database Service with HeatWave now."
"Machine learning puts MySQL on overdrive" according to the dbinsight analysis covering the latest HeatWave innovations.
Omdia notes: "Customers invested in any MySQL derivative, whether on premises or in cloud, should move to or stick with MySQL Database Service on OCI."
Watch Edward Screven, Chief Corporate Architect, Oracle, share the latest innovations, along with the latest benchmarks, that show the speed and cost savings gained with HeatWave.
Nipun Agarwal, Vice President, HeatWave and Advanced Development, Oracle, demonstrates how the new MySQL Autopilot increases the performance of HeatWave while saving significant time for developers and DBAs.
Pablo Lemos, Co-Founder and CTO of Tetris.co, describes how MySQL HeatWave dramatically reduced their Amazon Aurora and Redshift costs by over 50% while delivering real-time insights and enabling their expansion.
See documented performance comparisons that show how HeatWave is 6.5X faster than Amazon Redshift at half the cost, 1400X faster than Amazon Aurora at half the cost, and 5400X faster than Amazon RDS for MySQL at two-thirds the cost.
See the performance and learn more about the benchmark setup configuration
HeatWave is an in-memory query accelerator developed for Oracle MySQL Database Service. It’s a massively parallel, hybrid, columnar, query-processing engine with state-of-art algorithms for distributed query processing which provide very high performance for queries.
HeatWave has a highly partitioned architecture which enables massive inter- and intra-node parallelism. It has an intelligent query scheduler which overlaps computation with network communication tasks to achieve very high scalability across thousands of cores for real-world applications.
Query processing in HeatWave has been optimized for OCI. The sizes of the partitions have been optimized to fit the cache of the underlying shapes. The overlap of computation with communication is optimized for the network bandwidth available in OCI. Various analytics processing primitives use the hardware instructions of the underlying virtual machines (VMs).
MySQL Autopilot automates many of the most important and often challenging aspects of achieving high query performance at scale—including provisioning, data loading, query execution, and failure handling. It uses advanced techniques to sample data, collect statistics on data and queries, and build machine-learning models to model memory usage, network load, and execution time. These machine-learning models are then used by MySQL Autopilot to execute its core capabilities. MySQL Autopilot makes the HeatWave query optimizer increasingly intelligent as more queries are executed, resulting in continually improving system performance over time—a capability not available on Amazon Aurora, Amazon Redshift, Snowflake, or other MySQL-based database services. MySQL Autopilot is available at no additional charge for MySQL HeatWave customers.
MySQL Autopilot provides the following capabilities:
When data is loaded from MySQL into HeatWave, a copy of the in-memory representation is made to the scale-out data management layer built on the OCI object store. Any changes made to data in MySQL are transparently propagated to this data layer. When an operation requires reloading of data to HeatWave such as during error recovery, data can be accessed from the HeatWave data layer, in parallel, by multiple HeatWave nodes. This results in significant improvement in performance. For example, for a 10 TB HeatWave cluster, the time it takes to recover and reload data reduces from 7.5 hours to 4 minutes—over a 100X improvement.
MySQL HeatWave is faster than all the competing database services— and at a fraction of the cost. This has been demonstrated by multiple standard industry benchmarks like TPCH, TPCDS, CH-benCHmark—and on real-world customer workloads. See the 30 TB TPCH benchmark results shown above. Results from other benchmarks are here:
Most real world applications have a mix of OLTP and complex OLAP queries. For such workloads too, MySQL HeatWave is much faster and costs a fraction of Amazon Aurora. Using industry standard CH-benCHmark on a 100 GB dataset for OLAP queries, HeatWave is 18X faster, provides 110X better throughput, and 2.4X less cost than Amazon Aurora, resulting in 42X better price performance. For OLTP queries, HeatWave has the same performance as Amazon Aurora and is 2.4X less cost, resulting in 2.4X better price performance.
Oracle MySQL Database Service, with its integrated HeatWave, is the only service that enables database administrators and app developers to run OLTP and OLAP workloads directly from their MySQL database.
Eliminate the cost, complexity, and risk of the lengthy extraction, transform, and load (ETL) processes that are required when using separate databases for OLTP and OLAP.
Modifications made by OLTP transactions are propagated in real time to HeatWave and immediately visible for analytics queries. There’s no need to index the data before running analytics queries.
All data at rest and in transit between MySQL database and the nodes of the HeatWave cluster is encrypted by default. Since data isn’t transferred between databases, there’s no risk of it being compromised during the ETL process. Relying on a single database for OLTP and OLAP eliminates the need to have different identity management, improving security.
HeatWave is a native MySQL solution. Existing MySQL applications work without changes.
HeatWave supports the same BI and data visualization tools as MySQL Database Service, such as Oracle Analytics Cloud, Tableau, and Looker.
“These new fully transparent benchmarks demonstrate HeatWave’s performance, price and scale advantages over all other MySQL and cloud databases.”
“Oracle have shown AWS and Snowflake how to design and architect a true MySQL Cloud Database.”
“For those looking to extract the most out of their MySQL environments, HeatWave should be given a hard look.”
“Oracle brings out new innovations which are set to likely disrupt the market, significantly lifting the expectations for what open source cloud databases should be.”
The Futurum analysis concludes that "MySQL Database Service with HeatWave offers the best value bar none across the entire MySQL database market."
We recently introduced MySQL Autopilot for MySQL HeatWave. MySQL Autopilot automates many important and challenging aspects of achieving high query performance at scale - including provisioning, data loading, query execution and failure handling. MySQL Autopilot makes the HeatWave query optimizer increasingly intelligent as more queries are executed, resulting in continually improving system performance over time.
Read the complete postMySQL Database Service, with its integrated HeatWave, is the only offering in the industry that provides DBAs and developers with a single, unified MySQL platform for both OLTP and OLAP workloads. This simplifies application development, saves time, enables real-time queries, decreases costs, and improves security.
MySQL Database Service is 100% compatible with MySQL on-premises. Keep your OLTP workloads on-premises and offload your analytics workloads to HeatWave without changes to applications.
Product |
Unit price |
Metric |
MySQL HeatWave—Standard-E3 |
Node per hour |
|
MySQL Database for HeatWave—Standard-E3 |
Node per hour |
|
MySQL Database for HeatWave—Bare Metal Standard-E3 |
Node per hour |
|
MySQL Database—Storage |
Gigabyte storage capacity per month |
|
MySQL Database—Backup Storage |
Gigabyte storage capacity per month |
HeatWave is a new, in-memory query accelerator developed for MySQL Database Service. It’s a distributed, scalable, in-memory, hybrid columnar, query-processing engine designed for fast execution of analytic and transactional queries. HeatWave is optimized for and exclusively available on OCI.
Join the conversation by visiting the MySQL Database Service customer forum.
Get the most out of MySQL Database Service with a MySQL Learning Subscription.
Get 24x7 access to MySQL support with My Oracle Support.
Explore with $300 in free credits.
Interested in learning more? Contact one of our experts.