Thread: Cascading Replication Multi Master

Cascading Replication Multi Master

From
Rahul Saha
Date:
Hello Experts,

I have a scenario where I need to replicate changes between 3 or more servers. Lets consider e small example:
There are 3 servers A,B,C. We need to replicate from each server to every other server.

1) A needs to get replicate with B
2) B needs to get replicate with A
3) B needs to get replicate with C

Do we have solution for kind of scenario ? I believe Bucurdo is a soluion but I am not sure, it will do cascading replication from A to B and B to C.

-- 

Thanks & Regards
Rahul Saha

+91 8806351116

Re: Cascading Replication Multi Master

From
Rosser Schwarz
Date:
On Tue, May 20, 2014 at 8:46 PM, Rahul Saha <rahul.blooming@gmail.com> wrote:
Do we have solution for kind of scenario ? I believe Bucurdo is a soluion but I am not sure, it will do cascading replication from A to B and B to C.

Yes, Bucardo will do what you describe.

The configuration is a little more complicated if you want changes on C to replicate back to B (and, naturally, A<->B, plus B->C is more involved than just A<->B), but I've had a similar setup (where B replicates to C, but not the reverse) in production before, several years ago now.

rls

--
:wq