今天MySQL的主从环境中,备库遇到了这么一个问题:

其实,类似上边的这种报错报错还有这个样子的:

对于它们,解决方法都是差不多的:
1. stop slave
2. show variables like ‘sql_slave_%’;
3. set GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
4. show variables like ‘sql_slave_%’;
5. start slave
6. show slave status\G

————————————
Done。

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

隐藏
变装