GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Goldengate peer to peer replication configure, pls advise urgently?

edited Jun 5, 2015 5:09PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered

I need to replicate the data in three sites like peer to peer  as triangle (bi-directional mode), should I configure as below?

SITE  A  -> 1 Extract,  2 PUMP (i.e Site B, SITE C), 2 replicat ( i.e SITE B , SITE C)

SITE  B  -> 1 Extract,  2 PUMP (i.e Site A, SITE C), 2 replicat ( i.e SITE A , SITE C)

SITE  C  -> 1 Extract,  2 PUMP (i.e Site A, SITE , 2 replicat ( i.e SITE A,  SITE

Will data loops happen in above config ? For example: if data insert in site A, it replicate to SITE B &C, Again SITE B replicate to C or vice versa? Is there any goldengate command should I use avoid the loop ? is there any article available on peer to peer configuration?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center