MySQL Database is a fully-managed database service, powered by the integrated HeatWave in-memory query accelerator. It is the only cloud-native database service that combines transactions, analytics, and machine learning services into MySQL Database, delivering real-time, secure analytics without the complexity, latency, and cost of ETL duplication. It is developed, managed, and supported by the MySQL team in Oracle.
Use the Oracle Cloud integration to discover and collect metrics against the OCI MySQL DB Systems.
Setup
To set up the Oracle Cloud integration and discover the OCI MySQL DB Systems service, do the following:
Create a Oracle Cloud (OCI) integration if not available in your installed integrations.
You can select
OCI MySQL DB Systemsduring integration or you can edit the existing integration and selectOCI MySQL DB Systems.Scan to discover the resources at any time independent of the predefined schedule.
Once the scan is completed, you can view the OCI MySQL DB Systems resource under Infrastructure > Resources > Oracle Cloud category.
Create a template. See Create a Template for more information on how to create a template.
Refer to Assign a Template on how to assign a template to a resource.
Click the Metrics tab to view the monitoring data of OCI MySQL DB Systems as shown below:
Supported metrics
| OpsRamp Metric | Oracle Cloud Metric | Metric Display Name | Unit | Description | Aggregation Type |
|---|---|---|---|---|---|
| oci_mysqldb_ActiveConnections | ActiveConnections | Active Connections | Count | The number of connections actively executing statements against the MySQL DB system. | max |
| oci_mysqldb_BackupSize | BackupSize | Total Backup Size | Bytes | The aggregate size of all backups per DB system. | max |
| oci_mysqldb_BackupTime | BackupTime | Backup Time | ms | The time taken for a backup operation. | max |
| oci_mysqldb_ChannelFailure | ChannelFailure | Inbound Channel Failure | ms | The channel failure events observed over the last interval. | mean |
| oci_mysqldb_ChannelLag | ChannelLag | Inbound Channel Lag | ms | The channel lag with respect to the source observed over the last interval. | mean |
| oci_mysqldb_CPUUtilization | CPUUtilization | CPU Utilization | percent | CPU utilization for the MySQL DB system host or HeatWave nodes. | mean |
| oci_mysqldb_CurrentConnections | CurrentConnections | Current Connections | Count | The number of current connections to the MySQL DB system. | max |
| oci_mysqldb_DbVolumeReadBytes | DbVolumeReadBytes | Disk Read Bytes | bytes | The total bytes read from the MySQL DB system volume(s). | rate |
| oci_mysqldb_DbVolumeReadOperations | DbVolumeReadOperations | Disk Read Operations | Count | The total number of read operations for the DB volume(s). | rate |
| oci_mysqldb_DbVolumeUtilization | DbVolumeUtilization | Disk Space Utilization | percent | The total space utilization of the MySQL DB system volume(s). | max |
| oci_mysqldb_DbVolumeWriteBytes | DbVolumeWriteBytes | Disk Write Bytes | bytes | The total bytes written to the MySQL DB system volume(s). | rate |
| oci_mysqldb_DbVolumeWriteOperations | DbVolumeWriteOperations | Disk Write Operations | count | The total number of write operations for the MySQL DB volume(s). | rate |
| oci_mysqldb_MemoryUtilization | MemoryUtilization | Memory Utilization | percent | Memory utilization for the MySQL DB system host or HeatWave nodes. | mean |
| oci_mysqldb_NetworkReceiveBytes | NetworkReceiveBytes | Network Receive Bytes | bytes | Total number of bytes received by a network for the MySQL DB system. | mean |
| oci_mysqldb_NetworkTransmitBytes | NetworkTransmitBytes | Network Transmit Bytes | bytes | Network transmit bytes for the MySQL DB system. | mean |
| oci_mysqldb_StatementLatency | StatementLatency | Statement Latency | ms | Statement latency for all executed statements. | rate |
| oci_mysqldb_Statements | Statements | Statement Count | count | The number of statements executed against the MySQL DB system. | rate |