Oracle MySQL HeatWave

SaaS

Oracle MySQL HeatWave is a managed MySQL cloud service with an in-memory query accelerator and built-in machine learning and generative AI for transactions and analytics.

oracle.com
Oracle MySQL HeatWave homepage screenshot

About Oracle MySQL HeatWave

MySQL HeatWave is a fully managed database service built on MySQL Enterprise Edition. It adds an in-memory query accelerator so analytics can run on transactional data without extract, transform and load (ETL) duplication to a separate analytics database. It can be deployed on Oracle Cloud Infrastructure, Amazon Web Services or Microsoft Azure.

For transactions, it offers MySQL compatibility with full InnoDB support and ACID compliance, a hypergraph optimizer, an Enterprise Thread Pool for thousands of concurrent connections, and Autopilot Indexing that uses machine learning to choose secondary indexes. Security covers encryption, data masking and deidentification, a database firewall, asymmetric encryption and Connection Control against brute-force attacks.

AI features include in-database large language models, an integrated Vector Store that automates embedding generation, and machine learning models built from data in object storage and MySQL. HeatWave Lakehouse queries object storage, MySQL databases or both. Provisioning, scaling, patching, backups and recovery are managed automatically, and MySQL Enterprise support is included at no extra cost.

Key features

  • In-memory query accelerator for MySQL
  • Autopilot Indexing picks secondary indexes automatically
  • In-database large language models
  • Integrated vector store with automated embeddings
  • Queries object storage, MySQL, or both together
  • Data masking and deidentification

Good fit for

  • Real-time analytics on transactional data
  • Lakehouse queries on object storage
  • Document search with in-database LLMs
Tags
mysql
database
analytics
lakehouse
oracle
generative ai
cloud

Oracle MySQL HeatWave: questions and answers

What is Oracle MySQL HeatWave used for?
Oracle MySQL HeatWave is a managed MySQL cloud service with an in-memory query accelerator and built-in machine learning and generative AI for transactions and analytics. It is a good fit for real-time analytics on transactional data, lakehouse queries on object storage and document search with in-database LLMs.
How much does Oracle MySQL HeatWave cost?
Oracle MySQL HeatWave is a paid product with no free plan.
Is Oracle MySQL HeatWave open source?
No. Oracle MySQL HeatWave is proprietary (closed-source) software. Open-source alternatives to Oracle MySQL HeatWave include ClickHouse, MariaDB and MySQL.
Can I self-host Oracle MySQL HeatWave?
Yes. Although Oracle MySQL HeatWave is closed source, it can be self-hosted on your own servers, and the vendor also offers a hosted version.
What are some alternatives to Oracle MySQL HeatWave?
Oracle MySQL HeatWave competes with Amazon Aurora, Amazon RDS and Google Cloud SQL. For open-source options, see Enlisted's ranked list of open-source Oracle MySQL HeatWave alternatives.

Open-source alternatives to Oracle MySQL HeatWave

See all

SaaS alternatives to Oracle MySQL HeatWave

See all