mysql主从同步监控小脚本

mysql主从同步监控小脚本

 

可以将其结合nagios监控,用来做监控报警:

 

#!/bin/sh
#file is slave_repl.sh
#Author by Kevin
#date is 2011-11-13

declare -a slave_stat
slave_stat=($(/apps/usr/mysql-3307/bin/mysql -h slave_hostname -uroot -p123456 -P 3307 -e "show slave status\G"|grep Running |awk
 '{print $2}'))
if [ "${slave_stat[0]}" = "Yes" -a "${slave_stat[1]}" = "Yes" ]
     then
     echo "OK slave is running"
     exit 0
else
     echo "Critical slave is error"
     exit 2
fi