MySQL版本:5.7.17
问题
在SLAVE机器上查看同步状态:
mysql> show slave status\G
...
Last_Errno: 1396
Last_Error: Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 0 failed executing transaction '452e003c-e91c-12a7-6dc8-246e9213ce1a:285127' at master log bin-log.000016, end_log_pos 848424774. See error log and/or performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any.
...
Retrieved_Gtid_Set: 452e003c-e91c-12a7-6dc8-246e9213ce1a:1-491699
Executed_Gtid_Set: 32f9016a-e21b-11a7-bc49-246e1613b7d4:1-4,452e003c-e91c-12a7-6dc8-246e9213ce1a:1-285126
Auto_Position: 1
...
SLAVE有一个1396错误,从错误日志查看具体的错误信息,或者从这个表查看:
select * from performance_schema.replication_applier_status_by_worker;
确定这个错误是因为历史遗留原因创建用