I want to share this simple nagios plugin for monitoring mysql slaves replications states:
This plugin can be downloaded here. To install copy this script to nagios plugins directory (/usr/lib/nagios/plugins/). View script help for full options list:
# /usr/lib/nagios/plugins/check_mysql_sync.pl -h Check mysql sync between master and slave for Nagios version 0.1 Usage: /usr/lib/nagios/plugins/check_mysql_sync.pl [-v] -H <host> -p <port> -l <username> -x <password> -w <warn level> -c <crit level> [-V] -v, --verbose print extra debugging information -h, --help print this help message -H, --hostname=HOST name or IP address of host to check -l, --login username for mysql database (Default nagios) -x, --passwd=PASSWD password -p, --port=PORT MYSQL port (Default 3361) -w, --warn=INTEGER warning level for seconds behind sync -c, --crit=INTEGER critical level for seconds behind sync -V, --version prints version number
Run this command in your mysql master for grant to nagios user the required privileges:
GRANT PROCESS, REPLICATION CLIENT on *.* TO 'nagios'@'192.168.1.25' IDENTIFIED BY 'yourpass';