Grafana Alerting and Email Notifications

See the original posting on DZone Python

Use Case: We shall be monitoring active connections on a MySQL database server and when the number of active connections crosses the threshold value then an alert shall be displayed on the dashboard and an email will be triggered on the configured email id with the snapshot of our graph indicating breach value and other information.


  1. Grafana: grafana-5.1.0
  2. fakeSMTP-2.0: SMTP server (works with any SMTP server)
  3. Operating System: Windows (for others steps may vary)


I assume that you already have setup and integrated Prometheus with Grafana. If not, then you can follow this article. I also assume that you have set up the monitoring for the MySQL server database. If not, then you can follow this article.