欢迎光临
我们一直在努力

MySQL主从复制异常.md

一、MySQL 5.6 >> MySQL 5.7
错误信息:

Last_Error:
 ... The slave coordinator and worker threads are stopped, possibly leaving data in inconsistent state. A restart should restore consistency automatically, although using non-transactional storage for data or info tables or DDL queries could lead to problems. In such cases you have to examine your data (see documentation for details).

解决方法:
关闭并行复制

STOP SLAVE;
SET GLOBAL slave_parallel_workers=0;
START SLAVE;
赞(0)
【声明】:本博客不参与任何交易,也非中介,仅记录个人感兴趣的主机测评结果和优惠活动,内容均不作直接、间接、法定、约定的保证。访问本博客请务必遵守有关互联网的相关法律、规定与规则。一旦您访问本博客,即表示您已经知晓并接受了此声明通告。