How to add alerts for mysql server uptime/restart/shutdown

[ivishnu7]

Hi,

I am adding alerts for mysql instance using followed article https://www.percona.com/blog/2017/02/02/pmm-alerting-with-grafana-working-with-templated-dashboards/ . I am seeing alert tab for mysql connection/ thread cache and for all other alerts, but not for MySQL uptime. Is there any way to add alert for MySQL uptime?

[Michael_Coburn]

Hi ivishnu7 , I haven’t done this specific type of graph, but Prometheus allows for a metric called ‘up’, which is tracking whether mysqld_exporter is up. Perhaps you could create a graph using:

up{instance="ps57",job="mysql"}

[Mykola]

also metric exists, it is possible to create graph with this metric and add alert on it.

[ivishnu7]

Thanks Michael and Mykola for update.

Notes from Grafana: Currently only the graph panel supports alert rules but this will be added to the Single stat and Table panels as well in a future release.

So as of now, we can’t use Grafana for server uptime/restart/shutdown alerts unless they add alerts for Single stats.

I am familiar with Grafana alerts set up but not with Prometheus alerts. So I am just going through how to add alerts using Prometheus. It would be great if share any useful documents regarding prometheus alerts set up. Thanks!

[Mykola]

prometheus alerting is not user-friendly, you can read more in official documentation https://prometheus.io/docs/alerting/overview/

Alerts in Grafana simpler (if you have graph for needed metric):
https://www.percona.com/blog/2017/01/23/mysql-and-mongodb-alerting-with-pmm-and-grafana/
https://www.percona.com/blog/2017/02/02/pmm-alerting-with-grafana-working-with-templated-dashboards/