The options here offer you to configure multiple notification channels. To route the alerts generated in SQL DM for MySQL, you have to enable and configure the required channels.
This section provides details to customize the Subject format of the alert notifications that you receive from SQL DM for MySQL.
The default format is MONyog | [$ALERT_TYPE] | [$SERVER_NAME] | [$MSG_DETAILS]
[$ALERT_TYPE] : It describes the severity of the alert - the values can be Critical, Warning, Stable, and INFO. Alert type is set up based on the type of the alert for which the email was generated. The alert type is based on the conditions described below:
SQL DM for MySQL sends critical alerts to the registered emails in a number of scenarios:
Warning alerts are sent when it meets the following conditions:
[$SERVER_NAME] : Name of the server for which the alert is generated. For Low disk space mails, the server_name is Monyog-Host.
[$MSG_DETAILS] : This specifies the details of the Alert.
For example, “Linux: CPU usage - 74.4%” OR “Long Running Query: QUERY” OR “Server configuration change detected" Or "Server restarted".
If there are more than one monitor alert in an email then it lists down the number of events in the email, i.e, “n Events” where ‘n’ is the “total no of events”.
E.g.: MONyog | Critical | Production | 2 Events.
You can use the Set Default option(the refresh button) to revert back to the default format.
Use this action to specify the SMTP server address and the from address of the e-mail sender.
Reply-to email: Enter email address of the recipient (or recipients) of the email message. This field must be in standard name@domain.com address format unless your relay server is prepared to accept default domain from addresses.
To add multiple recipients, specify multiple recipients by simply separating the email addresses with a comma ",". Example: me@here.com, you@there.com, somebody@somewhere.com. |
Encryption: Select the type of Encryption - SSL/TLS mail encryption which is now supported for mail alerts.
Most problems involving configuration of the Email alert are due primarily to an invalid email address format specified in the FROM/TO fields. Please refer Registering servers for more information. |
For more information, see Automatic Email Notifications. |
Use this action to specify the SNMP settings and options available for use with SQL DM for MySQL.
Click Settings -> Notification & Maintenance -> SNMP to navigate to the SNMP settings page.
Note more information on types of Traps:
Monitor traps are sent when the Send notifications over SNMP option is enabled, and the corresponding counters have mail alert enabled through the MOM.
Click Settings -> Notification & Maintenance -> PAGERDUTY to navigate to the PagerDuty settings page.
PagerDuty integration allows you to route alerts to your PagerDuty service.
Use the integration key of the service that you want SQL DM for MySQL alerts to be sent to and select the type of alerts to be sent out. Click Test to verify whether the integration is configured successfully.
Also, you can create multiple routing rules based on the requirement for different servers registered with SQL DM for MySQL. To create a new rule select CREATE NEW RULE option in the drop down.
Make sure that the integration key that you add has the integration type as API. |
Click Settings -> Notification & Maintenance -> SLACK to navigate to the SLACK settings page.
You can Integrate Slack to SQL DM for MySQL to receive the alerts and notifications from SQL DM for MySQL to your Slack channel.
Enter the name of the Channel that you want SQL DM for MySQL alerts to be sent to in the SLACK CHANNEL field, enter the Incoming Webhook in the WEBHOOK URL field and Select the desired Alert Type. To ensure that the rule is configured successfully, try out the rule by clicking Test.
Click Settings -> Notification & Maintenance -> SYSLOG to navigate to the SYSLOG settings page.
On enabling this option SQL DM for MySQL can write out the alerts and notifications to the Syslog (of the machine where SQL DM for MySQL is installed).
This is applicable only for Linux installations. |
Using this Maintenance option, you can enable/disable data collection from and/or alerting about all servers.
You can enable/disable data collection option and alert for all the registered server using Settings -> Notification & Maintenance -> Maintenance.
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal |