DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: replication

  1. #1
    Join Date
    Feb 2001
    Posts
    83
    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

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Hi,

    If the three sites are updateables sites, you need the three way replication.

    Regards

    Angel

  3. #3
    Join Date
    Feb 2001
    Posts
    83
    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

  4. #4
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374
    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
  •  


Click Here to Expand Forum to Full Width