Question Re: Warm Standby Bidirectional replication in Technology Q&A

Warm Standby Bidirectional replication

Former Member — Tue, 23 Jan 2018 18:20:22 GMT

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 ?

Re: Warm Standby Bidirectional replication

former_member89972 — Tue, 23 Jan 2018 19:50:46 GMT

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

Re: Warm Standby Bidirectional replication

former_member567823 — Wed, 24 Jan 2018 16:47:55 GMT

Ok, get it. Thanks a lot