Patent ID: 8306947
Filing Date: 2012-11-06
Classification: G06F

Abstract:
1. A method, comprising: executing a single database transaction across multiple nodes with each node having a transaction manager; synchronizing the transaction across the multiple nodes so a replication operation occurs in a correct order; performing the replication operation according to the transaction from a primary database to a backup database so changes to a table in the primary database occur in the backup database without manual intervention; and one or more of: avoiding inactivating user applications that modify the primary database before initiating a Structured Query Language (SQL) operation, a Data Definition Language (DDL) operation, and a utility operation; leaving the primary database online while SQL operations, DDL operations, and utility operations are being executed; ensuring that data modifications located in an audit trail of the primary database prior to SQL operation, a DDL operation, and a utility operation on a node in the primary database are applied and durable before a SQL operation, DDL operation, or utility operation is initiated on a node in the backup database; automatically triggering a SQL operation, a DDL operation, and a utility operation on the backup database without user intervention; replicating user transactions that perform Data Manipulation Language operations, SQL operations, and DDL operations within a same transaction.