mysql binlog gtid replay data not functional

asked 2019-07-03 05:47:12 -0500

hanruochen1 gravatar image

I used mysql binlog with origin, while gtid mode is disabled, i could change the offset to a earlier position by modifing the offset.json file, eg : from mysql_bin.000001:4567 to mysql_bin.000001:100. then I could replay data between the position 100 and 4567.

this is very good . But when I enable gtid mode . I was going to modifying the offset.json file by changing the gtid position . however this is not good. Could U give me a good sulotion ? because we really need the data replay function.

edit retag flag offensive close merge delete