No results found

Your search did not match any results.

We suggest you try the following to help find what you’re looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.
Trending Questions
 

HeatWave

HeatWave is a new, integrated, high-performance, in-memory query accelerator for MySQL Database Service that accelerates MySQL performance by orders of magnitude for analytics and transactional queries. HeatWave scales out to thousands of cores, is 1100X faster than Amazon Aurora, and 2.7X faster than Amazon Redshift at one-third the cost. MySQL Database Service, with HeatWave, is the only service that enables database admins and app developers 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 service is optimized for and exclusively available in Oracle Cloud Infrastructure (OCI).

heatwave in the MySQL market Oracle unleashes a heatwave in the MySQL market

Leading analyst Patrick Moorhead measures how HeatWave compares to other MySQL offerings.

turbo boost HeatWave gives MySQL a Turbo Boost

Discover what makes HeatWave unique and how customers benefit in this theCUBE interview.

sql market Oracle cranks up the heat in the MySQL market

dbInsight reviews how Oracle MySQL Database Service, with HeatWave, redefines MySQL.

heatwave enables insight to action HeatWave enables the holy grail of insight to action

Constellation Research examines Oracle MySQL Database Service with HeatWave and concludes that it offers the best of both worlds in a breathtaking, elegant architecture.

Oracle Live: MySQL Database Service New HeatWave Innovations

Tuesday, August 10, 2021 12 noon ET / 1 PM BRT / 6 PM CEST

HeatWave Benchmarks

Performance and price comparison with Snowflake, Amazon Redshift, Azure Synapse Analytics, Google BigQuery

Performance and price comparison with Snowflake, Amazon Redshift, Azure Synapse Analytics, Google BigQuery

HeatWave is the fastest and the cheapest service

  • Numbers for TPCH derived from Gigaom report of October 2020, TPCDS from Gigaom report of February 2021
  • 67 TPCDS queries executed on HeatWave – comparing performance of only those queries for all services
  • Using PAYG pricing. Other prices are based on 1 year pricing

Price/performance comparison with Snowflake, Amazon Redshift, Azure Synapse Analytics, Google BigQuery

Price/performance comparison with Snowflake, Amazon Redshift, Azure Synapse Analytics, Google BigQuery

HeatWave offers 25x-40x better price/performance compared to Snowflake

  • Numbers for TPCH derived from GigaOm report of Oct 2020, TPCDS from GigaOm Report of Feb 2021
  • 67 TPCDS queries have been executed

Learn more about the benchmark setup configuration

HeatWave performance comparisons

See documented performance comparisons that show how HeatWave is 400X faster than MySQL Database, 2.7X faster than Amazon Redshift, and 1100X faster than Amazon Aurora.

Built-in real-time query accelerator for MySQL Database Service

New integrated, high-performance in-memory query accelerator

In-memory query accelerator for SQL queries

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 mixed workloads comprised of analytic and transactional queries. HeatWave is optimized for and exclusively available on Oracle Cloud Infrastructure (OCI).

Architected for massive scale and performance

HeatWave enables in-memory vectorized processing, massive inter-and intra-node parallelism, and distributed query processing. This is facilitated by an in-memory, massively partitioned architecture and overlapping computation with network communication tasks.

Optimized for OCI

Query processing has been optimized for OCI. The sizes of the partitions have been optimized to fit the cache of the underlying shapes. The overlap of compute with communication is optimized for the network bandwidth between two nodes in OCI. Various analytics processing primitives use the hardware instructions of the underlying shapes.

Machine-learning automation

HeatWave uses machine learning to intelligently automate operations such as provisioning, increasing DBA productivity and reducing costs.

HeatWave technical brief (PDF)

MySQL delivers real-time analytics

Real-time analytics

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.

Read the Gartner newsletter: HeatWave Turbocharges MySQL Database Service (PDF)

400X faster performance for complex queries

HeatWave accelerates MySQL queries by 400X using massively parallel processing to provide real-time analytics. The acceleration is higher when the database size is bigger.

