Emergency

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

    Hi,

    I am adding alerts for mysql instance using followed article https://www.percona.com/blog/2017/02...ed-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?

  • #2
    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:
    Code:
    up{instance="ps57",job="mysql"}
    mysqld_exporter-up.PNG

    Comment

    Working...
    X