Multi-replica asynchronous table replication

A server comprising a processing unit and memory, wherein the server is adapted to operate a follower replica node of a database system, the follower replica node being in communication with a coordinator replica node, wherein the memory comprises computer executable instructions that, when executed on the processing unit, cause the server to perform operations for facilitating asynchronous replication within a database environment using data manipulation language (DML) statements, the operations comprising:

• asynchronously receiving a first DML statement for a first transaction originating at a source node, wherein the source node commits the first transaction without waiting for the first DML statement to be replayed by the coordinator replica node or the following replica node, the first DML statement being designated for replication at the coordinator replica node and the follower replica node;
• asynchronously receiving a second DML statement for a second transaction originating at the source node, wherein the source node commits the second transaction without waiting for the second DML statement to be replayed by the coordinator replica node or the follower replica node;
• executing the first DML statement;
• precommitting the first transaction at the follower replica node;
• sending a precommit notification for the first transaction to the coordinator replica node;
• without waiting for the commit of the first transaction, executing the second DML statement;
• receiving a postcommit notification for the first transaction from the coordinator replica node;
• and
• committing the first transaction at the follower replica node after the follower replica node has received the postcommit notification for the first transaction from the coordinator replica node.

One or more non-transitory tangible computer-readable storage media storing computer-executable instructions for causing a server programmed thereby to perform a method for facilitating asynchronous replication within a database environment using data manipulation language (DML) statements and implementing a replication manager of a database system, the replication manager being in communication with first and second replica nodes, the method comprising:

• designating the first replica node as a transaction coordinator node for a first transaction comprising a first DML statement, wherein the second replica node is a follower node for the first transaction;
• asynchronously sending the first DML statement for the first transaction from a source node to the first replica node and the second replica node, wherein the source node may commit the first transaction without waiting for the first DML statement to be executed at the first and second replica nodes;
• designating the second replica node as a transaction coordinator node for a second transaction comprising a second DML statement, wherein the first replica node is a follower node for the second transaction;
• asynchronously sending the second DML statement for the second transaction from the source node to the first replica node and the second replica node, wherein the source node may commit the second transaction without waiting for the second DML statement to be executed at the first and second replica nodes;
• routing a precommit notification for the first transaction from the second replica node to the first replica node, the precommit notification for the first transaction indicating that the first transaction has been precommitted by the second replica node;
• routing a postcommit notification for the first transaction from the first replica node to the second replica node;
• routing a precommit notification for the second transaction from the first replica node to the second replica node, the precommit notification for the second transaction indicating that the second transaction has been precommitted by the first replica node;
• and
• routing a postcommit notification for the second transaction from the second replica node to the first replica node.