Active-Active Database Replication with Conflict Detection and Resolution
By Irem Radzik-Oracle on Apr 16, 2013
In our 24/7 digital world business processes heavily rely on online transaction processing systems, leaving IT organizations with a critical responsibility: avoiding system downtime while handling larger volumes of data and users. For mission-critical systems few of hours of downtime can have significant impact on the company revenue and employee productivity. In some cases, such as in healthcare or financial services, just few minutes of downtime can result in irreversible losses.
For systems that need near 100 percent of availability, Oracle GoldenGate's active-active database replication is a very strong solution to consider. Active-active replication enables multiple database instances to support the same application. These databases can be located in different regions without distance limitations and can be used for read and write operations. GoldenGate's bidirectional replication capabilities keeps these databases in synch with sub-seconds latency. If one database fails, the other ones can take over processing its transactions seamlessly. In addition to meeting very strict recovery time objectives and recovery point objectives, it enables significant performance and scalability benefits by distributing transactions across multiple databases.
Active-Active database replication eliminates downtime not only for unplanned interruptions such as disasters or site failures, but also planned outages such as migrations, upgrades, and systems maintenance. GoldenGate allows to have different hardware setups, operating systems, databases and database versions, service packs etc. In many migration and consolidation projects GoldenGate’s bidirectional real-time replication capabilities are used to perform Active-Active replication between old and new environments to eliminate downtime completely and minimize risks with phased migration.
One of the key issues that IT teams should consider when deploying an active-active replication solution is conflict management. When two or more systems are processing data transactions and the activity is shared across multiple databases, detecting and addressing conflicts across them becomes an essential requirement for any active-active replication configuration. Oracle GoldenGate 11g Release 2 provides a variety of conflict detection and resolution options to provide the necessary flexibility and adaptability for a range of requirements.
We presented Oracle GoldenGate 11gR2’s new conflict management feature in Maximizing Availability with Oracle GoldenGate webcast last December. In a new screencast we now provide more details and examples on how the new conflict detection and resolution feature works. I invite you to watch and learn about the flexible and automated conflict management options available in Oracle GoldenGate 11gR2.
You can find more information including a white paper on conflict management in Active-Active database replication in our
continuous availability resources.