SYSTEMS AND METHODS FOR REPLICATION REPLAY IN A RELATIONAL DATABASE

摘要

Systems and methods for replication replay in a relational database are disclosed. In one embodiment, a relational database includes a master database and a slave database, and events performed on the master database are stored in a log. A portion of the log is provided to a slave replay system associated with the slave database, and the slave replay system identifies a first table row associated with a first event of the portion of the log and a second table row associated with a second event in the portion of the log. The slave replay system replays the first and second events on the slave database in parallel if the first and second rows are different rows with unique sets of values, and otherwise replays the first and second events serially.

主权项

1. A method of replaying transactions in a slave database, the method comprising:
receiving a sequence of events executed on a master database, the sequence of events associated with one or more tables and at least one transaction of the master database; identifying a first row of the one or more tables associated with a first event in the sequence; identifying a second row of the one or more tables associated with a second event in the sequence, the second event after the first event; and replaying the first and second events on the slave database in parallel if the first and second rows are different rows with unique sets of values, and otherwise replaying the first and second events serially; wherein the method is performed by one or more computing devices.