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.
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 gives MySQL a Turbo Boost
Discover what makes HeatWave unique and how customers benefit in this theCUBE interview.
Oracle cranks up the heat in the MySQL market
dbInsight reviews how Oracle MySQL Database Service, with HeatWave, redefines MySQL.
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.
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.
HeatWave Benchmarks
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
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
Want to replicate these benchmarks? View the setup.
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.
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.
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
HeatWave: Technical Deep Dive
Nipun Agarwal, Vice President, Research and Advanced DevelopmentFour 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.
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
Benchmarks
View performance comparisons of HeatWave with MySQL Database, Amazon Redshift, and Amazon Aurora.
Oracle Live
Watch Edward Screven, Chief Corporate Architect, Oracle, unveil the new HeatWave.
Articles
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
Join the conversation by visiting the MySQL Database Service customer forum.
Cloud learning
Get the most out of MySQL Database Service with a MySQL Learning Subscription.
Support and services
Get 24x7 access to MySQL support with My Oracle Support.
Related products
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.