-
There is a master group in Master definition site (MDS) A, it has a master site B which has this group too. Now i need to share this group with another master site C. Now is it necessary to have 3 way replication (bidirectional between AB,BC,AC) or can there we establish only 2 way (AC & AB eliminating BC).
Thanks
with regards
Prasanna S
-
Hi,
If the three sites are updateables sites, you need the three way replication.
Regards
Angel
-
Yes its all master sites. There is some network issues across the countries, network between BC is very poor, so i thought of eliminating this and achieving this by transactions between master definition site A and master site C (which implicitely mean all transactions happend in B comes to A and in turn to C ) will this work??
with regards
Prasanna S
-
Prasy,
Check this 3rd party tool called SHAREPLEX from Quest Software. That might be a solution to your request.
It provides:
Consolidation replication: where you can have multiple primary databases, each replicating to a single bigger secondary database.
Peer to peer replication: This is the conventional and simplest replication mode where writes from a single primary database are replicated to a secondary database.
Broadcast replication: Here a single primary database is replicated to multiple database.
Master to master replication: In this type of replication both databases are considered to be PRIMARY or SOURCE. Both can be directly accessed for reads and writes but conflit resolution need to be defined in the SHAREPLEX to achieve master to master replication.
For example if the same row is deleted in one database and updated in the other database which write should be considered ''Correct " & which should be rollback?
A separate product from Quest called I/WATCH can be used to detect conflict resolution in the shareplex and immediately alert the DBA
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|