#!/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.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