MySQL DB systems monitoring
The MySQL DB Systems integration in Site24x7 provides visibility into your managed MySQL environments hosted in Oracle Cloud. Once configured, Site24x7 automatically discovers your DB systems and tracks key performance metrics such as CPU usage, memory consumption, storage utilization, and connection activity.
This integration also supports the following child monitors:
- HeatWave Cluster: Monitors the in-memory analytics engine associated with your MySQL DB system to track query performance and resource usage.
- Read Replica: Monitors replica instances that offload read traffic from the primary database to improve performance and scalability.
With these child monitors, you get a complete view of both transactional and analytical workloads, as well as replication performance.
Use cases
- A common use case is when a production application starts slowing down due to increased database load. With Site24x7, you can monitor CPU, memory, and connection metrics of your OCI MySQL DB System in real time. If there is a sudden spike in resource usage or long running queries, you can quickly identify the issue and take action before it impacts users.
- Another situation is during peak traffic periods, such as sales events or product launches. You can track how your read replicas are handling the increased read traffic. If replication lag increases or replicas become overloaded, you can scale or optimize them to maintain performance and ensure a smooth user experience.
- For analytics heavy workloads, the HeatWave Cluster plays a key role. You can monitor query execution and resource usage within the cluster to understand how efficiently analytical queries are running. If queries start taking longer than expected, you can investigate and optimize them to improve performance.
Benefits of Site24x7’s OCI MySQL DB Systems integration
Site24x7's integration with OCI MySQL DB Systems provides you with the following benefits:
- Monitor DB systems, HeatWave clusters, and read replicas to gain better visibility, control, and operational clarity across your MySQL environment.
- Track key performance metrics such as CPU, memory, storage, and connections.
- Analyze replication health and replica lag in real time.
- Identify performance bottlenecks before they affect applications.
- Set threshold based alerts to detect abnormal behavior.
- Correlate database metrics with other OCI and application monitors.
- Improve capacity planning with historical performance data.
- Reduce downtime with proactive monitoring and notifications.
Setup and configuration
To get started with MySQL DB systems monitoring, complete the following setup steps:
- Site24x7 uses cross-tenancy access to monitor your resources using Site24x7's tenancy user. Log in to your Site24x7 account and create a specific policy to allow Site24x7 to view your resources without affecting your security.
- On the Integrate OCI Monitor page, select MySQL HeatWave from the Services to be discovered list.
Permissions
Ensure that Site24x7 receives the following permissions to monitor the MySQL DB systems:
- listDbSystems
- listReplicas
- getDbSystem
- getReplica
Permissions for IT automation:
- restartDbSystem
- stopDbSystem
- startDbSystem
- restartHeatWaveCluster
- stopHeatWaveCluster
- startHeatWaveCluster
Polling frequency
Site24x7 queries OCI service-level APIs according to the set polling frequency (from once a minute to once a day) to collect metrics from a MySQL DB Systems monitor.
Supported metrics
The supported metrics for MySQL DB Systems monitors are provided below.
MySQL DB Systems
| Metric name | Description | Statistics | Unit |
|---|---|---|---|
| ActiveConnections | Number of active client connections | Maximum | Count |
| BackupFailure | Indicates if a backup has failed | Maximum | Count |
| BackupTime | Time taken to complete a backup | Maximum | Seconds |
| CurrentConnections | Number of connections currently open | Maximum | Count |
| CPUUtilization | Percentage of CPU used by the DB system | Maximum | Percentage |
| DbVolumeReadOperations | Number of disk read operations per second | Rate | Operations per second |
| DbVolumeWriteOperations | Number of disk write operations per second | Rate | Operations per second |
| DbVolumeReadBytes | Amount of data read from disk | Mean | Bytes |
| DbVolumeWriteBytes | Amount of data written to disk | Mean | Bytes |
| DbVolumeUtilization | Percentage of disk space used | Maximum | Percentage |
| HeatWaveHealth | Overall health status of the HeatWave cluster | Mean | Status |
| HeatWaveStatements | Number of queries executed in HeatWave | Count | Count |
| HeatWaveDataLoadProgress | Progress of data loading into HeatWave | Mean | Percentage |
| ChannelFailure | Number of replication channel failures | Maximum | Count |
| ChannelLag | Delay in replication between source and replica | Maximum | Seconds |
| MemoryAllocated | Total memory allocated to the DB system | Maximum | Bytes |
| MemoryUtilization | Percentage of memory in use | Mean | Percentage |
| MemoryUsed | Amount of memory currently used | Maximum | Bytes |
| NetworkReceiveBytes | Amount of incoming network data | Mean | Bytes |
| NetworkTransmitBytes | Amount of outgoing network data | Mean | Bytes |
| OCPUsAllocated | Total number of OCPUs allocated | Maximum | Count |
| OCPUsUsed | Number of OCPUs currently in use | Maximum | Count |
| Statements | Number of SQL statements executed per second | Rate | Operations per second |
| StatementLatency | Average latency of SQL statements | Rate | Milliseconds |
| StorageAllocated | Total storage allocated to the DB system | Maximum | Bytes |
| StorageUsed | Amount of storage currently used | Maximum | Bytes |
| BackupSize | Size of the backup data | Maximum | Bytes |
MySQL Read Replica
| Metric name | Description | Statistics | Unit |
|---|---|---|---|
| ActiveConnections | Number of active connections on the replica | Maximum | Count |
| BackupFailure | Indicates if a replica backup has failed | Maximum | Count |
| BackupTime | Time taken to complete a replica backup | Maximum | Seconds |
| CurrentConnections | Number of current connections on the replica | Maximum | Count |
| CPUUtilization | Percentage of CPU used by the replica | Maximum | Percentage |
| DbVolumeReadOperations | Number of disk read operations per second | Rate | Operations per second |
| DbVolumeWriteOperations | Number of disk write operations per second | Rate | Operations per second |
| DbVolumeReadBytes | Amount of data read from disk | Mean | Bytes |
| DbVolumeWriteBytes | Amount of data written to disk | Mean | Bytes |
| DbVolumeUtilization | Percentage of disk space used | Maximum | Percentage |
| ChannelFailure | Number of replication failures on the replica | Maximum | Count |
| ChannelLag | Delay in replication on the replica | Maximum | Seconds |
| MemoryAllocated | Total memory allocated to the replica | Maximum | Bytes |
| MemoryUtilization | Percentage of memory used on the replica | Maximum | Percentage |
| MemoryUsed | Amount of memory currently used | Maximum | Bytes |
| NetworkReceiveBytes | Amount of incoming network data | Mean | Bytes |
| NetworkTransmitBytes | Amount of outgoing network data | Mean | Bytes |
| OCPUsAllocated | Total number of OCPUs allocated | Maximum | Count |
| OCPUsUsed | Number of OCPUs currently in use | Maximum | Count |
| Statements | Number of SQL statements executed per second | Rate | Operations per second |
| StatementLatency | Average latency of SQL statements | Rate | Milliseconds |
| StorageAllocated | Total storage allocated to the replica | Maximum | Bytes |
| StorageUsed | Amount of storage currently used | Maximum | Bytes |
| BackupSize | Size of the replica backup data | Maximum | Bytes |
MySQL HeatWave Cluster
| Metric name | Description | Statistics | Unit |
|---|---|---|---|
| CPUUtilization | Percentage of CPU used by HeatWave nodes | Maximum | Percentage |
| DbVolumeReadOperations | Number of disk read operations per second | Rate | Operations per second |
| DbVolumeWriteOperations | Number of disk write operations per second | Rate | Operations per second |
| DbVolumeReadBytes | Amount of data read from disk | Mean | Bytes |
| DbVolumeWriteBytes | Amount of data written to disk | Mean | Bytes |
| DbVolumeUtilization | Percentage of disk space used | Maximum | Percentage |
| MemoryAllocated | Total memory allocated to HeatWave | Maximum | Bytes |
| MemoryUtilization | Percentage of memory used in HeatWave | Maximum | Percentage |
| MemoryUsed | Amount of memory currently used | Maximum | Bytes |
| NetworkReceiveBytes | Amount of incoming network data | Mean | Bytes |
| NetworkTransmitBytes | Amount of outgoing network data | Mean | Bytes |
| OCPUsAllocated | Total number of OCPUs allocated | Maximum | Count |
| OCPUsUsed | Number of OCPUs currently in use | Maximum | Count |
| HeatWaveHealth | Overall health status of HeatWave | Mean | Status |
| HeatWaveDataLoadProgress | Progress of data loading into HeatWave | Mean | Percentage |
| HeatWaveStatements | Number of queries processed by HeatWave | Count | Count |
Threshold configuration
To configure thresholds for an MySQL DB Systems monitor:
- Log in to your Site24x7 account and navigate to Admin > Configuration Profiles > Threshold and Availability.
- Click Add Threshold Profile.
- Select the applicable monitor type from the Monitor Type drop-down menu. The applicable monitor types are HeatWave Cluster and Read Replica. The supported metrics are displayed in the Threshold Configuration section. You can set threshold values for all the metrics mentioned above.
- Click Save.
Automate MySQL DB Systems operations with IT Automation
The IT automation feature in Site24x7 for MySQL DB Systems and HeatWave Cluster lets you automate critical operations such as start, stop, and restart, helping you manage database and analytics workloads efficiently in Oracle Cloud Infrastructure.
- Start MySQL DB System and HeatWave Cluster: Use this action to bring database and analytics services online during business hours or planned operations, ensuring application and query availability.
- Stop MySQL DB System and HeatWave Cluster:This action helps reduce cloud costs by stopping unused database systems and HeatWave clusters during non-production hours or maintenance windows.
- Restart MySQL DB System and HeatWave Cluster: Use this action to quickly recover from performance issues or apply configuration changes, minimizing downtime for both transactional and analytical workloads.
By automating these actions, you can reduce manual intervention, improve operational efficiency, and maintain better control over your MySQL DB systems and HeatWave environments.
Centralized monitoring for MySQL DB Systems
The Monitor Groups feature in Site24x7 for MySQL DB Systems helps you organize your MySQL DB systems into logical groups for simplified monitoring and management in Oracle Cloud Infrastructure.
You can group DB systems by application, environment, or region to get a unified view of database performance, availability, and overall health.
Plan and scale MySQL DB Systems with Capacity Planning
The Capacity Planning feature in Site24x7 for MySQL DB Systems helps you analyze resource usage trends and plan your database infrastructure effectively in Oracle Cloud Infrastructure.
It provides insights into CPU, memory, storage, and connection usage, helping you identify growth patterns and potential bottlenecks. This feature enables you to make informed scaling decisions and optimize resource allocation for your MySQL DB systems. With proactive capacity planning, you can ensure consistent performance, improve availability, and control cloud costs.
Licensing
- Each MySQL DB Systems, HeatWave Cluster, and Read Replica monitor utilizes one basic monitor license.
Viewing MySQL DB Systems data
To monitor your MySQL DB Systems environment, log in to your Site24x7 account and navigate to Cloud > OCI > MySQL DB Systems.
Monitor data
The monitor data for an MySQL DB Systems monitor is given below.
MySQL DB Systems
Summary
The Summary tab offers a comprehensive overview of the events timeline and metrics, presenting insightful charts that shed light on the performance of your MySQL DB Systems monitor.
HeatWave Cluster
The HeatWave Cluster tab gives you a clear view of all HeatWave clusters connected to your database. It shows the total number of clusters along with their current statuses, such as Up, Down, Critical, or Trouble. Each cluster entry includes key metrics like CPU utilization and memory utilization, so you can quickly understand performance and resource usage.
This tab helps you monitor HeatWave cluster health in real time, spot performance issues early, and keep analytical workloads running smoothly. You can also set threshold limits to get alerts when metrics cross expected levels, making it easier to take timely action.
Read Replicas
The Read Replicas tab provides a centralized view of all read replica instances associated with your MySQL database. It displays the total number of replicas along with their current statuses, including Up, Down, Critical, or Trouble states, and key metrics such as active connections, CPU utilization, and memory utilization.
This tab helps you monitor read replica performance in real time, track replication health, and ensure read traffic is efficiently distributed. You can also configure thresholds to receive alerts on performance issues, helping you maintain high availability and optimize database performance.
Endpoints
The Endpoints tab provides a detailed view of all database endpoints associated with your MySQL DB system. It lists each endpoint with key details such as resource ID, type, IP address, database ports, protocol ports, and access modes, helping you understand how clients connect to the database. This tab helps you track endpoint configurations, verify connectivity settings, and ensure proper routing of database traffic.
Configuration
The Configuration tab provides a complete view of your database system’s setup and configuration details. It displays key attributes such as fault domain, availability domain, subnet, database version, shape, ports, and backup settings for better visibility.
Outages
The Outages tab provides details on an outage's Start Time, End Time, Duration, and Comments, if any.
Notes
The Notes tab provides details like Resource ID, Region, Monitor Licensing Category, and much more. The Threshold and Availability Profile and the Notification Profile can be set according to the user and viewed in this tab.
Log Report
The Log Report tab provides a consolidated report of the MySQL DB Systems monitor's log status, which can be downloaded as a CSV file.
Alert Logs
The Alert Logs tab displays a chronological list of all triggered alerts related to the MySQL DB Systems monitor. This tab helps you trace alert history and severity to assess issues and validate threshold settings.
HeatWave Cluster
Summary
The Summary tab offers a comprehensive overview of the events timeline and metrics, presenting insightful charts that shed light on the performance of your HeatWave Cluster monitor.
Configuration
The Configuration tab provides a complete view of your HeatWave Cluster setup and configuration details. It displays key attributes such as Region, State, Shape, and Nodes for better visibility.
Outages
The Outages tab provides details on an outage's Start Time, End Time, Duration, and Comments, if any.
Notes
The Notes tab provides details like Resource ID, Region, Monitor Licensing Category, and much more. The Threshold and Availability Profile and the Notification Profile can be set according to the user and viewed in this tab.
Log Report
The Log Report tab provides a consolidated report of the HeatWave Cluster monitor's log status, which can be downloaded as a CSV file.
Alert Logs
The Alert Logs tab displays a chronological list of all triggered alerts related to the HeatWave Cluster monitor. This tab helps you trace alert history and severity to assess issues and validate threshold settings.
Read Replicas
Summary The Summary tab offers a comprehensive overview of the events timeline and metrics, presenting insightful charts that shed light on the performance of your Read Replicas monitor.
Configuration The Configuration tab provides a complete view of your Read Replicas setup and configuration details. It displays key attributes such as fault domain, availability domain, database version, and ports for better visibility.
Outages The Outages tab provides details on an outage's Start Time, End Time, Duration, and Comments, if any.
Notes The Notes tab provides details like Resource ID, Region, Monitor Licensing Category, and much more. The Threshold and Availability Profile and the Notification Profile can be set according to the user and viewed in this tab.
Log Report The Log Report tab provides a consolidated report of the Read Replicas monitor's log status, which can be downloaded as a CSV file.
Alert Logs The Alert Logs tab displays a chronological list of all triggered alerts related to the Read Replicas monitor. This tab helps you trace alert history and severity to assess issues and validate threshold settings.
Related articles
-
On this page
- Use cases
- Benefits of Site24x7’s OCI MySQL DB Systems integration
- Setup and configuration
- Permissions
- Polling frequency
- Supported metrics
- Threshold configuration
- Automate MySQL DB Systems operations with IT Automation
- Centralized monitoring for MySQL DB Systems
- Plan and scale MySQL DB Systems with Capacity Planning
- Licensing
- Viewing MySQL DB Systems data
- Monitor data