icinga monitor mysql slave replication

icinga monitor msyql slave replication status

At SLAVE mysql server create a user with replication privileges
mysql> GRANT REPLICATION CLIENT on *.* TO 'nagios'@'%' IDENTIFIED BY '1LumbIni2$';
mysql> flush privileges;

 service mysql restart

At  ICINGA server
download nagios mysql slave monitoring script

wget  http://www.claudiokuenzler.com/nagios-plugins/check_mysql_slavestatus.sh
chown icinga.icinga check_mysql_slavestatus.sh; chmod +x check_mysql_slavestatus.sh;

  #./check_mysql_slavestatus.sh -H 198.50.176.187 -u nagios -p 1LumbIni2$ -P 3306
OK: Slave SQL running: Yes Slave IO running: Yes / master: 5.9.240.235 / slave is 0 seconds behind master | delay=0s

Define commands in commands.cfg
# 'check_mysql_slavestatus' command definition
define command{
command_name check_mysql_slavestatus
command_line $USER1$/check_mysql_slavestatus.sh -H $HOSTADDRESS$ -P $ARG1$ -u $ARG2$ -p $ARG3$
}

# 'check_mysql_slavestatus' command definition with delay check
define command{
command_name check_mysql_slavestatus
command_line $USER1$/check_mysql_slavestatus.sh -H $HOSTADDRESS$ -P $ARG1$ -u $ARG2$ -p $ARG3$ -w $ARG4$ -c $ARG5$
}

Now create service for checking

define service{
use generic-service ; Name of service template to use
host_name gskhanalslave
service_description MySQL Replication Status
check_command check_mysql_slavestatus!3306!nagios!1LumbIni2$
}