mysql主从同步监控自动提取主库的file号及pos

约定不等于承诺〃 2024-02-18 15:45 96阅读 0赞

mysql主从同步监控自动提取主库的file号及pos  
当发现同步出现无法同步的时候” 会自动提取主库的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 daa\#@897dkdlie$& -P 3307"  
sltool="/usr/local/mysql-3307/bin/mysql -h 192.168.1.107 -uroot daa\#@897dkdlie$& -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',master\_log\_pos=$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!  
  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*