MySQL8.x主从复制

1.主从复制

创建用户

create user 'master'@'%' identified with mysql_native_password by '123456@cP';

授权

grant replication slave on *.* to 'master'@'%';

连接

change master to
master_host='127.0.0.1',
master_port=3306,
master_user='master',
master_password='123456@cP',
master_log_file='master-bin.000005',
master_log_pos=1049;

启动后查询报错：Slave_IO_Running: NO

找到从库my.cnf配置错误日志，查询原因。

错误：the master has GTID_MODE = OFF and this server has GTID_MODE = ON. Error_code: MY-013117

主库为OFF 从库ON，两者必须相同才行。这里将主库设置为ON.

解决：

 set global gtid_mode=OFF_PERMISSIVE;
 set global gtid_mode=ON_PERMISSIVE;
 set global enforce_gtid_consistency=on;
 set global gtid_mode=ON;