1，主数据库配置

[mysqld]
port=3306
datadir=/3306/data
socket=/3306/mysql.sock
log-error=/3306/log/db.log
log-bin=/3306/mysql-bin
server-id=1
gtid-mode=ON
enforce-gtid-consistency=ON
[mysqld_safe]
log-error=/3306/log/db.log
pid-file=/3306/run/db.pid

--新建用户就可以：
grant replication slave on *.* to 'rep'@'192.168.3.%' identified by '123';
flush privileges;

2，备数据库

slave:

[mysqld]
port=3333
datadir=/3333/data
socket=/3333/mysql.sock
server-id=100
gtid-mode=ON
enforce-gtid-consistency=ON
log-bin=/3333/mysql-bin
[mysqld_safe]
log-error=/3333/log/db.log
pid-file=/3333/run/db.pid

--指定复制信息
change master to master_host='192.168.3.201', master_user='rep',master_password='123',master_port=3306,master_auto_position=1;
start slave;
show slave status\G;

3，在线关闭

在线关闭：

#GTID
gtid_mode = on
enforce_gtid_consistency = 1
log_slave_updates   = 1


备库执行:
stop slave;
change master to master_host='192.168.3.201', master_user='rep',master_password='123',master_port=3306,master_auto_position=0;
start slave;

4，执行关闭命令

#GTID
gtid_mode = on
enforce_gtid_consistency = 1
log_slave_updates   = 1


备库执行:
stop slave;
change master to master_host='192.168.3.201', master_user='rep',master_password='123',master_port=3306,master_auto_position=0;
start slave;


主备依次设置GTID_MODE为ON_PERMISSIVE、OFF_PERMISSIVE
set @@global.gtid_mode=ON_PERMISSIVE;
set @@global.gtid_mode=OFF_PERMISSIVE;
主备库关闭GTID
SET @@GLOBAL.GTID_MODE = OFF;

#修改my.cnf配置文件(关闭GTID参数)
#gtid_mode = on
#enforce_gtid_consistency = 1
#log_slave_updates   = 1