Oracle Cloud Infrastructure Documentation

Database Management for MySQL HeatWave

As a Database Administrator, you can use the Oracle Cloud Infrastructure Database Management service to monitor the MySQL HeatWave DB systems in Oracle Cloud Infrastructure.

Database Management provides real-time monitoring and delivers comprehensive performance and configuration information for the DB systems in the MySQL HeatWave service, which is a fully-managed cloud service running in Oracle Cloud Infrastructure. The DB system is a logical container for MySQL instances and provides an interface for tasks such as the provisioning and monitoring of the MySQL instances. For information, see MySQL DB System.

Database Management is available at no additional cost for MySQL HeatWave and is automatically enabled for new DB systems and can be enabled in a single step for existing DB systems. You can use Database Management for the following DB system configurations:

  • Standalone: A single instance DB system.
  • High Availability: A three-instance DB system that contains one primary instance and two secondary instances, which guarantees if one instance fails, another takes over, with zero data loss and minimal downtime.
Note

  • Although you can enable and use Database Management for both Standalone and High Availability DB system configurations, Database Management only monitors the primary MySQL instance in the DB system. For example, if Database Management is enabled for a DB system with secondary instances, it will only monitor and display metrics for the primary MySQL instance in the DB system and the attached HeatWave cluster, if any, and not for the other instances.
  • For ease of understanding, the term "DB systems" is used in the Database Management for MySQL HeatWave documentation to denote both the MySQL HeatWave DB systems for which Database Management is enabled and the primary MySQL instances that it monitors.

Database Management for MySQL HeatWave provides performance monitoring and diagnostic capabilities, which simplify the detecting of performance issues and ensure a quick resolution of performance bottlenecks. It also provides performance management capabilities to proactively identify the root cause of SQL performance issues. Here are some of the important tasks you can perform using Database Management:

  • Monitor the key performance and configuration metrics of your fleet of DB systems and attached HeatWave clusters.
  • Monitor the metrics and configuration variables of a single DB system and the metrics of the attached HeatWave cluster.
  • Use Performance Hub to monitor and troubleshoot SQL performance.