MySQL HeatWave

MySQL HeatWave is a fully managed cloud database service for running MySQL in production with high availability, automated operations, and strong security controls. It provides automated provisioning, patching, backups, monitoring, and scaling. This subject area enables tracking MySQL DB systems, Heatwave clusters, and backup details.

Business Questions

The subject area can answer the following business questions:

  • Which DB systems / backups / Heatwave clusters are in which lifecycle states?
  • How many DB systems / backups / Heatwave clusters exist?
  • How many backups / DB system storage / Heatwave clusters are being used by each display name?

Logical Model

The MySQL HeatWave subject area is based on a relationship-driven logical model.

This diagram shows how the MySQL Backup fact table is related to the following dimension tables:


This diagram shows the MySQL Backup fact table connected to six dimension tables, Tenancy, Compartment, Date, Budget, and Region.

This diagram shows how the MySQL DB Systems fact table is related to the following dimension tables:


This diagram shows the MySQL DB Systems fact table connected to eight dimension tables.

This diagram shows how the MySQL HeatWave Cluster fact table is related to the following dimension tables:


This diagram shows the MySQL HeatWave Cluster fact table connected to six dimension tables.

Metric Details

The fact folders in this subject area show the following metrics:

Metric Details for MySQL HeatWave
FactMetricDescription
MySQL - Backup Backup size in GB Provides the size of the backup, in gigabytes.
MySQL - DB systems Allocated DB system storage in GB Provides the size of the allocated DB systems storage, in gigabytes.
MySQL - Heatwave cluster Cluster size Provides the number of instance in the DB systems.