先决条件
master端执行
flush logs;
show master status;
获取file和position
slave端执行
stop slave;
change master to master_auto_position=0,master_log_file='mysql-bin.000012',master_log_pos=194; #file和position为master获取的值
start slave;
主从gtid设为off
set @@global.gtid_mode=on_permissive;
set @@global.gtid_mode=off_permissive;
select @@global.gtid_owned; #结果为空
set @@global.gtid_mode=off;