mysql 5.6 的主从复制利用gtid 作为数据同步点而避开了用文件
change master to master_host='db_url',master_user='root',master_password='root',master_auto_position=1;
show global variables like 'gtid_purged';
然后拿着这个value,去从库上依次stop slave;
set global gtid_purged = 'xxx'; # xxx是你主库上查到的value。
start slave;
进过测试RDS需要先查询
set global gtid_purged ='077e9f57-b83f-11e6-844c-7cd30abff676:1-10479976,fa4f2610-b83e-11e6-844c-7cd30abff66a:1-5683819';
要是出现: ERROR 1840 (HY000): @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty. 则需要执行: reset master;