MySQL基于GTID复制

数据库版本5.7

GTID复制配置

1、创建复制用户：

CREATE USER 'repl'@'IP段' identified by '密码' 
2、给复制用户创建权限
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'IP段'
3、主从文件配置（/etc/my.cnf）
主：
1>、bin_log=/var/lib/mysql/binlog
2>、server_id = 100
ENFORCE_GTID_CONSISTENCY = ON
3>、gtid_mode = on
4>、enforce-gtid-cnsistency=on
5>、log-slave-updates = on 5.7之前使用

从：
1>、bin_log=/var/lib/mysql/binlog
2>、server_id = 100
ENFORCE_GTID_CONSISTENCY = ON
3>、gtid_mode = on
4>、enforce-gtid-consistency=on
5>、read_only = on
master_info_repository = TABLE

relay_log_info_repository = TABLE