Recover from MySQL Replication failure

If your slave stops working first do this:

show slave status;

This will give you the last error when it failed. If you can move past the error, and want to restart replication do this:

 

STOP SLAVE; 

SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;

START SLAVE;

SHOW SLAVE STATUS

Posted in MySQL

Leave a Reply