mysql--GTID主从复制

配置文件

master

添加

skip-slave-start
gtid_mode=ON
enforce_gtid_consistency=ON
server-id=1
log-bin=mysql-bin

slave

添加

gtid_mode=ON
enforce_gtid_consistency=ON
server-id=**
log-bin=mysql-bin

重启mysql

service mysqld restart

从库

change master to master_host="192.168.3.25",master_user="root",master_password="123456",master_auto_position=1;

start slave


show  slave  status\G;