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 | Aggregation Type | Description |
|---|---|---|---|---|---|
| azure_mysql_flexibleservers_aborted_connections | aborted_connections | Aborted Connections | Count | Total | Aborted Connections |
| azure_mysql_flexibleservers_active_connections | active_connections | Active Connections | Count | Average | Active Connections |
| azure_mysql_flexibleservers_active_transactions | active_transactions | Active Transactions | Count | Total | Number of active transactions |
| azure_mysql_flexibleservers_backup_storage_used | backup_storage_used | Backup Storage Used | Bytes | Average | Backup Storage Used |
| azure_mysql_flexibleservers_binlog_storage_used | binlog_storage_used | Binlog Storage Used | Bytes | Average | Storage used by Binlog files |
| azure_mysql_flexibleservers_Com_alter_table | Com_alter_table | Com Alter Table | Count | Total | The number of times ALTER TABLE statement has been executed |
| azure_mysql_flexibleservers_Com_create_db | Com_create_db | Com Create DB | Count | Total | The number of times CREATE DB statement has been executed |
| azure_mysql_flexibleservers_Com_create_table | Com_create_table | Com Create Table | Count | Total | The number of times CREATE TABLE statement has been executed |
| azure_mysql_flexibleservers_Com_delete | Com_delete | Com Delete | Count | Total | The number of times DELETE statement has been executed |
| azure_mysql_flexibleservers_Com_drop_db | Com_drop_db | Com Drop DB | Count | Total | The number of times DROP DB statement has been executed |
| azure_mysql_flexibleservers_Com_drop_table | Com_drop_table | Com Drop Table | Count | Total | The number of times DROP TABLE statement has been executed |
| azure_mysql_flexibleservers_Com_insert | Com_insert | Com Insert | Count | Total | The number of times INSERT statement has been executed |
| azure_mysql_flexibleservers_Com_select | Com_select | Com Select | Count | Total | The number of times SELECT statement has been executed |
| azure_mysql_flexibleservers_Com_update | Com_update | Com Update | Count | Total | The number of times UPDATE statement has been executed |
| azure_mysql_flexibleservers_cpu_credits_consumed | cpu_credits_consumed | CPU Credits Consumed | Count | Average | CPU Credits Consumed |
| azure_mysql_flexibleservers_cpu_credits_remaining | cpu_credits_remaining | CPU Credits Remaining | Count | Average | CPU Credits Remaining |
| azure_mysql_flexibleservers_cpu_percent | cpu_percent | Host CPU Percent | Percent | Average | Host CPU Percent |
| azure_mysql_flexibleservers_data_storage_used | data_storage_used | Data Storage Used | Bytes | Average | Storage used by data files |
| azure_mysql_flexibleservers_HA_IO_status | HA_IO_status | HA IO Status | Count | Maximum | Status for replication IO thread running |
| azure_mysql_flexibleservers_HA_replication_lag | HA_replication_lag | HA Replication Lag | Seconds | Average | HA Replication lag in seconds |
| azure_mysql_flexibleservers_HA_SQL_status | HA_SQL_status | HA SQL Status | Count | Maximum | Status for replication SQL thread running |
| azure_mysql_flexibleservers_ibdata1_storage_used | ibdata1_storage_used | Ibdata1 Storage Used | Bytes | Average | Storage used by ibdata1 files |
| azure_mysql_flexibleservers_Innodb_buffer_pool_pages_data | Innodb_buffer_pool_pages_data | InnoDB Buffer Pool Pages Data | Count | Total | The number of pages in the InnoDB buffer pool containing data |
| azure_mysql_flexibleservers_Innodb_buffer_pool_pages_dirty | Innodb_buffer_pool_pages_dirty | InnoDB Buffer Pool Pages Dirty | Count | Total | The current number of dirty pages in the InnoDB buffer pool |
| azure_mysql_flexibleservers_Innodb_buffer_pool_pages_flushed | Innodb_buffer_pool_pages_flushed | Innodb Buffer Pool Pages Flushed | Count | Average | The number of requests to flush pages from the InnoDB buffer pool |
| azure_mysql_flexibleservers_Innodb_buffer_pool_pages_free | Innodb_buffer_pool_pages_free | InnoDB Buffer Pool Pages Free | Count | Total | The number of free pages in the InnoDB buffer pool |
| azure_mysql_flexibleservers_Innodb_buffer_pool_read_requests | Innodb_buffer_pool_read_requests | InnoDB Buffer Pool Read Requests | Count | Total | The number of logical read requests |
| azure_mysql_flexibleservers_Innodb_buffer_pool_reads | Innodb_buffer_pool_reads | InnoDB Buffer Pool Reads | Count | Total | The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk |
| azure_mysql_flexibleservers_Innodb_data_writes | Innodb_data_writes | Innodb Data Writes | Count | Total | The total number of data writes |
| azure_mysql_flexibleservers_Innodb_row_lock_time | Innodb_row_lock_time | Innodb Row Lock Time | Milliseconds | Average | The total time spent in acquiring row locks for InnoDB tables, in milliseconds |
| azure_mysql_flexibleservers_Innodb_row_lock_waits | Innodb_row_lock_waits | Innodb Row Lock Waits | Count | Total | The number of times operations on InnoDB tables had to wait for a row lock |
| azure_mysql_flexibleservers_io_consumption_percent | io_consumption_percent | Storage IO Percent | Percent | Average | Storage I/O consumption percent |
| azure_mysql_flexibleservers_lock_deadlocks | lock_deadlocks | MySQL Lock Deadlocks | Count | Total | Number of deadlocks |
| azure_mysql_flexibleservers_lock_timeouts | lock_timeouts | MySQL Lock Timeouts | Count | Total | Number of lock timeouts |
| azure_mysql_flexibleservers_memory_percent | memory_percent | Memory Percent | Percent | Average | Memory Percent |
| azure_mysql_flexibleservers_network_bytes_egress | network_bytes_egress | Host Network Out | Bytes | Total | Host Network egress in bytes |
| azure_mysql_flexibleservers_network_bytes_ingress | network_bytes_ingress | Host Network In | Bytes | Total | Host Network ingress in bytes |
| azure_mysql_flexibleservers_others_storage_used | others_storage_used | Others Storage Used | Bytes | Average | Storage used by other files |
| azure_mysql_flexibleservers_Queries | Queries | Queries | Count | Total | Queries |
| azure_mysql_flexibleservers_Replica_IO_Running | Replica_IO_Running | Replica IO Status | Count | Maximum | Status for replication IO thread running |
| azure_mysql_flexibleservers_Replica_SQL_Running | Replica_SQL_Running | Replica SQL Status | Count | Maximum | Status for replication SQL thread running |
| azure_mysql_flexibleservers_replication_lag | replication_lag | Replication Lag In Seconds | Seconds | Average | Replication lag in seconds |
| azure_mysql_flexibleservers_serverlog_storage_limit | serverlog_storage_limit | Serverlog Storage Limit | Bytes | Maximum | Serverlog Storage Limit |
| azure_mysql_flexibleservers_serverlog_storage_percent | serverlog_storage_percent | Serverlog Storage Percent | Percent | Average | Serverlog Storage Percent |
| azure_mysql_flexibleservers_serverlog_storage_usage | serverlog_storage_usage | Serverlog Storage Used | Bytes | Average | Serverlog Storage Used |
| azure_mysql_flexibleservers_Slow_queries | Slow_queries | Slow Queries | Count | Total | The number of queries that have taken more than long_query_time seconds |
| azure_mysql_flexibleservers_Sort_merge_passes | Sort_merge_passes | Sort Merge Passes | Count | Total | The number of merge passes that the sort algorithm has had to do. If this value is large, you should consider increasing the value of the sort_buffer_size system variable |
| azure_mysql_flexibleservers_storage_io_count | storage_io_count | Storage IO Count | Count | Total | The number of storage I/O consumed |
| azure_mysql_flexibleservers_storage_limit | storage_limit | Storage Limit | Bytes | Maximum | Storage Limit |
| azure_mysql_flexibleservers_storage_percent | storage_percent | Storage Percent | Percent | Average | Storage Percent |
| azure_mysql_flexibleservers_storage_used | storage_used | Storage Used | Bytes | Average | Storage Used |
| azure_mysql_flexibleservers_Threads_running | Threads_running | Threads Running | Count | Total | The number of threads that are not sleeping |
| azure_mysql_flexibleservers_total_connections | total_connections | Total Connections | Count | Total | Total Connections |
| azure_mysql_flexibleservers_trx_rseg_history_len | trx_rseg_history_len | MySQL History List Length | Count | Total | Length of the TRX_RSEG_HISTORY list |
| azure_mysql_flexibleservers_Uptime | Uptime | MySQL Uptime | Seconds | Total | The number of seconds that the server has been up |