---
title: "Host Template: Cloud - Azure - MySQL Server"
description: ""
url: "https://docs.itrsgroup.com/docs/opsview/6.11.7/opspacks/cloud-azure-opspack/cloud-azure-mysql-server-host-template/index.html"
---## Overview

SQL Azure is Microsoft's cloud database service. Based on SQL Server database technology and built on Microsoft's Windows Azure cloud computing platform, SQL Azure enables organizations to store relational data in the cloud and quickly scale the size of their databases.

This Host Template includes the following Service Checks:

| Service&nbsp;Check&nbsp;Name | Description | Default&nbsp;Thresholds (Metric:&nbsp;Warning,&nbsp;Critical) | UOM |
|:-----------------------------|:------------|:------------------------------------------------:|:---:|
| Azure - MySQL - Active Connections | The average number of active connections
[Default Timespan = 5mins, Default Check Interval = 5mins] | N/A | N/A |
| Azure - MySQL - Backup Storage Used | The average backup storage usage
[Default Timespan = 15mins, Default Check Interval = 15mins] | N/A | B |
| Azure - MySQL - CPU Percent | The CPU usage
[Default Timespan = 5mins, Default Check Interval = 5mins] | cpu_percent: &#8203;`$WARNINGDT;70;85$`,`$CRITICALDT;90;95$`
[[Supports Dynamic Thresholds]](#dynamic-thresholds-support) | % |
| Azure - MySQL - Connections Failed | The the number of failed connections
[Default Timespan = 5mins, Default Check Interval = 5mins] | N/A | N/A |
| Azure - MySQL - IO Consumption Percent | The average IO consumption
[Default Timespan = 5mins, Default Check Interval = 5mins] | io_consumption_percent: &#8203;`$WARNINGDT;70;85$`,`$CRITICALDT;90;95$`
[[Supports Dynamic Thresholds]](#dynamic-thresholds-support) | % |
| Azure - MySQL - Memory Percent | The memory usage
[Default Timespan = 5mins, Default Check Interval = 5mins] | memory_percent: &#8203;`$WARNINGDT;70;85$`,`$CRITICALDT;90;95$`
[[Supports Dynamic Thresholds]](#dynamic-thresholds-support) | % |
| Azure - MySQL - Network In | The number of bytes received across active connections
[Default Timespan = 5mins, Default Check Interval = 5mins] | N/A | B |
| Azure - MySQL - Network Out | The number of bytes sent across active connections
[Default Timespan = 5mins, Default Check Interval = 5mins] | N/A | B |
| Azure - MySQL - Replication Lag | The average replication lag in seconds
[Default Timespan = 5mins, Default Check Interval = 5mins] | N/A | s |
| Azure - MySQL - Server Log Storage Limit | The average server log storage limit
[Default Timespan = 5mins, Default Check Interval = 5mins] | N/A | B |
| Azure - MySQL - Server Log Storage Percent | The average server log storage usage percentage
[Default Timespan = 5mins, Default Check Interval = 5mins] | serverlog_storage_percent: &#8203;`$WARNINGDT;70;85$`,`$CRITICALDT;90;95$`
[[Supports Dynamic Thresholds]](#dynamic-thresholds-support) | % |
| Azure - MySQL - Server Log Storage Used | The average server log storage usage
[Default Timespan = 5mins, Default Check Interval = 5mins] | N/A | B |
| Azure - MySQL - Storage Limit | The average storage limit
[Default Timespan = 5mins, Default Check Interval = 5mins] | N/A | B |
| Azure - MySQL - Storage Percent | The storage usage
[Default Timespan = 5mins, Default Check Interval = 5mins] | storage_percent: &#8203;`$WARNINGDT;70;85$`,`$CRITICALDT;90;95$`
[[Supports Dynamic Thresholds]](#dynamic-thresholds-support) | % |
| Azure - MySQL - Storage Used | The storage usage in bytes
[Default Timespan = 5mins, Default Check Interval = 5mins] | N/A | B |


**Note**


The "Default Timespan" given for these Service Checks refers to the time period we use when retrieving metrics from Azure.




**Note**


See details about [Monitoring Plugin thresholds here](https://www.monitoring-plugins.org/doc/guidelines.html#THRESHOLDFORMAT).



### Dynamic Thresholds Support

Some Service Checks within this Host Template support [Dynamic Thresholds for Opsview Enterprise](https://docs.itrsgroup.com/docs/opsview/6.11.7/integrations/dynamic-thresholds/configuring-dynamic-thresholds/index.html#configure-service-checks).

## Prerequisites for monitoring

### Provide Subscription Access

To use this Host Template you will need to provide access to the subscription you wish to monitor.
Navigate to the **Subscriptions** section and select your Subscription.

In the Subscription to be monitored, click **Access Control (IAM)**.

Then click the **Add** button, select the required role and select the application, once for each of the following roles:

- **Reader**

![Add Subscription to Application](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-add_subscription_1.png)

![Add Subscription to Application](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-add_subscription_2.png)

Repeat these steps for each subscription you wish to monitor.

## Usage Instructions

Please review the overall [Cloud - Azure Opspack](https://docs.itrsgroup.com/docs/opsview/6.11.7/opspacks/cloud-azure-opspack/cloud-azure-opspack/index.html) documentation for details on prerequisites, known issues, and other necessary configurations that apply to all Host Templates in the Opspack.

### Add this Host Template

Add the **Cloud - Azure - MySQL Server** Host Template to your Opsview Monitor host.
If the resource you're monitoring has no hostname or public IP, then open the **Advanced** settings pane and change **Host Check Command** to **Always assumed to be UP**.


**Note**


For more information, refer to the documentation on [Adding Host Templates to Hosts](https://docs.itrsgroup.com/docs/opsview/6.11.7/host/index.html#host-templates).



### Add and configure Variables

The Service Checks in this Host Template use the following variables, and they will be added to your Opsview Monitor instance alongside the Host Template:

- [**AZURE_CREDENTIALS**](#azure_credentials)
- [**AZURE_RESOURCE_DETAILS**](#azure_resource_details)


**Note**


For more information, refer to the documentation on [Adding Variables to Hosts](https://docs.itrsgroup.com/docs/opsview/6.11.7/adding-a-new-variable/index.html#adding-a-variable-to-a-host).



### Apply Changes

Apply Changes and the system will now be monitored:

![View Output](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-output-cloud-azure-mysql-server.png)

## Available Variables

### AZURE_CREDENTIALS

The Value is not used and therefore can be set to anything. Override the arguments with your Azure Credentials.

| Plugin&nbsp;Parameter | Position&nbsp;in Variable | Name | Description |
|:---------------------:|:-------------------------:|:-----|:------------|
| N/A (Opsview UI Only) | Value | Credentials | The credentials for your Azure Subscription |
| `--subscription-id` | Arg1 | Subscription ID | The Subscription ID of your Azure Subscription |
| `--client-id` | Arg2 | Client ID | The Client ID of your Azure Subscription |
| `--secret-key` | Arg3 | Secret Key | The Secret Key of your Azure Subscription |
| `--tenant-id` | Arg4 | Tenant ID | The Tenant ID of your Azure Subscription |

### AZURE_RESOURCE_DETAILS

The Value is not used and therefore can be set to anything. Override the arguments with your Azure Resource Details.

| Plugin&nbsp;Parameter | Position&nbsp;in Variable | Name | Description |
|:---------------------:|:-------------------------:|:-----|:------------|
| N/A (Opsview UI Only) | Value | Resource Details | The details of your Azure Resource |
| `--resource-group` | Arg1 | Resource Group | Name of the Azure resource group of your resource |
| `--resource-name` | Arg2 | Resource Name | Name of the Azure resource to be monitored |

## Plugin help

Plugin: `check_azure`


**Secure Args**


This plugin uses the [Secure Args](https://docs.itrsgroup.com/docs/opsview/6.11.7/configuration/secure-arguments/index.html) feature for argument passing.



For mode-specific help, run the plugin with the `-h -m <mode>` flags. This will list the required and optional Variable Arguments for that mode.
The appropriate mode for each Service Check is listed here:

| Service&nbsp;Check&nbsp;Name | Mode |
|:-----------------------------|:-----|
| Azure - MySQL - Active Connections | `MYSQL.Active.Connections` |
| Azure - MySQL - Backup Storage Used | `MYSQL.Backup.Storage.Used` |
| Azure - MySQL - CPU Percent | `MYSQL.CPU.Percent` |
| Azure - MySQL - Connections Failed | `MYSQL.Connections.Failed` |
| Azure - MySQL - IO Consumption Percent | `MYSQL.IO.Consumption.Percent` |
| Azure - MySQL - Memory Percent | `MYSQL.Memory.Percent` |
| Azure - MySQL - Network In | `MYSQL.Network.In` |
| Azure - MySQL - Network Out | `MYSQL.Network.Out` |
| Azure - MySQL - Replication Lag | `MYSQL.Replication.Lag` |
| Azure - MySQL - Server Log Storage Limit | `MYSQL.Server.Log.Storage.Limit` |
| Azure - MySQL - Server Log Storage Percent | `MYSQL.Server.Log.Storage.Percent` |
| Azure - MySQL - Server Log Storage Used | `MYSQL.Server.Log.Storage.Used` |
| Azure - MySQL - Storage Limit | `MYSQL.Storage.Limit` |
| Azure - MySQL - Storage Percent | `MYSQL.Storage.Percent` |
| Azure - MySQL - Storage Used | `MYSQL.Storage.Used` |


