Scalable relational database replication

A relational database replication system comprising:

• a primary database configured to receive a plurality of database write statements in parallel from a plurality of clients;
• a primary replication agent of the primary database adapted to execute on at least one primary processor in communication with the primary database;
• a secondary database;
• and
• a secondary replication agent of the secondary database adapted to execute on at least one secondary processor in communication with the primary replication agent and the secondary database,
• wherein the primary database, the primary replication agent, the secondary database and the secondary replication agent are configured to:
• receiving, by a primary replication agent of a primary database, a plurality of database write statements in parallel from a plurality of clients;
• receiving, by a secondary replication agent of a secondary database, the plurality of database write statements in parallel from the primary replication agent;
• storing the plurality of database write statements to a transaction log at the secondary replication agent;
• serially receiving, by the primary replication agent, a plurality of prepare to commit statements from the client;
• serially sending, by the primary replication agent, the plurality of prepare to commit statements in sequence to the secondary replication agent;
• sending, by the secondary replication agent, an acknowledgment of the plurality of prepare to commit statements to the primary replication agent;
• sending, by the primary replication agent, an acknowledgment of the plurality or prepare to commit statements to the client;
• receiving, by the primary database, a first commit message from the client;
• receiving, by the primary replication agent, a second commit message from the client upon determination that the first commit message has been successfully performed at the primary database;
• sending, by the primary replication agent, the second commit message to the secondary replication agent;
• sending, by the secondary replication agent, an acknowledgment to the primary replication agent;
• sending, by the primary replication agent, an acknowledgment to the client;
• and
• asynchronously performing, by the secondary replication agent, the plurality of database write statements on the secondary database.