MySQL master-slave replication via Gtid mode

1, create the replication user, with replication slave permissions, can ensure that slave master data synchronization past master: #grant replication Slave on * * to ' rep ' @ ' 192.168.10.100 ' identified by ' 123456 '; 2, open Gtid need to enable these three parameters #GTIDgtid_mode = onenforce-gtid-consistency = 1log_slave_updates = 13, slave configuration synchronization #change master to master_host= ' 192.168.10.99 ', Master_user= ' rep ', master_password= ' 123456 ', master_port=3306,master_auto_position=1;

MySQL master-slave replication via Gtid mode