Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- USER="fml"
- PASS="fuckthisjob"
- while true
- do
- mysql -u $USER -p$PASS -S /tmp/mysql.sock -B -N -e 'SHOW SLAVE STATUS\G' | grep 'Last_Errno' | grep -qc '1062'
- if [ $? -eq 0 ]
- then
- printf "USELESS-CLUSTER: SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1 -- "
- mysql -u $USER -p$PASS -S /tmp/mysql.refer-engine.sock -B -N -e 'SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; slave start;'
- printf "DONE\n"
- else
- printf "USELESS-CLUSTER: SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1 -- SLEEPING\n"
- sleep 1
- fi
- done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement