Tuesday, January 10, 2012

MySQL Replication - slave status showing LastSQLError

If you would need to skip the SQL command from reflect into the slave server, do as following

STEPS:
1. mysql> stop slave;
2. mysql>SET GLOBAL sql_slave_skip_counter = 1;
3. mysql> start slave;

you should be able to see the slave process change into healthy state again.

No comments:

Post a Comment