share一個自動跳mysql從庫上1062錯誤的腳本
從庫突然掉電可能會導致log裡的信息沒flush到硬盤，於是從庫啟動之後主從會因為1062(主鍵重復）而卡住，這裡提供一個自動跳1062的腳本
www.aiwalls.com
[plain]
#!/bin/sh
MYSQL=mysql
lastPos=0
while [ 1 ]; do
$MYSQL -uroot -e "show slave status\G" > /tmp/.skip
lastError=`cat /tmp/.skip|grep "Last_SQL_Errno"|awk '{print $2}'`
nowPos=`cat /tmp/.skip|grep "Exec_Master_Log_Pos"|awk '{print $2}'`
if [ $lastError -eq 1062 ]; then
if [ $lastPos -ne $nowPos ]; then
echo "blocked, skip one"
$MYSQL -uroot -e "slave stop; set global sql_slave_skip_counter =1; slave start;"
lastPos=$nowPos
else
echo "sleep one second"
sleep 1
fi
elif [ $lastError -eq 0 ]; then
secondsBehind=`cat /tmp/.skip|grep "Seconds_Behind_Master"|awk '{print $2}'`
if [ $secondsBehind -eq 0 ]; then
echo "done"
break
else
echo "$secondsBehind seconds behind server"
sleep 3
fi
else
echo "error $lastError found"
break
fi
done