在从库通过show slave status发现:
Slave_IO_Running: Yes
Slave_SQL_Running: No
Last_Errno: 1062
Last_Error: Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction 'ANONYMOUS' at master log binlog.000015, end_log_pos 759. See error log and/or performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any.
根据上面的提示去查看错误日志可以得知是表同步异常,这种情况大多数发生的原因是:
mysql容器还没有停止运行就直接对虚拟机进行关机操作.
解决方法:
方法1:对出现异常的表进行删除操作,并再次进行连接.
方法2:停止连接(stop slave;),重置设置(reset slave;),重启容器(docker restart ),查询主库状态(show master status;),再次连接(CHANGE MASTER TO MASTER_HOST='', MASTER_USER='', MASTER_PASSWORD='', MASTER_LOG_FILE='', MASTER_LOG_POS= ; )
注意:一定要先停止mysql容器运行后再关闭虚拟机.