When you do a SHOW SLAVE STATUS\G and you see errors you need to resolve them. One way is to simply skip the offending statement.
SLAVE STOP;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
SLAVE START;
Repeat as desired.
SET GLOBAL SQL_SLAVE_SKIP_COUNTER documentation
No comments
Comments feed for this article
Trackback link: http://whircat.centosprime.com/mysql-slave-errors/trackback/