#!/bin/bash

while sleep 5s; do
    echo -n $(date);
    mysql -Be 'show slave status\G'|perl -ne 'm/(Seconds|Slave)_.+?\: (.+)\n/ && print " ".$2;';
    echo;
    if ! mysql -Be 'show slave status\G'|awk '/Slave_SQL_Running/{print $2}'|grep -q Yes; then
	echo "Advancing mysql by 1";
	mysql -Be "SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; start slave;";
	sleep 2s;
    fi;
done;