We’re sorry. We could not find a match for your search.

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.”
  • Start a new search.
Contact Us Sign in to Oracle Cloud

MySQL HeatWave Database Service

One MySQL Database service for transactions, analytics, and machine learning (ML). Real-time, secure analytics without the complexity, latency, and cost of extract, transform, and load (ETL) duplication.

One MySQL Database service for OLTP, OLAP, and ML

Oracle MySQL HeatWave is a fully managed database service, powered by the integrated HeatWave in-memory query accelerator. It’s the only cloud database service that combines transactions, analytics, and machine learning services into one MySQL Database, delivering real-time, secure analytics without the complexity, latency, and cost of ETL duplication.

What is MySQL video thumbnail
See what's possible with MySQL HeatWave (2:28)

MySQL HeatWave customer successes

Estuda.com MySQL HeatWave video
Estuda.com increases query responses by 300X with MySQL HeatWave

This K-12 educational SaaS provider in Brazil achieves real-time analytics with 300X faster complex query execution at 85% lower cost while supporting three million users—all to enhance student performance.

VRGlass MySQL HeatWave video
VRGlass increases database performance 5X with MySQL HeatWave

The Brazilian metaverse startup migrated all its data to MySQL HeatWave. Within 3 hours, it achieved 5X better database performance for an event with more than one million visitors with greater security and at the half the cost.

Genius Sonority MySQL HeatWave video
Genius Sonority speeds game analytics by 90X with MySQL HeatWave

This Japanese video game company gained real-time insights by adding HeatWave to MySQL Database Service, helping it meet its goal of continuously improving joyful entertainment for customers around the world.

Red3i logo
Red3i speeds insights by 1,000X with MySQL HeatWave

Digital marketing firm accelerates media and advertising insights by 1,000X and saves 60% in costs using MySQL HeatWave on Oracle Cloud Infrastructure.

Tetris.co logo
Tetris.co speeds real-time insights with MySQL HeatWave

The Brazilian martech company accelerates marketing insights in milliseconds and at half the cost with MySQL HeatWave on Oracle Cloud Infrastructure.

FANCOMI logo
FANCOMI accelerates ad analytics by 10X with MySQL HeatWave

Japan’s leading advertising network delivers real-time insights and significantly reduces costs with MySQL HeatWave and Autonomous Database.

Why MySQL HeatWave?

One MySQL Database service for OLTP and OLAP

MySQL HeatWave is the only service that enables developers and database administrators to run OLTP and OLAP workloads directly from their MySQL Database.

Eliminate ETL

Eliminate the complex, time-consuming, expensive ETL process and integration with a separate analytics database.

Deliver real-time analytics

Analytics queries always access the most up-to-date data as updates from transactions automatically replicate in real time to the HeatWave analytics cluster. There’s no need to index the data before running analytics queries.

Improve security

All data at rest and in transit between MySQL Database and the nodes of the HeatWave cluster is encrypted by default. There’s no risk of data being compromised during ETL since data isn’t transferred between databases.

No changes to MySQL applications

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

Use existing business intelligence (BI) and data visualization tools

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

High performance, in-memory query accelerator

HeatWave is an in-memory, massively parallel, hybrid columnar query-processing engine. It implements state-of-the-art algorithms for distributed query processing that provide very high performance.

Architected for massive scale and performance

HeatWave massively partitions data across a cluster of nodes, which can be operated in parallel. This provides excellent internodal scalability. Each node within a cluster and each core within a node can process partitioned data in parallel. HeatWave has an intelligent query scheduler that overlaps computation with network communication tasks to achieve very high scalability across thousands of cores.

Optimized for the cloud

Query processing in HeatWave has been optimized for commodity servers in the cloud. 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. Various analytics processing primitives use the hardware instructions of the underlying virtual machines (VMs).

MySQL Autopilot: machine-learning–powered automation

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 automate HeatWave, further improving performance and scalability and making it easier to use—saving developers and DBAs significant time. MySQL Autopilot is available at no additional charge for MySQL HeatWave customers.

MySQL Autopilot provides numerous capabilities including

  • Auto provisioning predicts the number of HeatWave nodes required for running a workload by adaptive sampling of table data on which analytics is required. This means developers and DBAs no longer need to manually estimate the optimal size of their cluster. No other database service provides this capability.
  • Auto data placement predicts the column on which tables should be partitioned in-memory to achieve the best performance for queries. It also predicts the expected gain in query performance with the new column recommendation. This minimizes data movement across nodes due to suboptimal choices that can be made by operators when manually selecting the column. No other database service provides this capability.
  • Auto query plan improvement learns various statistics from the execution of queries and improves the execution plan of future queries. This improves the performance of the system as more queries are run. No other database service provides this capability.
  • Auto encoding determines the optimal representation of columns being loaded into HeatWave, taking the queries into consideration. This optimal representation provides the best query performance and minimizes the size of the cluster to minimize costs.

In-database machine learning

HeatWave ML includes everything users need to build, train, deploy, and explain machine learning models within MySQL HeatWave, at no additional cost.

No need for a separate machine learning service

With native, in-database machine learning in MySQL HeatWave, customers don’t need to move data to a separate machine learning service. They can easily and securely apply machine learning training, inference, and explanation to data stored inside MySQL HeatWave. As a result, they can accelerate ML initiatives, increase security, and reduce costs.

