MySQL主從複製異常.md

標籤：data   restart   should   shel   mysql   cas   inf   解決   RKE   

一、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;

MySQL主從複製異常.md