MySQL 5.6的复制中断,发生下面错误
<前> 2018 - 10 - 18,12:20:02 15374,(错误),Slave I/O:, Found a Gtid_log_event 或是Previous_gtids_log_event when @@GLOBAL.GTID_MODE =,又是,Error_code: 1784 2018 - 10 - 18,12:20:02 15374,(错误),Slave I/O:, Relay log write 失败:,could not queue event 得到主人,Error_code:, 1595 2018 - 10 - 18,12:20:02 15374,[注],Slave I/O thread 退出,,read up 用log & # 39; mysql-bin.000012& # 39;,, position 123年, 2018 - 10 - 18,13:57:41 15374,[注],Error reading relay log 事件:,slave SQL thread was 死亡 2018 - 10 - 18,13:57:44 15374,[警告],Storing MySQL user name 或是password 方式、拷贝,master info repository is not secure 以及is therefore not 推荐只Please consider using 从而user 以及password connection options for START 奴隶;,阅读,& # 39;START SLAVE 语法# 39;,拷贝,MySQL Manual for more 信息。 2018 - 10 - 18,13:57:44 15374,[警告],Slave SQL:, If a crash happens 却;能够configuration does not guarantee that 从而relay log info will be 一致,,Error_code: 0 2018 - 10 - 18,13:57:44 15374,[注],Slave SQL thread 初始化,,starting replication 拷贝log & # 39; mysql-bin.000012& # 39;, at position 123年,relay log & # 39;。/mysqld3319-relay-bin.000004& # 39;,位置:,286, 2018 - 10 - 18,13:57:44 15374,[注],Slave I/O 线程:,connected 用master & # 39; backuper@10.156.15.1:3306& # 39;, replication started 拷贝log & # 39; mysql-bin.000012& # 39;, at position 123年, 2018 - 10 - 18,13:57:45 15374,(错误),Slave I/O:, Found a Gtid_log_event 或是Previous_gtids_log_event when @@GLOBAL.GTID_MODE =,又是,Error_code: 1784 2018 - 10 - 18,13:57:45 15374,(错误),Slave I/O:, Relay log write 失败:,could not queue event 得到主人,Error_code:, 1595 >之前
报错原因:
从MySQL 5.7向较低版本的MySQL 5.6搭建复制时,会触发这个错误。
解决方法:
使用高版本的MySQL 5.6或5.7创建复制主机。
<前> (root@db-backup-all ~) #,/opt/mysql_56_40/bin/mysqld - v/opt/mysql_56_40/bin/mysqld , Ver 5.6.40 for linux-glibc2.12 提醒x86_64 (MySQL Community  Server (GPL)) >之前