What is the difference between MySQL DB System and HeatWave?

The MySQL DB System is the standard managed MySQL service for OLTP workloads with persistent block storage. HeatWave is an optional in-memory query accelerator that loads data from the MySQL DB System into a cluster of HeatWave nodes for massively parallel analytics processing. You can run both OLTP and analytics on the same database without ETL — transactional queries use the MySQL engine while analytics queries are offloaded to HeatWave automatically.

How is HeatWave Lakehouse priced?

HeatWave Lakehouse extends HeatWave to query data in OCI Object Storage without loading it into the MySQL DB System first. Pricing is based on the number of HeatWave nodes allocated to process Lakehouse queries, charged per node per hour. The data in Object Storage is charged at standard Object Storage rates. This model is cost-effective for large analytical datasets that do not need to reside in MySQL storage.

MySQL HeatWave Cost Estimator

StorageOCI

Estimate MySQL HeatWave costs for DB system, cluster nodes, and Lakehouse storage.

MySQL HeatWave Configuration

DB System Shape

Data Storage (GB)

Enable HeatWave Cluster

HeatWave Nodes

$3.408/node/hr for in-memory query acceleration.

Lakehouse Storage (GB)

HeatWave Lakehouse for querying object storage data.

Raw Output

Output will appear here...

About This Tool

MySQL HeatWave on OCI is a managed MySQL-compatible database service with an integrated in-memory query accelerator that can speed up analytics queries by orders of magnitude. Costs comprise the MySQL DB System (shape and storage), optional HeatWave cluster nodes (for analytics acceleration), and data transfer. The HeatWave Cost Estimator helps you project monthly expenses for different DB System shapes, storage sizes, HeatWave node counts, and High Availability configurations. It also estimates the cost of running HeatWave Lakehouse for querying data directly in Object Storage.

When to Use This Tool

•Estimating costs for a production MySQL HeatWave DB System with High Availability and a 4-node HeatWave cluster
•Comparing the cost of running analytics queries on a standard MySQL shape versus adding HeatWave acceleration nodes
•Projecting costs for HeatWave Lakehouse when querying 10 TB of data stored in OCI Object Storage
•Calculating the savings from using HeatWave AutoPilot to automatically right-size the HeatWave cluster node count

Frequently Asked Questions

What is the difference between MySQL DB System and HeatWave?: The MySQL DB System is the standard managed MySQL service for OLTP workloads with persistent block storage. HeatWave is an optional in-memory query accelerator that loads data from the MySQL DB System into a cluster of HeatWave nodes for massively parallel analytics processing. You can run both OLTP and analytics on the same database without ETL — transactional queries use the MySQL engine while analytics queries are offloaded to HeatWave automatically.
How is HeatWave Lakehouse priced?: HeatWave Lakehouse extends HeatWave to query data in OCI Object Storage without loading it into the MySQL DB System first. Pricing is based on the number of HeatWave nodes allocated to process Lakehouse queries, charged per node per hour. The data in Object Storage is charged at standard Object Storage rates. This model is cost-effective for large analytical datasets that do not need to reside in MySQL storage.

Related Learning Guides

Autonomous Database on OCI20 min read

Disclaimer: This tool runs entirely in your browser. No data is sent to our servers. Always verify outputs before using them in production. AWS, Azure, and GCP are trademarks of their respective owners.