PARALLEL SCANNERS FOR LOG BASED REPLICATION

摘要

Log based replication using parallel scanners is described. An example method includes establishing replication paths from a primary database to a plurality of destination servers. A plurality of scanner threads are spawned to scan a transaction log of the primary database. Specifically, one scanner thread is assigned to each replication path corresponding to each destination server. For each scanner thread, data bound to a replication path associated with the scanner thread is selected from a subset of the transaction log. Accordingly, the data is distributed to a destination server associated with the replication path.

主权项

1. A computer-implemented method for data replication, comprising:
establishing replication paths from a primary database to a plurality of destination servers; spawning a plurality of scanner threads that scan a transaction log of the primary database, wherein one scanner thread is assigned to each replication path corresponding to each destination server; for a seamier thread, selecting data from a subset of the transaction log bound to a replication path associated with the scanner thread; and distributing the data to a destination server associated with the replication path.