I am using this mysql slave status plugin and on the munin master I have added...

mysql_slave_status.warning 30
mysql_slave_status.critical 60

So it alerts whenever the slave gets behind the master. How do I get munin to alert me (critical alert if possible) when the plugin returns "NaN", will it do that automatically?

It returns NaN when the SQL isn't running or the connection fails.

EDIT: In the end I made it add a large number to the actual value if the connection was down.

  • I'm kinda surprised that munin doesn't do this automatically... – Shadow Jan 16 '17 at 23:24

Having written a bit of the mysql_ plugin I can attest to having replaced much of the single purpose plugins of munin. In the above link there is a documented example of what you want:

env.slave_io_running_warning 0.5
env.slave_sql_running_warning 0.5
env.seconds_behind_master_warning 300
env.seconds_behind_master_critical 600

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.