mysql 检查是否同步_检查mysql同步是否完成再备份（死循环）

/usr/local/mysql/bin/mysql -S /tmp/$2.sock -e "stop slave IO_THREAD;"

while true

do

/usr/local/mysql/bin/mysql -S /tmp/$2.sock -e "show slave status\G" > /opt/slave_status.log

Master_Log_File=$(cat /opt/slave_status.log | grep -w 'Master_Log_File' | awk -F':' '{print $2}')

Relay_Master_Log_File=$(cat /opt/slave_status.log | grep -w 'Relay_Master_Log_File' | awk -F':' '{print $2}')

Read_Master_Log_Pos=$(cat /opt/slave_status.log | grep -w 'Read_Master_Log_Pos' | awk -F':' '{print $2}')

Exec_Master_Log_Pos=$(cat /opt/slave_status.log | grep -w 'Exec_Master_Log_Pos' | awk -F':' '{print $2}')

if [ "$Master_Log_File" = "$Relay_Master_Log_File" -a "$Read_Master_Log_Pos" = "$Exec_Master_Log_Pos" ];then

date >> $PBDIR/bakincr.log

echo "" >> $PBDIR/bakincr.log

/usr/local/mysql/bin/mysql -S /tmp/$2.sock -e "show slave status\G" >> $PBDIR/bakincr.log

break

else

date >> $PBDIR/bakincr.log

echo "" >> $PBDIR/bakincr.log

/usr/local/mysql/bin/mysql -S /tmp/$2.sock -e "show slave status\G" >> $PBDIR/bakincr.log

sleep 10

continue

fi

done

#######################################################################