1 在Master上
查询gtid后，记录gtid_executed 返回的值
mysql> show global variables like '%gtid%'\G *************************** 3. row *************************** Variable_name: gtid_executed Value: 48e17459-1d9e-11e7-9953-525400d06776:1-26959237
2 在Slave 上
mysql> stop slave; mysql> reset slave; mysql> reset master; mysql> set global gtid_purged='48e17459-1d9e-11e7-9953-525400d06776:1-26959237' ### 在master上查询gtid的值 mysql> change master to master_host='172.28.2.71', master_port=3306,master_user='slave',master_password='slave',master_auto_position=1; mysql> start slave; mysql> show slave status\G
