mysql主从结构 file position 更改为gtid

主从结构 position -> gtid模式同步  

master 操作:

开启gtid

set global enforce_gtid_consistency=on;

set global gtid_mode=off_permissive;

set global gtid_mode=on_permissive;

set global gtid_mode=on;

slave 操作:

开启gtid

set global enforce_gtid_consistency=on;

set global gtid_mode=off_permissive;

set global gtid_mode=on_permissive;

set global gtid_mode=on;

停止slave

stop slave;

chang master master_auto_position=1;

start slave;