Azure Database for MariaDB server is a relational database service, known for it's dynamic scalability. It is based on the open-source MariaDB server engine. Applications Manager's Azure Database for MariaDB server Monitoring tool offers a monitoring software capable of effectively tracking the performance level of your database servers, thus making server management a hassle free process. Network traffic and Server usage are some of the key performance metrics that are monitored.
To learn how to create a new Microsoft Azure Database for MariaDB server Monitor, click here.
Navigate to the Category View by clicking the Monitors tab. Hover over 'Child Monitors' under Microsoft Azure in the Cloud Apps table, and then select the MariaDB Server monitor from the displayed tooltip. This action will display the bulk configuration view for Azure Database for MariaDB Server in three tabs:
Microsoft Azure monitor provides a brief detail of the Azure Database for MariaDB server under the given subscription. Following are the list of metrics monitored in Azure Database for MariaDB Server Monitoring in their corresponding tabs:
| Parameter | Description |
|---|---|
| SERVER INFORMATION | |
| State | The state of the MariaDB server. |
| Fully Qualified Domain Name | The fully qualified domain name of MariaDB server |
| Resource Group Name | Name of the Resource Group |
| Admin Username | Username of the Admin server. |
| Location | Geo location where the resource resides. |
| Version | Version of MariaDB server. |
| ACTIVE CONNECTIONS | |
| Active Connections | The average number of active connections to the server between the poll interval. |
| FAILED CONNECTIONS | |
| Failed Connections | The total number of failed connections to the server between the poll interval. |
| NETWORK THROUGHPUT | |
| Outgoing Traffic | The total outgoing network traffic per minute across active connections between the poll interval (in MB/min). |
| Incoming Traffic | The total incoming network traffic per minute across active connections between the poll interval (in MB/min). |
| Parameter | Description |
|---|---|
| SERVER UTILIZATION | |
| CPU | The average percentage of CPU in use at the time of polling (in %). |
| Memory | The average percentage of memory in use at the time of polling (in %). |
| Storage | The average percentage of storage used out of the server's maximum at the time of polling (in %). |
| IO | The average percentage of IO in use at the time of polling (in %). |
| STORAGE | |
| Storage Limit | The maximum storage for this server between the poll interval (in GB). |
| Storage Used | The average amount of storage space used by the server including database files, transaction logs, and the server logs at the time of polling (in GB). |
| BACKUP STORAGE | |
| Backup Storage Used | The average amount of backup storage used at the time of polling (in GB). |
| SERVER LOG STORAGE | |
| Server Log Storage Limit | The maximum amount of server log storage allocated for the server between the poll interval (in GB). |
| Server Log Storage Used | The average amount of server log storage used by the server at the time of polling (in GB). |
| Server Log Storage Percent | The average percentage of server log storage used out of the server's maximum server log storage at the time of polling (in %). |
Note: Metrics shown in Replication tab are supported only for Replica servers in Azure MariaDB server monitor.
| Parameter | Description |
|---|---|
| REPLICA LAG | |
| Replica Lag | The maximum number of seconds the replica server is lagging against the source server between the poll interval (in seconds). |
| Name | Value |
|---|---|
| CONFIGURATION | |
| Public Network Access | Specifies whether or not public endpoint access is allowed for this server. Possible values: Enabled/Disabled. |
| SSL Enforcement | Specifies whether to enable SSL enforcement or not while connecting to server. Possible values: Enabled/Disabled. |
| SKU | |
| SKU | The name of the deployed SKU. |
| Family | The family of the deployed SKU |
| Tier | The tier of the deployed SKU. Possible values:
|
| Capacity | The capacity of the deployed SKU. |
| BACKUP | |
| Backup Retention Period | The retention period of the backup storage. |
| Geo Redundant Backup | Specifies whether the Geo Redundant Backup is enabled or disabled. |
| Earliest Restore Date | The earliest restoring date and time of the backup storage. |
| REPLICATION | |
| Master Server ID | The ID of the master server. |
| Replication Role | Role of the Replica. |
| Replica Capacity | Capacity of the Replica. |
| PRIVATE ENDPOINT CONNECTIONS | |
| Private Endpoint Connections ID | The ID of the Private Endpoint Connection resource. |
| Private Endpoint Provisioning State | The provisioning state of the Private Endpoint. Possible values:
|
| Private Endpoint Connections Status | The status of the Private Endpoint Connection. Possible values:
|
