This post continues Pseudo GTID, in a series of posts describing an alternative to using MySQL GTIDs.
The solution offered in the last post does not work too well for row based replication. The binary log entries for the INSERT statement look like this:
# at 1020 # at 1074 #141020 12:36:21 server id 1 end_log_pos 1074 Table_map: `test`.`pseudo_gtid` mapped to number 33 #141020 12:36:21 server id 1 end_log_pos 1196 Update_rows: table id 33 flags: STMT_END_F BINLOG ' lddEVBMBAAAANgAAADIEAAAAACEAAAAAAAEABHRlc3QAC3BzZXVkb19ndGlkAAMDBw8CQAAE lddEVBgBAAAAegAAAKwEAAAAACEAAAAAAAEAA///+AEAAACL10RUJDg2ZmRhMDk1LTU4M2MtMTFl NC05NzYyLTNjOTcwZWEzMWVhOPgBAAAAlddEVCQ4Y2YzOWMyYy01ODNjLTExZTQtOTc2Mi0zYzk3 MGVhMzFlYTg= '/*!*/;
Where's our unique value? Encoded within[Read more...]