skip-slave.sh

#!/bin/bash


function skip {
MYSQL_CONN="-uUSER -pPASS";

mysql ${MYSQL_CONN} -e "show slave status \G" | \
grep Seconds_Behind_Master | \
grep NULL && mysql ${MYSQL_CONN} -e "STOP SLAVE; \
                                     SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; \
                                     START SLAVE;"
}


for x in $(seq 1 10); do
 skip
 sleep 5s
done