#!/bin/bash#For nagios.#sndapk(20140106)PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbinIFS=' 'export PATH IFSMYSQLPORT="3306"MYSQLIP="127.0.0.1"MYSQLUSER="slavemonitor"MYSQLPW="123456"MYSQL="/usr/local/mysql-5.0.92/bin/mysql"netstat -ntl | grep -q "$MYSQLPORT"if [ $? -ne 0 ];then echo "NO MYSQLD PROCESS!" exit 2fiSTATUS=$($MYSQL -h$MYSQLIP -u$MYSQLUSER -p$MYSQLPW -e "show slave status\G" | egrep -i 'Slave_IO_Running|Slave_SQL_Running|Seconds_Behind_Master')IO_status=`echo $STATUS | awk '/IO/{print $2}'`SQL_status=`echo $STATUS | awk '/SQL/{print $4}'`SEC_status=`echo $STATUS | awk '/Seconds/{print $6}'`if [ "$IO_status" == "Yes" ];then if [ "$SQL_status" == "Yes" ];then if [ "$SEC_status" -eq 0 ];then echo "Mysql copy OK!" exit 0 else echo "Seconds_behind_master:$SEC_status" exit 1 fi else echo "Slave_SQL thread is not running!" exit 2 fielse echo "Slave_IO thread is not running!" exit 2fi

注：

1、脚本中监控用的mysql用户(slavemonitor)仅需赋予SUPER权限。