Add your thoughts here… (optional)
Using Oracle GoldenGate (OGG) 11gR2 for Conflict Detection and Resolution (CDR) based on balance and timestamp in a bidirectional active-active configuration
In the article you will have a look at an example for CDR implementation based on a balance and timestamp column in a bidirectional active-active OGG setup. I will build an active-active bidirectional OGG replication between two sites (RACD, RACDB) each having identical tables (test5.account, test5.seat_assignment). I will emphasize on the requirements for CDR implementation and will outline CDR concepts and illustrate a step-by step CDR implementation, testing and troubleshooting. I will cover two cases
- Use delta method for account balance CDR – An initial balance of 1000 will be simultaneously credited 200 on site B and debited 100 on site A. The result will be 1100 on both site A and site B.
- Use USEMIN timestamp method for seat booking CDR – a seat ‘2A’ will be booked…
Ver o post original 6.736 mais palavras