The Vitess 11.0 Documentationonly pass events for pks 1 to 10 T3: select * from t1 where pk > 10 limit 10 GTID: 112, Last PK 20 send rows to target Another gotcha!: Note that at T3 when we selected the pks from 11 to 20 the gtid from T3 we would still have an inconsistent state, if transactions 111 and 112 affected the rows from pks 1 to 10. This leads us to the following flow: T1: select * from t1 where pk > 0 limit 10. GTID: 100 only pass events for pks 1 to 10 T3: select * from t1 where pk > 10 limit 10 GTID: 112, Last PK 20 T4: replicate from 111 to 112 only pass events for pks 1 to 10 T5: Send rows for pks 11 to 20 to target0 码力 | 481 页 | 3.14 MB | 1 年前3- The Vitess 8.0 Documentationonly pass events for pks 1 to 10 T3: select * from t1 where pk > 10 limit 10 GTID: 112, Last PK 20 send rows to target Another gotcha!: Note that at T3 when we selected the pks from 11 to 20 the gtid from T3 we would still have an inconsistent state, if transactions 111 and 112 affected the rows from pks 1 to 10. This leads us to the following flow: T1: select * from t1 where pk > 0 limit 10. GTID: 100 only pass events for pks 1 to 10 T3: select * from t1 where pk > 10 limit 10 GTID: 112, Last PK 20 T4: replicate from 111 to 112 only pass events for pks 1 to 10 T5: Send rows for pks 11 to 20 to target0 码力 | 331 页 | 1.35 MB | 1 年前3
- The Vitess 12.0 Documentationonly pass events for pks 1 to 10 T3: select * from t1 where pk > 10 limit 10 GTID: 112, Last PK 20 send rows to target Another gotcha!: Note that at T3 when we selected the pks from 11 to 20 the gtid from T3 we would still have an inconsistent state, if transactions 111 and 112 affected the rows from pks 1 to 10. This leads us to the following flow: T1: select * from t1 where pk > 0 limit 10. GTID: 100 only pass events for pks 1 to 10 T3: select * from t1 where pk > 10 limit 10 GTID: 112, Last PK 20 T4: replicate from 111 to 112 only pass events for pks 1 to 10 T5: Send rows for pks 11 to 20 to target0 码力 | 534 页 | 3.32 MB | 1 年前3
- The Vitess 9.0 Documentationonly pass events for pks 1 to 10 T3: select * from t1 where pk > 10 limit 10 GTID: 112, Last PK 20 send rows to target Another gotcha!: Note that at T3 when we selected the pks from 11 to 20 the gtid from T3 we would still have an inconsistent state, if transactions 111 and 112 affected the rows from pks 1 to 10. This leads us to the following flow: T1: select * from t1 where pk > 0 limit 10. GTID: 100 only pass events for pks 1 to 10 T3: select * from t1 where pk > 10 limit 10 GTID: 112, Last PK 20 T4: replicate from 111 to 112 only pass events for pks 1 to 10 T5: Send rows for pks 11 to 20 to target0 码力 | 417 页 | 2.96 MB | 1 年前3
- The Vitess 10.0 Documentation
only pass events for pks 1 to 10 T3: select * from t1 where pk > 10 limit 10 GTID: 112, Last PK 20 send rows to target Another gotcha!: Note that at T3 when we selected the pks from 11 to 20 the gtid from T3 we would still have an inconsistent state, if transactions 111 and 112 affected the rows from pks 1 to 10. This leads us to the following flow: T1: select * from t1 where pk > 0 limit 10. GTID: 100 only pass events for pks 1 to 10 T3: select * from t1 where pk > 10 limit 10 GTID: 112, Last PK 20 T4: replicate from 111 to 112 only pass events for pks 1 to 10 T5: Send rows for pks 11 to 20 to target0 码力 | 455 页 | 3.07 MB | 1 年前3
共 5 条
- 1