cancel
Showing results for 
Search instead for 
Did you mean: 

Warm Standby Bidirectional replication

Former Member
0 Kudos

Hi Gurus

Is posible set a bidirectional warm standby replication between 2 databases, For example: a database DB1 in server Srv1 replicate to DB2 in Srvr2 and viceversa: DB2 in Srv2 also replicate to DB1 in Srv1

Or is better use a MSA type for this pourpose ?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member89972
Active Contributor
0 Kudos

AFAIK Warm Standby is one way only.

This is basically like a database level "cluster" where one database is primary source of data and other one is a copy/shadow of primary.

At any given point in time only one database can be "primary" and other will have to "standby".

Of course standby database can be used for readonly, reporting, dss type of requirements.

MSA is again for multiple copies of one database -- with typically one source (primary) and multiple copies of the data at various locations.

Bidirectional replication will be typically will be peer to peer replication.

MSA can be used but see the caveat next.

In case of bidirectional replication a "design with clear conflict resolution" will be very important consideration.

HTH

AVinash

0 Kudos

Ok, get it. Thanks a lot