show processlist;
 start master


show master status \g;
show slave status \g;

Looking at output from above commands, you'd know

  • if slave is lagging behind master.
  • replication is failing because of some issues replicating a sql on slave.


STOP SLAVE;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; /*This is to skip the duplicate record*/
START SLAVE;

http://www.redips.net/mysql/replication-slave-relay-log-corrupted/

http://dba.stackexchange.com/questions/53893/mysql-relay-log-corrupted-how-do-i-fix-it-tried-but-failed

https://www.percona.com/blog/2014/10/08/mysql-replication-got-fatal-error-1236-causes-and-cures/