check_mysql-replication.pl

Project Notes

How to use : ------------ 1 - first you have to create an user with the REPLICATION CLIENT (or you can just grant this privilege) mysql> GRANT REPLICATION CLIENT ON *.* TO 'replicateur'@'localhost' 2 - then just run the script : $./check_mysql-replication.pl --help check_mysql-replication.pl version 0.1 by Erwan Labynocle Ben Souiden This plugin checks your mysql replication threads and your lag synchronisation Usage: //check_mysql-replication.pl [-a process|lag] [-p] [-D "CHECK MySQL REPLICATION - "] [-v] [-m] [-c 10] [-w 5] Options: -h, --help Print detailed help screen -V, --version Print version information -D, --display=STRING to modify the output display... default is "CHECK MySQL REPLICATION - " -sa, --slave-address=STRING address or name of the slave mysql server default is 127.0.0.1 -sp, --slave-port=STRING port number of the slave mysql server default is 3306 -sl, --slave-login=STRING mysql login default is user1 -spd, --slave-password=STRING mysql password default is password1 -a, --action=STRING specify the action : process|lag default is process process : display state of slave threads lag : display the number of second behind the master -c, --critical=INT specify a threshold for the lag action. default is 10 -w, --warning=INT specify a threshold for the lag action. default is 5 -m, --more Print a longer output. By default, the output is not complet because Nagios may truncate it. This option is just for you -p, --perfdata If you want to activate the perfdata output -v, --verbose Show details for command-line debugging (Nagios may truncate the output) Send email to [email protected] if you have questions regarding use of this software. To submit patches or suggest improvements, send email to [email protected] This plugin has been created by Erwan Labynocle Ben Souiden Hope you will enjoy it ;) Let me know if you find any bugs or if you have comments : erwanATaleikoumDOTnet