Skip to main content

Azure Database for MariaDB

Pack Assets​

Templates​

The Centreon Plugin Pack Azure Database for MariaDB brings a host templates:

  • Cloud-Azure-Database-MariaDB-custom

It brings the following service templates:

Service AliasService TemplateService DescriptionDefault
ConnectionsCloud-Azure-Database-MariaDB-Connections-ApiCheck Azure Database for MariaDB connections statisticsX
CpuCloud-Azure-Database-MariaDB-Cpu-ApiCheck Azure Database for MariaDB CPU usageX
IO-ConsumptionCloud-Azure-Database-MariaDB-IO-Consumption-ApiCheck Azure Database for MariaDB IO usageX
MemoryCloud-Azure-Database-MariaDB-Memory-ApiCheck Azure Database for MariaDB memory usageX
ReplicationCloud-Azure-Database-MariaDB-Replication-ApiCheck Azure Database for MariaDB replication statusX
StorageCloud-Azure-Database-MariaDB-Storage-ApiCheck Azure Database for MariaDB storage statisticsX
TrafficCloud-Azure-Database-MariaDB-Traffic-ApiCheck Azure Database for MariaDB network usageX

Discovery rules​

The Centreon Plugin Pack Azure Database for MariaDB includes a Host Discovery provider to automatically discover the Azure instances of a given subscription and add them to the Centreon configuration. This provider is named Microsoft Azure Database for MariaDB:

image

This discovery feature is only compatible with the api custom mode. azcli is not supported.

More information about discovering hosts automatically is available on the dedicated page.

Collected metrics & status​

Metric NameUnit
azmariadb.connections.active.count
azmariadb.connections.failed.count

Prerequisites​

Please find all the prerequisites needed for Centreon to get information from Azure on the dedicated page.

Setup​

  1. Install the plugin package on every Centreon poller expected to monitor Azure Database MariaDB resources:
yum install centreon-plugin-Cloud-Azure-Database-MariaDB-Api
  1. On the Centreon web interface, on page Configuration > Plugin Packs, install the Azure Database for MariaDB Centreon Plugin Pack.

Configuration​

Host​

  • Log into Centreon and add a new host through Configuration > Hosts.
  • In the IP Address/DNS field, set the following IP address: 127.0.0.1.
  • Aplly the Cloud-Azure-Database-MariaDB-custom template to the host.
  • Once the template is applied, fill in the corresponding macros. Some macros are mandatory. These mandatory macros differ depending on the custom mode used.

Two methods can be used to set the macros:

  • Full ID of the Resource (/subscriptions/<subscription_id>/resourceGroups/<resourcegroup_id>/providers/XXXXX/XXXXX/<resource_name>) in AZURERESOURCE
  • Resource name in the AZURERESOURCE macro, and resource group name in the AZURERESOURCEGROUP macro.
ObligatoireMacroDescription
XAZUREAPICUSTOMMODECustom mode api
XAZURECLIENTIDClient ID
XAZURECLIENTSECRETClient secret
XAZURERESOURCEID or name of the Azure Database MariaDB resource
AZURERESOURCEGROUPResource group name if resource name is used
XAZURESUBSCRIPTIONSubscription ID
XAZURETENANTTenant ID

How to check in the CLI that the configuration is OK and what are the main options for?​

Once the plugin is installed, log into your Centreon poller's CLI using the centreon-engine user account (su - centreon-engine) and test the plugin by running the following command:

/usr/lib/centreon/plugins//centreon_azure_database_mariadb_api.pl \
    --plugin=cloud::azure::database::mariadb::plugin \
    --mode=traffic \
    --custommode='api' \
    --resource='' \
    --resource-group='' \
    --subscription='' \
    --tenant='' \
    --client-id='' \
    --client-secret='' \
    --proxyurl='' \
    --filter-metric='' \
    --filter-dimension='' \
    --timeframe='900' \
    --interval='PT5M' \
    --aggregation='Average' \
    --warning-serverlog-percent='' \
    --critical-serverlog-percent='' \
    --warning-storage-percent='' \
    --critical-storage-percent='' \
    --warning-storage-backup='' \
    --critical-storage-backup='' \
    --warning-storage-used='' \
    --critical-storage-used='' \
    --warning-storage-limit='' \
    --critical-storage-limit='' \
    --warning-serverlog-usage='' \
    --critical-serverlog-usage='' \
    --warning-serverlog-limit='' \
    --critical-serverlog-limit='' \
    --use-new-perfdata

The expected command output is shown below:

OK: Instance 'myresource' Statistic 'maximum' Metrics Server Log storage percent: 0.00%, Storage Percent: 14.41%, Backup Storage used: 28.90GB, Storage Used: 21.62GB, Storage Limit: 150.00GB, Server Log storage used: 0.00B, Server Log storage limit: 7.00GB | 'myresource~maximum#azmariadb.storage.serverlog.usage.percentage'=0.00%;;;0; 'myresource~maximum#azmariadb.storage.usage.percentage'=14.41%;;;0; 'myresource~maximum#azmariadb.storage.backup.usage.bytes'=31029043513.00B;;;0; 'myresource~maximum#azmariadb.storage.usage.bytes'=23212425216.00B;;;0; 'myresource~maximum#azmariadb.storage.limit.bytes'=161061273600.00B;;;0; 'myresource~maximum#azmariadb.storage.serverlog.usage.bytes'=0.00B;;;0; 'myresource~maximum#azmariadb.storage.serverlog.limit.bytes'=7516192768.00B;;;0;

All available options for a given mode can be displayed by adding the --help parameter to the command:

/usr/lib/centreon/plugins//centreon_azure_database_mariadb_api.pl \
    --plugin=cloud::azure::database::mariadb::plugin \
    --mode=storage \
    --help

All available modes can be displayed by adding the --list-mode parameter to the command:

/usr/lib/centreon/plugins//centreon_azure_database_mariadb_api.pl \
    --plugin=cloud::azure::database::mariadb::plugin \
    --list-mode

Troubleshooting​

Please find the troubleshooting documentation for the API-based plugins in this chapter.