nagios监控mysql主从

利用 nagios 自带的插件来监控 mysql 的主从同步状态
[主动方式]
1、调试check_mysql主从同步的命令
登录到从库的服务器上进行如下操作：
grant super,replication slave on *.* to nagios@'192.168.88.%' identified by 'tcs6688';
flush privileges;
nagios服务端：
1、用check_mysql插件进行检测
[root@Nagios ~]# /usr/local/nagios/libexec/check_mysql -H 192.168.88.253 -unagios -p tcs6688 -S
Uptime: 1017185  Threads: 1  Questions: 3485390  Slow queries: 0  Opens: 63  Flush tables: 1  Open tables: 57  Queries per second avg: 3.426 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0
2、编辑commands.cfg
[root@Nagios ~]# cd /usr/local/nagios/etc/objects/
[root@Nagios objects]# tail  commands.cfg

# 'check_mysql_slave' command definition
define command{

        command_name    check_mysql

        command_line    $USER1$/check_mysql -H $HOSTADDRESS$ -unagios -p tcs6688 -S -P3306
        }

        备注：-u指定用户，-P指定端口，-p指定密码，-s指定sock文件路径（多实例），-S监控主从

host文件中添加主机
#shenzhen/server host
define host{
use linux-server
host_name web253
address 192.168.88.253
}

server文件中添加服务
define service{
use   generic-service
host_name  web253
service_description mysql_slave
check_command check_mysql

3. 检查配置文件
/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
 service nagios reload


4.脚本监控
[root@zsq libexec]# cat check_mysql_slave
#!/bin/sh
declare -a slave_is
slave_is=($(mysql -ucheck -ptcs6688 -e "show slave status\G"|grep Running|awk '{print $2}'))
if [ "${slave_is[0]}" = "Yes" -a "${slave_is[1]}" = "Yes" ]
then
        echo "slave yes is ok"
exit 0
else
        echo "slave yes is error"
exit 2
fi

5、在/usr/local/nagios/etc/nrpe.cfg中添加监控mysql主从的命令

command[check_mysql_slave]=/usr/local/nagios/libexec/check_mysql_slave

6、编辑/usr/local/nagios/etc/objects/server.cfg ，添加监控mysql主从项目：

define service{
        use             generic-service
        host_name       light
        service_description     check_mysql_slave
        check_command           check_nrpe!check_mysql_slave
        }

4、重启nagios就OK了

/etc/init.d/nagios restart