Azure Database for MySQL monitoring

The Azure Database for MySQL overview page serves as a comprehensive overview of your MySQL servers and database instances. From here you can gain full visibility and check if your database is healthy, under-performing, or if there are any failed connections.

Prerequisites

  • Dynatrace version 1.196+
  • Environment ActiveGate version 1.195+

Enable monitoring

To enable monitoring for Azure Database for MySQL, you first need to set up integration with Azure Monitor.
Optionally, for OneAgent integration, see how database activity is monitored.

Add the service to monitoring

In order to view the service metrics, you must add the service to monitoring in your Dynatrace environment.

Monitor resources based on tags

You can choose to monitor resources based on existing Azure tags, as Dynatrace automatically imports them from service instances.

To monitor resources based on tags

  1. In the Dynatrace menu, go to Settings > Cloud and virtualization > Azure and select the Azure instance.
  2. For Resource monitoring method, select Monitor resources based on tags.
  3. Enter the Key and Value.
  4. Select Save.

Note: To import the Azure tags automatically into Dynatrace, enable Capture Azure tags automatically.

Configure service metrics

Once you add a service, Dynatrace starts automatically collecting a suite of metrics for this particular service. These are recommended metrics.

Recommended metrics:

  • Are enabled by default
  • Can't be disabled
  • Can have recommended dimensions (enabled by default, can't be disabled)
  • Can have optional dimensions (disabled by default, can be enabled).

Apart from the recommended metrics, most services have the possibility of enabling optional metrics.

Optional metrics:

  • Can be added and configured manually

View service metrics

You can view the service metrics in your Dynatrace environment either on the custom device overview page or on your Dashboards page.

View metrics on the custom device overview page

To access the custom device overview page

  1. In the Dynatrace menu, go to Technologies.
  2. Filter by service name and select the relevant custom device group.
  3. Once you select the custom device group, you're on the custom device group overview page.
  4. The custom device group overview page lists all instances (custom devices) belonging to the group. Select an instance to view the custom device overview page.

View metrics on your dashboard

Once you add a service to monitoring, a preset dashboard for the respective service containing all recommended metrics is automatically created on your Dashboards page. You can look for specific dashboards by filtering by Preset and then by Name.

Note: For existing monitored services, you might need to resave your credentials for the preset dashboard to appear on the Dashboards page. To resave your credentials, go to Settings > Cloud and virtualization > Azure, select the desired Azure instance, then select Save.

You can't make changes on a preset dashboard directly, but you can clone and edit it. To clone a dashboard, open the browse menu () and select Clone.
To remove a dashboard from the dashboards list, you can hide it. To hide a dashboard, open the browse menu () and select Hide.
Note: Hiding a dashboard doesn't affect other users.
clone-hide-azure

mysql-dash

Set up a management zone

To import a dashboard for Azure Database for MySQL, you need to set up a management zone to limit the entities displayed on the dashboard to those relevant to this service.

When you create a management zone for this dashboard:

  1. Create a rule that identifies services based on a common property:
    • Service type equals Database
    • Service topology equals Opaque service
  2. Add a condition for the database name to contain the mysql string (case sensitive.)

After you create the management zone, assign it to your dashboard (from the dashboard, select Edit > Settings > Default management zone). For more information, see Dashboard timeframe and management zone.

Available metrics

Name Description Dimensions Unit Recommended
active_connections Active connections None Count ✔️
backup_storage_used Backup storage used None Bytes
cpu_percent CPU percent None Percent ✔️
connections_failed Failed connections None Count ✔️
io_consumption_percent IO percent None Percent ✔️
memory_percent Memory percent None Percent ✔️
network_bytes_ingress Network In across active connections None Bytes ✔️
network_bytes_egress Network Out across active connections None Bytes ✔️
seconds_behind_master Replication lag in seconds None Count ✔️
serverlog_storage_limit Server log storage limit None Bytes
serverlog_storage_percent Server log storage percent None Percent ✔️
serverlog_storage_usage Server log storage used None Bytes
storage_limit Storage limit None Bytes
storage_percent Storage percent None Percent ✔️
storage_used Storage used None Bytes