New Relic's integrations include an integration for reporting your Microsoft Azure Database for MySQL metrics and other data to New Relic. This document explains how to activate the integration and describes the data reported.
Features
New Relic gathers database data from the Azure Database for MySQL service, which provides fully managed, enterprise-ready MySQL Community database as a service. The service provides high availability, elastic scaling, automatic backups, and data protection at-rest and in-motion.
Using New Relic, you can:
- View Azure Database for MySQL data in pre-built dashboards.
- Run custom queries and visualize the data in New Relic One.
- Create alert conditions to notify you of changes in data.
Activate integration
Follow standard procedures to activate your Azure service in New Relic Infrastructure.
Configuration and polling
You can change the polling frequency and filter data using configuration options.
New Relic queries your Azure Database services according to a default polling interval, which varies depending on the integration. For Azure Database for MySQL integrations:
- Polling interval: 5 minutes (maximum recommended polling frequency: 1 hour)
- Resolution: 1 data point per minute
Find and use data
To explore your integration data, go to one.newrelic.com > Infrastructure > Azure > (select an integration).
Data about a single database is attached to the AzureMySqlServerSample
event type, with a provider value of AzureMySqlServer
.
Metric data
This integration collects the following metric data.
Database sample metrics
Metric | Description |
---|---|
| Count of active connections. |
| Backup storage used, in bytes. |
| Count of failed connections. |
| Percentage of CPU used. |
| Percentage of memory used. |
| Network Out across active connections, in bytes. |
| Network In across active connections, in bytes. |
| Replication lag, in seconds. |
| Server log storage limit, in bytes. |
| Percentage of server log storage used. |
| Server log storage used, in bytes. |
| Amount of storage available, in bytes. |
| Percentage of available storage used. |
| Amount of storage used, in bytes. |
Inventory data
EOL NOTICE
After March 2022, we're discontinuing support for several capabilities, including inventory data for cloud integrations. For more details, including how you can easily prepare for this transition, see our Explorers Hub post.
This integration collects the following inventory data about your system's state and configuration.
azure/mysql/server/
administratorLogin
configuration
databaseNames
databases
domainName
earliestRestoreDate
firewalls
geoRedundantBackup
isDataWarehouse
isReplica
MasterServerid
maxConnections
name
regionName
replicaCapacity
resourceGroupName
skuCapacity
skuFamily
skuName
skuTier
sslEnforcement
storageAutoGrow
tags
type
userVisibleState
version