Azure Database for MySQL - Flexible Server is a fully managed production-ready database service designed for more granular control and flexibility over database management functions and configuration settings. The flexible server architecture allows users to opt for high availability within a single availability zone and across multiple availability zones.
Flexible servers provide better cost optimization controls with the ability to stop/start server and burstable compute tier, ideal for workloads that do not need full-compute capacity continuously. Flexible Server also supports reserved instances allowing you to save up to 63% cost, ideal for production workloads with predictable compute capacity requirements.
Setup
To set up the Azure integration and discover the MySQL flexible server resources, do the following:
Create an Azure Integration if not available in your installed integrations. For more information on how to install the Azure Integration, refer to Install Azure integration.
Create a discovery profile. For more information on how to create a discovery profile, refer to Create Discovery Profile..
Select
MySQL flexible serverunder the Filter Criteria in the Edit Discovery Profile page.
Azure Integration Discovery Profile
Save the discovery profile to make them available in the list of Discovery Profiles.
Scan to discover the resources at any time independent of the predefined schedule.
Once the scan is completed, you can view the MySQL flexible server resources under Infrastructure > Resources > Microsoft Azure category.
Create a template with collector type Azure and applicable for MySQL flexible server. 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 MySQL flexible server as shown below:
Event support
OpsRamp supports Azure events for DB for MySQL flexible servers. Configure Azure Events in OpsRamp Azure integration discovery profile.
See Process Azure Events for more information on how to configure Azure events.
Supported metrics
| OpsRamp Metric | Azure Metric | Metric Display Name | Unit | Description | Aggregation Type |
|---|---|---|---|---|---|
| azure_mysql_flexibleservers_aborted_connections | aborted_connections | Aborted Connections | Count | Indicates number of aborted connections. | Total |
| azure_mysql_flexibleservers_active_connections | active_connections | Active Connections | Count | Indicates number of active connections. | Maximum |
| azure_mysql_flexibleservers_backup_storage_used | backup_storage_used | Backup Storage Used | Bytes | Indicates amount of backup storage Used. | Maximum |
| azure_mysql_flexibleservers_Com_alter_table | Com_alter_table | Com Alter Table | Count | The number of times an ALTER TABLE statement has been executed. | Total |
| azure_mysql_flexibleservers_Com_create_db | Com_create_db | Com Create DB | Count | The number of times an CREATE DB statement has been executed. | Total |
| azure_mysql_flexibleservers_Com_create_table | Com_create_table | Com Create Table | Count | The number of times an CREATE TABLE statement has been executed. | Total |
| azure_mysql_flexibleservers_Com_delete | Com_delete | Com Delete | Count | The number of times an DELETE statement has been executed. | Total |
| azure_mysql_flexibleservers_Com_drop_db | Com_drop_db | Com Drop DB | Count | The number of times an DROP DB statement has been executed. | Total |
| azure_mysql_flexibleservers_Com_drop_table | Com_drop_table | Com Drop Table | Count | The number of times an DROP TABLE statement has been executed. | Total |
| azure_mysql_flexibleservers_Com_insert | Com_insert | Com Insert | Count | The number of times an INSERT statement has been executed. | Total |
| azure_mysql_flexibleservers_Com_select | Com_select | Com Select | Count | The number of times an ELECT statement has been executed. | Total |
| azure_mysql_flexibleservers_Com_update | Com_update | Com Update | Count | The number of times an UPDATE statement has been executed. | Total |
| azure_mysql_flexibleservers_cpu_credits_consumed | cpu_credits_consumed | CPU Credits Consumed | Count | Indicates the amount of CPU credits consumed. | Maximum |
| azure_mysql_flexibleservers_cpu_credits_remaining | cpu_credits_remaining | CPU Credits Remaining | Count | Indicates the number of CPU credits are remaining. | Maximum |
| azure_mysql_flexibleservers_cpu_percent | cpu_percent | Host CPU Percent | Percent | Percentage of host CPU. | Maximum |
| azure_mysql_flexibleservers_HA_IO_status | HA_IO_status | HA IO Status | Count | Status for replication IO thread running. | Maximum |
| azure_mysql_flexibleservers_HA_replication_lag | HA_replication_lag | HA Replication Lag | Seconds | Indicates HA replication lag in seconds. | Maximum |
| azure_mysql_flexibleservers_HA_SQL_status | HA_SQL_status | HA SQL Status | Count | Status for replication SQL thread running. | Maximum |
| azure_mysql_flexibleservers_Innodb_buffer_pool_pages_data | Innodb_buffer_pool_pages_data | InnoDB Buffer Pool Pages Data | Count | The number of pages in the InnoDB buffer pool containing data. | Total |
| azure_mysql_flexibleservers_Innodb_buffer_pool_pages_dirty | Innodb_buffer_pool_pages_dirty | InnoDB Buffer Pool Pages Dirty | Count | The current number of dirty pages in the InnoDB buffer pool. | Total |
| azure_mysql_flexibleservers_Innodb_buffer_pool_pages_free | Innodb_buffer_pool_pages_free | InnoDB Buffer Pool Pages Free | Count | The number of free pages in the InnoDB buffer pool. | Total |
| azure_mysql_flexibleservers_Innodb_buffer_pool_read_requests | Innodb_buffer_pool_read_requests | InnoDB Buffer Pool Read Requests | Count | The number of logical read requests. | Total |
| azure_mysql_flexibleservers_Innodb_buffer_pool_reads | Innodb_buffer_pool_reads | InnoDB Buffer Pool Reads | Count | The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk. | Total |
| azure_mysql_flexibleservers_io_consumption_percent | io_consumption_percent | Storage IO Percent | Percent | Indicates storage I/O consumption percentage. | Maximum |
| azure_mysql_flexibleservers_memory_percent | memory_percent | Host Memory Percent | Percent | Indicates host memory percentage. | Maximum |
| azure_mysql_flexibleservers_network_bytes_egress | network_bytes_egress | Host Network Out | Bytes | Host Network egress in bytes. | Total |
| azure_mysql_flexibleservers_network_bytes_ingress | network_bytes_ingress | Host Network In | Bytes | Host Network ingress in bytes. | Total |
| azure_mysql_flexibleservers_Queries | Queries | Queries | Count | Indicates number of queries executed. | Total |
| azure_mysql_flexibleservers_Replica_IO_Running | Replica_IO_Running | Replica IO Status | Count | Status for replication IO thread running. | Maximum |
| azure_mysql_flexibleservers_Replica_SQL_Running | Replica_SQL_Running | Replica SQL Status | Count | Status for replication SQL thread running. | Maximum |
| azure_mysql_flexibleservers_replication_lag | replication_lag | Replication Lag In Seconds | Seconds | Replication lag in seconds. | Maximum |
| azure_mysql_flexibleservers_serverlog_storage_limit | serverlog_storage_limit | Serverlog Storage Limit | Bytes | Indicates serverlog storage limit. | Maximum |
| azure_mysql_flexibleservers_serverlog_storage_percent | serverlog_storage_percent | Serverlog Storage Percent | Percent | Indicates serverlog storage percentage. | Maximum |
| azure_mysql_flexibleservers_serverlog_storage_usage | serverlog_storage_usage | Serverlog Storage Used | Bytes | Indicates serverlog storage used. | Maximum |
| azure_mysql_flexibleservers_Slow_queries | Slow_queries | Slow Queries | Count | The number of queries that have taken more than long_query_time seconds. | Total |
| azure_mysql_flexibleservers_storage_io_count | storage_io_count | IO Count | Count | The number of I/O consumed. | Total |
| azure_mysql_flexibleservers_storage_limit | storage_limit | Storage Limit | Bytes | Indicates serverlog storage limit. | Maximum |
| azure_mysql_flexibleservers_storage_percent | storage_percent | Storage Percent | Percent | Indicates storage percentage. | Maximum |
| azure_mysql_flexibleservers_storage_throttle_count | storage_throttle_count | Storage Throttle Count | Count | Storage IO requests throttled in the selected time range. | Maximum |
| azure_mysql_flexibleservers_storage_used | storage_used | Storage Used | Bytes | Indicates amount of storage used. | Maximum |
| azure_mysql_flexibleservers_total_connections | total_connections | Total Connections | Count | Total number of connections. | Total |
| azure_mysql_flexibleservers_active_transactions | active_transactions | Active Transactions | Count | Number of active transactions. | Total |
| azure_mysql_flexibleservers_binlog_storage_used | binlog_storage_used | Binlog Storage Used | Bytes | Storage used by Binlog files. | Average |
| azure_mysql_flexibleservers_data_storage_used | data_storage_used | Data Storage Used | Bytes | Storage used by data files. | Average |
| azure_mysql_flexibleservers_ibdata1_storage_used | ibdata1_storage_used | Ibdata1 Storage Used | Bytes | Storage used by ibdata1 files. | Average |
| azure_mysql_flexibleservers_Innodb_buffer_pool_pages_flushed | Innodb_buffer_pool_pages_flushed | Innodb Buffer Pool Pages Flushed | Count | The number of requests to flush pages from the InnoDB buffer pool. | Average |
| azure_mysql_flexibleservers_Innodb_data_writes | Innodb_data_writes | Innodb Data Writes | Count | The total number of data writes. | Total |
| azure_mysql_flexibleservers_Innodb_row_lock_time | Innodb_row_lock_time | Innodb Row Lock Time | Milliseconds | The total time spent in acquiring row locks for InnoDB tables in milliseconds. | Average |
| azure_mysql_flexibleservers_Innodb_row_lock_waits | Innodb_row_lock_waits | Innodb Row Lock Waits | Count | The number of times operations on InnoDB tables had to wait for a row lock. | Total |
| azure_mysql_flexibleservers_lock_deadlocks | lock_deadlocks | MySQL Lock Deadlocks | Count | MySQL Lock Deadlocks. | Total |
| azure_mysql_flexibleservers_lock_timeouts | lock_timeouts | MySQL Lock Timeouts | Count | Number of lock timeouts. | Total |
| azure_mysql_flexibleservers_others_storage_used | others_storage_used | Others Storage Used | Bytes | Storage used by other files. | Average |
| azure_mysql_flexibleservers_Threads_running | Threads_running | Threads Running | Count | Indicates the count of active threads that are currently running and not in a sleeping state. | Total |
| azure_mysql_flexibleservers_trx_rseg_history_len | trx_rseg_history_len | MySQL History List Length | Count | Refers to the length of the transaction redo log history for the InnoDB storage engine. | Total |
| azure_mysql_flexibleservers_Uptime | Uptime | MySQL Uptime | Seconds | The number of seconds that the server has been up. | Total |