mysql主从同步监控小脚本(加强版)：
新版本脚本增加了“当发现同步出现无法同步的时候”会自动提取主库的file号，以及pos,进行同步主库，脚本内容如下：
- #!/bin/sh
- #set -x
- #file is slave_repl.sh
- #Author by Kevin
- #date is 2011-11-13
- mstool="/usr/local/mysql-3307/bin/mysql -h 192.168.1.106 -uroot -pw!zl7POg27 -P 3307"
- sltool="/usr/local/mysql-3307/bin/mysql -h 192.168.1.107 -uroot -pw!zl7POg27 -P 3307"
- declare -a slave_stat
- slave_stat=((sltool -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"
- echo
- echo "*********************************************************"
- echo "Now Starting replication with Master Mysql!"
- file=`$mstool -e "show master status\G"|grep "File"|awk '{print $2}'`
- pos=`$mstool -e "show master status\G"|grep "Pos"|awk '{print $2}'`
- $sltool -e "slave stop;change master to master_host='192.168.1.106',master_port=3307,master_user='repl',master_password='w!zl7POg27',master_log_file='file′,masterlogpos=pos;slave start;"
- sleep 3
- $sltool -e "show slave status\G;"|grep Running
- echo
- echo "Now Replication is Finished!"
- echo
- echo "**********************************************************"
- exit 2
- fi
运行后效果，如下图：
- # ./slave_stop3307.sh
- *******************************
- Now stop Slave Replication!
- Slave_IO_Running: No
- Slave_SQL_Running: No
- *******************************
- # ./slave_repl3307.sh
- Critical slave is error
- *********************************************************
- Now Starting replication with Master Mysql!
- Slave_IO_Running: Yes
- Slave_SQL_Running: Yes
- Now Replication is Finished!
- **********************************************************
本文转自vcdog 51CTO博客，原文链接：http://blog.51cto.com/255361/837912，如需转载请自行联系原作者
