Use the Azure portal to set up alerts on metrics for Azure Database for MySQL
APPLIES TO: Azure Database for MySQL - Single Server
Azure Database for MySQL - Single Server is on the retirement path. We strongly recommend for you to upgrade to Azure Database for MySQL - Flexible Server. For more information about migrating to Azure Database for MySQL - Flexible Server, see What's happening to Azure Database for MySQL Single Server?
This article shows you how to set up Azure Database for MySQL alerts using the Azure portal. You can receive an alert based on monitoring metrics for your Azure services.
The alert triggers when the value of a specified metric crosses a threshold you assign. The alert triggers both when the condition is first met, and then afterwards when that condition is no longer being met.
You can configure an alert to do the following actions when it triggers:
- Send email notifications to the service administrator and co-administrators
- Send email to additional emails that you specify.
- Call a webhook
You can configure and get information about alert rules using:
Create an alert rule on a metric from the Azure portal
In the Azure portal, select the Azure Database for MySQL server you want to monitor.
Under the Monitoring section of the sidebar, select Alerts as shown:
Select Add metric alert (+ icon).
The Create rule page opens as shown below. Fill in the required information:
Within the Condition section, select Add condition.
Select a metric from the list of signals to be alerted on. In this example, select "Storage percent".
Configure the alert logic including the Condition (ex. "Greater than"), Threshold (ex. 85 percent), Time Aggregation, Period of time the metric rule must be satisfied before the alert triggers (ex. "Over the last 30 minutes"), and Frequency.
Select Done when complete.
Within the Action Groups section, select Create New to create a new group to receive notifications on the alert.
Fill out the "Add action group" form with a name, short name, subscription, and resource group.
Configure an Email/SMS/Push/Voice action type.
Choose "Email Azure Resource Manager Role" to select subscription Owners, Contributors, and Readers to receive notifications.
Optionally, provide a valid URI in the Webhook field if you want it called when the alert fires.
Select OK when completed.
Specify an Alert rule name, Description, and Severity.
Select Create alert rule to create the alert.
Within a few minutes, the alert is active and triggers as previously described.
Manage your alerts
Once you have created an alert, you can select it and do the following actions:
- View a graph showing the metric threshold and the actual values from the previous day relevant to this alert.
- Edit or Delete the alert rule.
- Disable or Enable the alert, if you want to temporarily stop or resume receiving notifications.