Active - active replication - connect_cdc_sqdata - 4.1

Connect CDC (SQData) Architecture

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
4.1
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Architecture
Topic type
Installation
How Do I
Copyright
2024
First publish date
2000
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T13:24:57.122078

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