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:

  1. 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.

  2. Create a discovery profile. For more information on how to create a discovery profile, refer to Create Discovery Profile..

  3. Select MySQL flexible server under the Filter Criteria in the Edit Discovery Profile page.

    Azure Integration Discovery Profile

    Azure Integration Discovery Profile

  4. Save the discovery profile to make them available in the list of Discovery Profiles.

  5. Scan to discover the resources at any time independent of the predefined schedule.

  6. Once the scan is completed, you can view the MySQL flexible server resources under Infrastructure > Resources > Microsoft Azure category.

  7. 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.

  8. Refer to Assign a Template on how to assign a template to a resource.

  9. 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 MetricAzure MetricMetric Display NameUnitDescriptionAggregation Type
azure_mysql_flexibleservers_aborted_connectionsaborted_connectionsAborted ConnectionsCountIndicates number of aborted connections.Total
azure_mysql_flexibleservers_active_connectionsactive_connectionsActive ConnectionsCountIndicates number of active connections.Maximum
azure_mysql_flexibleservers_backup_storage_usedbackup_storage_usedBackup Storage UsedBytesIndicates amount of backup storage Used.Maximum
azure_mysql_flexibleservers_Com_alter_tableCom_alter_tableCom Alter TableCountThe number of times an ALTER TABLE statement has been executed.Total
azure_mysql_flexibleservers_Com_create_dbCom_create_dbCom Create DBCountThe number of times an CREATE DB statement has been executed.Total
azure_mysql_flexibleservers_Com_create_tableCom_create_tableCom Create TableCountThe number of times an CREATE TABLE statement has been executed.Total
azure_mysql_flexibleservers_Com_deleteCom_deleteCom DeleteCountThe number of times an DELETE statement has been executed.Total
azure_mysql_flexibleservers_Com_drop_dbCom_drop_dbCom Drop DBCountThe number of times an DROP DB statement has been executed.Total
azure_mysql_flexibleservers_Com_drop_tableCom_drop_tableCom Drop TableCountThe number of times an DROP TABLE statement has been executed.Total
azure_mysql_flexibleservers_Com_insertCom_insertCom InsertCountThe number of times an INSERT statement has been executed.Total
azure_mysql_flexibleservers_Com_selectCom_selectCom SelectCountThe number of times an ELECT statement has been executed.Total
azure_mysql_flexibleservers_Com_updateCom_updateCom UpdateCountThe number of times an UPDATE statement has been executed.Total
azure_mysql_flexibleservers_cpu_credits_consumedcpu_credits_consumedCPU Credits ConsumedCountIndicates the amount of CPU credits consumed.Maximum
azure_mysql_flexibleservers_cpu_credits_remainingcpu_credits_remainingCPU Credits RemainingCountIndicates the number of CPU credits are remaining.Maximum
azure_mysql_flexibleservers_cpu_percentcpu_percentHost CPU PercentPercentPercentage of host CPU.Maximum
azure_mysql_flexibleservers_HA_IO_statusHA_IO_statusHA IO StatusCountStatus for replication IO thread running.Maximum
azure_mysql_flexibleservers_HA_replication_lagHA_replication_lagHA Replication LagSecondsIndicates HA replication lag in seconds.Maximum
azure_mysql_flexibleservers_HA_SQL_statusHA_SQL_statusHA SQL StatusCountStatus for replication SQL thread running.Maximum
azure_mysql_flexibleservers_Innodb_buffer_pool_pages_dataInnodb_buffer_pool_pages_dataInnoDB Buffer Pool Pages DataCountThe number of pages in the InnoDB buffer pool containing data.Total
azure_mysql_flexibleservers_Innodb_buffer_pool_pages_dirtyInnodb_buffer_pool_pages_dirtyInnoDB Buffer Pool Pages DirtyCountThe current number of dirty pages in the InnoDB buffer pool.Total
azure_mysql_flexibleservers_Innodb_buffer_pool_pages_freeInnodb_buffer_pool_pages_freeInnoDB Buffer Pool Pages FreeCountThe number of free pages in the InnoDB buffer pool.Total
azure_mysql_flexibleservers_Innodb_buffer_pool_read_requestsInnodb_buffer_pool_read_requestsInnoDB Buffer Pool Read RequestsCountThe number of logical read requests.Total
azure_mysql_flexibleservers_Innodb_buffer_pool_readsInnodb_buffer_pool_readsInnoDB Buffer Pool ReadsCountThe 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_percentio_consumption_percentStorage IO PercentPercentIndicates storage I/O consumption percentage.Maximum
azure_mysql_flexibleservers_memory_percentmemory_percentHost Memory PercentPercentIndicates host memory percentage.Maximum
azure_mysql_flexibleservers_network_bytes_egressnetwork_bytes_egressHost Network OutBytesHost Network egress in bytes.Total
azure_mysql_flexibleservers_network_bytes_ingressnetwork_bytes_ingressHost Network InBytesHost Network ingress in bytes.Total
azure_mysql_flexibleservers_QueriesQueriesQueriesCountIndicates number of queries executed.Total
azure_mysql_flexibleservers_Replica_IO_RunningReplica_IO_RunningReplica IO StatusCountStatus for replication IO thread running.Maximum
azure_mysql_flexibleservers_Replica_SQL_RunningReplica_SQL_RunningReplica SQL StatusCountStatus for replication SQL thread running.Maximum
azure_mysql_flexibleservers_replication_lagreplication_lagReplication Lag In SecondsSecondsReplication lag in seconds.Maximum
azure_mysql_flexibleservers_serverlog_storage_limitserverlog_storage_limitServerlog Storage LimitBytesIndicates serverlog storage limit.Maximum
azure_mysql_flexibleservers_serverlog_storage_percentserverlog_storage_percentServerlog Storage PercentPercentIndicates serverlog storage percentage.Maximum
azure_mysql_flexibleservers_serverlog_storage_usageserverlog_storage_usageServerlog Storage UsedBytesIndicates serverlog storage used.Maximum
azure_mysql_flexibleservers_Slow_queriesSlow_queriesSlow QueriesCountThe number of queries that have taken more than long_query_time seconds.Total
azure_mysql_flexibleservers_storage_io_countstorage_io_countIO CountCountThe number of I/O consumed.Total
azure_mysql_flexibleservers_storage_limitstorage_limitStorage LimitBytesIndicates serverlog storage limit.Maximum
azure_mysql_flexibleservers_storage_percentstorage_percentStorage PercentPercentIndicates storage percentage.Maximum
azure_mysql_flexibleservers_storage_throttle_countstorage_throttle_countStorage Throttle CountCountStorage IO requests throttled in the selected time range.Maximum
azure_mysql_flexibleservers_storage_usedstorage_usedStorage UsedBytesIndicates amount of storage used.Maximum
azure_mysql_flexibleservers_total_connectionstotal_connectionsTotal ConnectionsCountTotal number of connections.Total

External reference

Azure Database for MySQL - Flexible Server