Active/Active replication is the process of keeping two or more live databases in-sync with each other and is used for high availability, load balancing and performance. The simplest example would be two databases, one maintained on System A and a second on System B. All changes made to the database on System A must also be applied to the database on System B, while at the same time, all changes made to the database on system B must be replicated to System A.
Historically Active/Active replication could only be accomplished by the primary database manager be it IMS, Db2 or Oracle using shared memory to manage concurrent updates. The fundamental issue with that approach is the latency introduced as the physical distance between the two replicated databases increased. With Connect CDC (SQData), an Active/Active replication architecture can be implemented that is unaffected by distance.
Two of the top 10 banks in North America have been using Connect CDC SQData to facilitate load balancing for more than 10 years.
Db2 Active - Active
IMS Active - Active
