GTID中slave端的binlog是必须开启的,目的是记录执行过的GTID
主库
#开启gtid
log-bin=mysql-bin
expire_logs_days = 5
binlog_format=mixed
server-id = 1
gtid_mode=on
enforce_gtid_consistency=true
log_slave_updates=on
#授权从库复制账号
grant replication slave on *.* to 'slave'@'%' identified by 'goodluck' ;
从库:
#开启gtid
log-bin=mysql-bin
expire_logs_days = 5
binlog_format=mixed
server-id = 2
gtid_mode=on
enforce_gtid_consistency=true
log_slave_updates=on
#从库配置连接主库
change master to master_host="主库IP",master_port=5506,MASTER_USER='slave',MASTER_PASSWORD='goodluck',MASTER_AUTO_POSITION=1;
flush privileges;
show slave status\G
#查看连接主库的配置
select * from mysql.slave_master_info;
参考:
https://blog.csdn.net/wjw465150/article/details/127043721
https://baijiahao.baidu.com/s?id=1724704235787909853&wfr=spider&for=pc
https://blog.csdn.net/wjw465150/article/details/127043721