1100X faster than Amazon Aurora

HeatWave is 1100X faster than Amazon Aurora.

2.7X faster than Amazon Redshift

HeatWave is 2.7X faster than Amazon Redshift using in-memory analytics.

Highly scalable

HeatWave can scale up to thousands of OCI cores.

Cheaper than Amazon

One-third the cost of Amazon Redshift

HeatWave is one-third the cost of Amazon Redshift.

One-third the cost of Amazon Aurora

HeatWave is one-third the cost of Amazon Aurora.

Easy migration from Amazon RDS

MySQL Shell provides utilities that enable users to easily migrate from Amazon RDS to MySQL Database Service.

Single database for OLTP and OLAP

Unique built-in in-memory query accelerator

Oracle MySQL Database Service, with its integrated HeatWave, is the only service that enables database admins and app developers to run OLTP and OLAP workloads directly from their MySQL database.

Eliminate ETL

Eliminate the cost, complexity, and risk of the lengthy extraction, transform, load (ETL) processes that are required when using separate databases for OLTP and OLAP.

Improve security

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.

Faster business insights

HeatWave enables customers to query operational data in real time to make better, faster business decisions.

No changes to MySQL applications or queries

HeatWave is a native MySQL solution. Existing MySQL applications work without changes.

BI and data visualization tools

HeatWave supports the same BI and data visualization tools as MySQL Database, such as Oracle Analytics Cloud, Tableau, and Looker.

We successfully migrated our in-house built digital marketing and media management applications from AWS Aurora to MySQL Database Service with HeatWave on OCI recently. We observed over 1000x improvement for some of our queries and 85% performance improvement in our workload overall by migrating to MySQL HeatWave. In addition, we didn't have to make any change to our application and our cost dropped to 40% of the AWS Aurora cost with MySQL HeatWave.

Amit Palshikar CTO, Red3i

HeatWave is 10 times faster than the analytics service of another major cloud vendor. Now there is no need for ETL. Compared to MySQL on-premises, HeatWave is 4,000 times faster.

Tetsuro IkedaManager, Cloud IT Architecture Service Department, SCSK Corporation

Oracle MySQL Database Service with HeatWave vaporizes Amazon Redshift AQUA, Snowflake, Azure Synapse Analytics and Google BigQuery

DSC reviews how Oracle MySQL Database Service with HeatWave solves the MySQL complex queries and analytics problem.

December 16, 2020

HeatWave: Technical Deep Dive

Nipun Agarwal, Vice President, Research and Advanced Development

Four key architecture choices provide compelling performance with HeatWave:
1. An in-memory hybrid columnar format which is conducive to vector processing.
2. A massively parallel architecture that is enabled by a massively partitioned architecture.
3. State of the art algorithms for distributed analytic algorithms.
4. The engine is optimized for Oracle Cloud Infrastructure.

Read the complete post

Use cases for HeatWave

  • Deliver real-time data analytics

    MySQL 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.

  • Hybrid cloud deployment flexibility

    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.

Pricing

MySQL Database Service

Product
Unit price
Metric
MySQL HeatWave-Standard-E3

Node per hour
MySQL Database for HeatWave-Standard-E3

Node per hour
MySQL Database—Storage

Gigabyte storage capacity per month
MySQL Database—Backup Storage

Gigabyte storage capacity per month

Resources

Documentation

Documentation

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.

Customer community

Customer community

Join the conversation by visiting the MySQL Database Service customer forum.

Cloud learning

Cloud learning

Get the most out of MySQL Database Service with a MySQL Learning Subscription.

Support and services

Support and services

Get 24x7 access to MySQL support with My Oracle Support.

Related products

MySQL

World's #1 open source database

Oracle Analytics Cloud

Modern self-service analytics

Oracle Data Integrator

Simplifying data integration

Oracle Cloud Compute

Get the best price-performance

Get started with HeatWave


Try MySQL Database Service for free

Explore with $300 in free credits.


Contact us

Interested in learning more? Contact one of our experts.