Azure Database for MariaDB

On the Azure Database for MariaDB overview page you can see if you’re running out of CPU or facing a high I/O percentage, so you always know which queries need to be optimized.

Prerequisites

  • Dynatrace version 1.196+
  • Environment ActiveGate version 1.195+

Enable monitoring

To enable monitoring for Azure Database for MariaDB, 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.

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

Once you add the service to monitoring, you can view the service metrics in your Dynatrace environment either on your dashboard page or on the custom device overview page.

Import preset dashboards

Dynatrace provides preset Azure dashboards that you can import from GitHub to your environment's Dashboards page.
Note: To save a preset dashboard locally, create a new JSON file on your local machine and copy-paste the content of the JSON file from GitHub into the new file.
Once you save a preset dashboard locally, there are two ways to import it.

mariadb-dash

Set up a management zone

To import a dashboard for Azure Database for MariaDB, 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: Database
    • Technology: MariaDB
    • Service topology: Opaque service
  2. Add a condition for the database name to contain the mariadb string (case sensitive.)

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

Available metrics

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