网站建设资讯

NEWS

网站建设资讯

MySQL主从复制异常.md

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

创新互联自2013年创立以来,是专业互联网技术服务公司,拥有项目成都做网站、成都网站设计网站策划,项目实施与项目整合能力。我们以让每一个梦想脱颖而出为使命,1280元东辽做网站,已为上家服务,为东辽各地企业和个人服务,联系电话:18982081108

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;

网页标题:MySQL主从复制异常.md
链接地址:http://cdweb.net/article/joehse.html