ACTIVE REPLICATION WITH GENERIC CONFLICT DETECTION AND RESOLUTION (CDR)

摘要

In various embodiments, an active-active replication solution is provided with one generic PL/SQL stored procedure (e.g., a PL/SQL stored procedure) configured to handle all application tables' conflict detection and resolution. In various aspects, the generic stored procedure simplifies initial setup, maintenance and management of complex mission critical active-active replication projects.

主权项

1. A method of bi-directional replication of active databases, the method comprising:
receiving, at one or more computer systems, information indicative of a conflict in one or more of a plurality of tables associated with a first database; for each of the one or more tables, generating, with one or more processors associated with the one or more computer systems, information mapping which conflicts are to be inserted into a generic logging table; generating, with the one or more processors associated with the one or more computer systems, one or more generic logging tables; and initiating, with the one or more processors associated with the one or more computer systems, a stored procedure for each table that utilizes the generic logging tables to resolve conflicts.