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