We recently had an architectural situation/problem to sove and that was to find a way to replicate Databases belonging to different system components between themselves, and more, to replicate all this data to an ODS belonging to our system DWH.
So I have been involved lately with looking at how we can set up a replication between different database instances we have in our solution. A strong candidate, given our requirements was DB2 SQL Replication.
We found out that DB2 10.5 has strong capabilities in this regard. One could set up a two way replication between two different database instances installed on two physically separate machines, even with connection limitations in place - I.e. One instance can not connect to the other. Furthermore, the two way replication can even be configured on the same table, with filtering in place. This means that for instance, rows matching a certain filtering criteria can be replicated from the instance A to instance B, while rows matching a different criteria can be replicated from instance B to instance A, and all of this happens with the same database table.
The connection limitation can be overcome by configuring the replication agent - that means to have these agents run on the machines that can physically connect to the other machines belonging to the system in question.
The DB2 SQL Replication can work almost instantaneously, replicating the data within a second or two timeframe.
Niciun comentariu:
Trimiteți un comentariu