Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

To use the SQL DM for MySQL Notification alert functionality to send you alerts about a MySQL server you need to configure the different Notification channels from “Settings -> Notification & Maintenance”. Once you configure the notification channels from the Settings page, those channels are now be available for sending alerts for each of the servers. If you have enabled all the channels, then you get the following alert options: Email, SNMP, Slack, Pagerduty and Syslog.

Different Notification Channels

Email

Use this option, to get SQL DM for MySQL alerts via Email. Once you enable it, enter the addresses to which SQL DM for MySQL is to send e-mails.

There is an Option to set a distinct email distribution list for warning and critical alerts. You can define a proper demarcation between the users who receives a particular alert based on the alert status. For instance, if you want only your on-call DBAs to receive critical alerts 24/7, this feature handles that easily. Please refer to Mail Settings for more information. Details about the SMTP server to use. SQL DM for MySQL does not have a SMTP server of its own. It needs to connect to a SMTP server on the Internet, your local network or your local computer. The settings are the same you enter when installing or configuring a mail client program like Outlook or Outlook Express.

SNMP

Enable this option to get alerts via SNMP traps. Refer to SNMP settings for more information

Write to Syslog

Enable this option if you want SQL DM for MySQL to write the alerts in the Syslog (of the machine where SQL DM for MySQL is installed). Refer to SYSLOG Settings for more information.

Slack Notifications

Use this option to send alerts to Slack. Like Pagerduty, you get a drop-down option to select a slack channel to which the alerts can be sent to. Refer to Slack Settings for more information.

Pagerduty Notifications

Enable this option to get alerts on Pagerduty. After enabling, you get a drop-down option to select a rule which you created at Settings -> Notification & Maintenance -> PAGERDUTY. All the alerts are sent to this rule in Pagerduty. Refer to Pagerduty Settings for more information.

...