Apparatus and method for coordinating logical data replication with highly available data replication

  • US 7,177,886 B2
  • Filed: 02/07/2003
  • Issued: 02/13/2007
  • Est. Priority Date: 02/07/2003
  • Status: Active Grant
First Claim
Patent Images

1. A database apparatus comprising:

  • a critical database server including a primary server supporting a primary database instance and a secondary server supporting a secondary database instance that mirrors the primary database instance, the secondary server generating an acknowledgment signal indicating that a selected critical database transaction at the primary database instance is mirrored at the secondary database instance, the critical databases server including a mirroring component communicating with the primary and secondary servers to transfer database log file entries of the primary database instance to the secondary server, the secondary server applying and logging the transferred database log file entries to the secondary database instance and producing said acknowledgement signal subsequent to the applying and logging of the selected critical database transaction, wherein the mirroring component includes a control structure that indexes critical database transactions that are applied and logged at the secondary database instance, the acknowledgement signal corresponding to indexing in the control structure of at least one of the selected critical database transaction and a critical database transaction that commits after the selected critical database transaction;

    a plurality of other servers each supporting corresponding database instances; and

    a data replicator communicating with the critical database server and the plurality of other servers to replicate the selected critical database transaction on at least one of said plurality of other servers responsive to the acknowledgment signal.

View all claims

    Thank you for your feedback