Microsoft Azure DB for MySQL
Overview
Microsoft Azure Database for MySQL is a fully-managed, cloud-based relational database service provided by Microsoft Azure. It offers a scalable and high-performance solution for hosting MySQL databases in the Azure cloud environment, enabling developers to build and deploy applications with ease.
Prerequisites
You can check the list of prerequisites required for Azure SQL DB here. These are the same for any other Azure service that you need to monitor using AIOps. Move to the section Adding Azure resources for Monitoring on the above link to view the prerequisites for Azure resource monitoring.
List of Supported KPIs
| Name | Description | Type |
|---|---|---|
| status | Status of the Azure MySQL server | String |
| azure.mysql.server.id | ID of the Azure MySQL server | String |
| azure.status | Status of the Azure services | String |
| azure.mysql.server.fqdn | Fully Qualified Domain Name of the Azure MySQL server | String |
| azure.mysql.server | Azure MySQL server name | String |
| azure.location | Location of the Azure resources | String |
| azure.mysql.server.resource.group | Resource group of the Azure MySQL server | String |
| azure.mysql.server.cpu.percent | CPU usage percentage | Percent |
| azure.mysql.server.data.storage.used.percent | Percentage of used data storage | Percent |
| azure.mysql.server.failed.connections | Total count of failed connections | Count |
| azure.mysql.server.memory.percent | Memory usage percentage | Percent |
| azure.mysql.server.active.connections | Average count of active connections | Count |
| azure.mysql.server.backup.storage.used.bytes | Average usage of backup storage | Bytes |
| azure.mysql.server.io.percent | IO consumption percentage | Percent |
| azure.mysql.server.network.ingress.bytes | Average ingress network traffic | Bytes |
| azure.mysql.server.network.egress.bytes | Average egress network traffic | Bytes |
| azure.mysql.server.replication.lag.sec | Average lag in seconds behind the master | Count |
| azure.mysql.server.log.storage.capacity.bytes | Maximum capacity of server log storage | Bytes |
| azure.mysql.server.log.storage.used.percent | Percentage of used server log storage | Percent |
| azure.mysql.server.log.storage.used.bytes | Average usage of server log storage | Bytes |
| azure.mysql.server.data.storage.capacity.bytes | Maximum capacity of data storage | Bytes |
| azure.mysql.server.data.storage.used.bytes | Average usage of data storage | Bytes |
| event.timestamp | Timestamp of the event | Count |