在线快速切换为并发复制: mysql> STOP SLAVE SQL_THREAD; mysql> SET GLOBAL slave_parallel_workers = 8; #并发线程数量 mysql> SET GLOBAL slave_parallel_type = “ LOGICAL_CLOCK” ; #or DATABASE mysql> START SLAVE SQL_THREAD 注意:如果主5.6 从5.7使用LOGICAL_CLOCK的模式可能会出现如下类型错误 Last_Errno: 1756
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).