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
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
ClickHouse
Databases
ClickHouse is a fast open-source column-oriented database management system that allows ge
Apache-2.0vs Snowflake★ 51k
MariaDB
Databases
MariaDB server is a community developed fork of MySQL server. Started by core members of t
GPL-2.0vs Oracle Database★ 8.6k
MySQL
Databases
MySQL Server, the world's most popular open source database, and MySQL Cluster, a real-tim
OSSvs Oracle Database★ 13k
TiDB
Databases
TiDB is built for agentic workloads that grow unpredictably, with ACID guarantees and nati
Apache-2.0vs Amazon Aurora★ 41k
OceanBase
Databases
OceanBase is the unified distributed database for the AI era — open-source, multi-model, o
Apache-2.0vs Oracle Database★ 10k
Vitess
Database Tools
Vitess is a database clustering system for horizontal scaling of MySQL.
Apache-2.0vs Amazon RDS★ 21k
SaaS alternatives to Oracle MySQL HeatWave
See all
Amazon Aurora
Databases
AWS cloud-built relational database compatible with MySQL and PostgreSQL
SaaS
Amazon RDS
Databases
Managed relational databases on AWS for MySQL, PostgreSQL, SQL Server and Oracle
SaaS
Google Cloud SQL
Databases
Managed MySQL, PostgreSQL and SQL Server database service on Google Cloud
SaaS
PlanetScale
Databases
Managed MySQL and Postgres with branching workflows and online schema changes
SaaS
DigitalOcean Managed Databases
Databases
Managed PostgreSQL, MySQL, Valkey, MongoDB and Kafka clusters on DigitalOcean
SaaS
Google Memorystore
Databases
Managed in-memory data store on Google Cloud for Redis, Valkey and Memcached
SaaS

Azure Maps
AWS Device Farm
Aiven
ScaleGrid
SingleStore
Snowflake
Google BigQuery
Amazon Redshift
Azure Synapse Analytics