Save time and effort with machine learning lifecycle automation

HeatWave ML automates the machine learning lifecycle, including algorithm selection, intelligent data sampling for model training, feature selection, and hyperparameter optimization—saving data analysts and data scientists significant time and effort.

Explainable ML models

All the models trained by HeatWave ML are explainable. HeatWave ML delivers predictions with an explanation of the results, helping organizations with regulatory compliance, fairness, repeatability, causality, and trust.

Use current skills

Developers and data analysts can build machine learning models using familiar SQL commands; they don’t have to learn new tools and languages. Additionally, HeatWave ML is integrated with popular notebooks such as Jupyter and Apache Zeppelin.

Fully managed database service

Improve productivity by automating time-consuming tasks such as high-availability management, patching, upgrades, and backup with a fully managed database service. Accelerate application development with instant provisioning of resources.

Built, managed, and supported by the MySQL engineering team

Developers can deliver modern, cloud native database applications with immediate access to the latest features from the MySQL team. MySQL HeatWave is 100% compatible with on-premises MySQL for a seamless transition to the cloud, without changes to applications.

Improve security and regulatory compliance

Advanced security protects your databases against external attacks, data breaches, and internal misuse of information. The latest MySQL security patches from the MySQL team are automatically applied to limit your exposure to security vulnerabilities.

Real-time elasticity

Real-time elasticity enables customers to increase or decrease the size of their HeatWave cluster by any number of nodes without incurring any downtime or read-only time.

Consistent high performance, even at peak times, and reduced costs with no downtime

The resizing operation takes only a few minutes, during which time HeatWave remains online, available for all operations. Once resized, data is downloaded from object storage, automatically rebalanced among all available cluster nodes, and becomes immediately available for queries. As a result, customers benefit from consistently high performance, even at peak times, and lower costs by downsizing their HeatWave cluster when appropriate—without incurring any downtime or read-only time.

No overprovisioned instances

Customers can expand or reduce their HeatWave cluster to any number of nodes. They aren’t constrained to overprovisioned and costly instances forced by rigid sizing models offered by other cloud database providers. With HeatWave customers pay only for the exact resources they use.

MySQL HeatWave: Architected for performance and scalability

Oracle adds more wood to the MySQL HeatWave fire Oracle adds more wood to the MySQL HeatWave fire

Dave Vellante interviews Nipun Agarwal about the new machine learning capabilities of MySQL HeatWave and other innovations.

Accelerate the Use of Machine Learning with MySQL HeatWave Accelerate the Use of Machine Learning with MySQL HeatWave

Discover why Enterprise Strategy Group (ESG) states that "managing one database is always better than two."

IDC Report A game changer for machine learning capabilities

Find out why according to IDC, HeatWave ML is "a game changer for application developers and a broad range of data analysts and scientists."

HeatWave does machine learning the right wayHeatWave does machine learning the right way

"What if a design could bring the ML to the data, eliminating the need for ETL processes and enabling faster and close to real-time ML usage? That’s what the MySQL HeatWave team has achieved."

See what top industry analysts are saying about MySQL HeatWave

IDC

IDC

“Now Oracle has gone beyond its original unifying of OLTP and OLAP in HeatWave, with MySQL HeatWave ML. Oracle is bringing all of the machine learning processing and models inside the database, so that customers not only avoid managing ML databases apart from the core database, but also eliminate the hassles of ETL, gaining speed, accuracy, and cost-effectiveness in the bargain.”

Futurum

Futurum

“The bottom line is we believe the competition just got outplayed on every measurable metric imaginable. It also represents a wake-up call for the industry and a rude awakening to the database cloud competition as they all must now respond to the MySQL HeatWave innovation juggernaut.”

ESG

Constellation Research

“After introducing MySQL HeatWave, a single unified platform for both OLTP and OLAP, and automating management processes with Autopilot, Oracle now adds machine learning to MySQL HeatWave. Once again, with this innovation, Oracle eliminates the need for multiple service offerings and tools for users to integrate machine learning into their applications—plus costly and time-consuming ETL.”

March 29, 2022

In-Database Machine Learning with MySQL HeatWave

Nipun Agarwal, Senior Vice President, MySQL HeatWave Development

MySQL HeatWave is a fully managed database service enabling users to develop and deploy secure, cloud native applications using the world’s most popular open source database. With this latest release of MySQL HeatWave, we introduced several new capabilities including in-database machine learning, real-time elasticity, and data compression.

Featured MySQL HeatWave blogs

View all

HeatWave pricing

MySQL Database Service with HeatWave

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

MySQL resources

Documentation

Documentation

HeatWave is a massively parallel, high performance, in-memory query accelerator that increases MySQL performance by orders of magnitude for analytics and mixed workloads—without any changes to existing applications.

Customer community

Customer community

Join the conversation by visiting the MySQL HeatWave customer forum.

Cloud learning

Cloud learning

Get the most out of MySQL HeatWave with a MySQL Learning Subscription.

Support and services

Support and services

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

MySQL HeatWave related products

MySQL

World’s most popular 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 MySQL HeatWave


Try MySQL HeatWave for free

Explore with $300 in free credits.


Contact us

Interested in learning more? Contact one of our experts.