In the earlier post on GoldenGate Conflict Detection and Resolution, we had looked at an example where a conflict caused by an update happening at the same time for the same record from two different sites was handled using the RESOLVECONFLICT with the UPDATEROWEXISTS clause. Let us look at some more CDR examples involving DELETE […]
In the earlier post we looked at setting up a simple Active-Active GoldenGate configuration. Let us build on that by adding in some Conflict Detection and Resolution (CDR) mechanisms and look at some scenarios where conflicts do occur when a particular record in the table involved in active-active replication is being updated at the same […]
Let us look at a simple example to illustrate GoldenGate’s Active-Active Replication with an introduction to Conflict Detection and Resolution. Let’s call the two sites we are going to use for Active-Active replication as Site A and Site B. On Site A we will have the following groups created • Extract – ext1 • Data […]
