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
|
本文转自vcdog 51CTO博客，原文链接：http://blog.51cto.com/255361/836925，如需转载请自行联系原作者
