SolarWinds acquires Scout’s SaaS-based server monitoring technology and launches it as SolarWinds Pingdom Server Monitor. Read more
MySQL Replication Monitor ~ Pingdom Server Monitor
Plugins like this provide extra functionality beyond Pingdom Server Monitor's default monitoring capabilities. This and 90+ other plugins are available via a one-click install in our web interface.

MySQL Replication Monitor

Mysql

Monitors the replication for a master-slave MySQL database setup reporting the number of seconds the slave is behind the master.

Overview

Monitors the replication for a master-slave MySQL database setup reporting the number of seconds the slave is behind the master.

If replication is not running an alert is generated. An ignore window can also be provided.

This plugin should be installed on the slave machine.

Dependencies

This plugin requires the mysql Ruby gem. To install:

[sudo] gem install mysql

Debugging

If the plugin is generating errors, you can test out the command manually on your server:

mysql -hHost -uUsername -pPassword -e"show slave status"
By Mike Mangino, Andre Lewis