MySQL 5.7 1236 fault handling based on Gtid master-Slave synchronization (other transaction failures equivalent)

Log in from library

Stop slave;

View execution transactions

Show Slave Status\g

Retrieved_gtid_set: ee3bdb44-f6a1-11e7-b194-005056a35fd4:21315405-51853406
executed_gtid_set:ee3bdb44-f6a1-11e7-b194-005056a35fd4:1-51853406

Note: Retrieved_gtid_set to get the transaction ID on the main library

Executed_gtid_set is the transaction ID that is being executed

Reset Master;

SET @ @GLOBAL. gtid_purged = ' ee3bdb44-f6a1-11e7-b194-005056a35fd4:51853406 '

Start slave;

Show slave status\g to see if sync is working

If there are many errors. It is recommended to re-make from the library.

MySQL 5.7 1236 fault handling based on Gtid master-Slave synchronization (other transaction failures equivalent)