/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
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
#######################################################################
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
#######################################################################
转载于:https://blog.51cto.com/liang3391/579824