×

Transactional and parallel log replay for asynchronous table replication

  • US 9,959,178 B2
  • Filed: 03/13/2015
  • Issued: 05/01/2018
  • Est. Priority Date: 11/25/2014
  • Status: Active Grant
First Claim
Patent Images

1. A computer implemented method for replicating a database transaction to a replica table, comprising:

  • receiving, by at least one processor, a replication log entry and an associated transaction commit log entry, the replication log entry and the associated transaction commit log entry together representing a database transaction to be replayed to a row at a replica table, the row at the replica table having a row-ID value and the replication log entry having a row-ID value that identifies a data state of the row at the replica table;

    dispatching, by the at least one processor, the replication log entry to a parallel log replayer and the associated transaction commit log entry to a transaction commit log replayer;

    comparing, by the at least one processor, the row-ID value of the replication log entry to the row-ID value of the row at the replica table;

    replaying, by the at least one processor, the replication log entry at the parallel log replayer based on the comparison; and

    committing, by the at least one processor, the database transaction to the replica table by replaying the associated transaction commit log entry at the transaction log replayer;

    wherein at least one of the receiving, dispatching, comparing, replaying, and committing are performed by one or more computers.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×