METHOD AND APPARATUS FOR SEQUENCING TRANSACTIONS GLOBALLY IN A DISTRIBUTED DATABASE CLUSTER WITH COLLISION MONITORING

摘要

A system and method for duplicating a plurality of transactions for a primary database received from at least one application over a network as a plurality of replicated transactions for a secondary database. The system comprises a status module for monitoring a completion status of each of the plurality of transactions received by the primary database, such that the completion status indicates a respective transaction of the plurality of transactions has been successfully processed by the primary database. The system comprises a global queue for storing each of the plurality of transactions for facilitating the transaction duplication in a selected transaction sequence order, wherein the global queue is configured for storing the plurality of transactions and the respective completion status of each of the plurality of transactions including a respective transaction identification. The respective transaction identification represents a unique sequence identification for each stored transaction of the plurality of transactions. The system comprises a controller module coupled to the global queue and configured for assigning the respective transaction identification to each of the plurality of transactions and further configured for duplicating as the plurality of replicated transactions all of the transactions with a successful completion status of the plurality of transactions for storage in a replication queue for facilitating transmission of the plurality of replicated transactions to the secondary database for processing.