[Bucardo-general] Dual Master Slaves

[Michelle Sullivan]

Sam Nelson wrote:
> I'm sure this must have been asked before, but I can't find it
> anywhere and we've been trying a multitude of possibilities, running
> into brick walls with each one.
>
> Basically, we are attempting to make a bucardo instance of two masters
> (swap sync), each with slaves dangling off of it.  We expected that
> the slaves dangling from the master that is NOT changed wouldn't have
> their sync operations triggered, but were hoping that bucardo_ctl kick
> syncname would force a sync event in spite of not having been triggered.
>
> So we were wondering, short of constantly setting onetimecopy=1 and
> forcing a re-sync, is there a way to run slaves that are capable of
> failing over to the other master off of the dual bucardo masters?  It
> doesn't even have to be bucardo slaves - Slony would work too.  Or hot
> standby, but I have a feeling hot standby would be opposed to failing
> over to another master.

I seem to be unable to parse what you're actually asking here...  That
said, it's simple to have 2 masters and multiple slaves hanging off
them.  Just ensure you have 'make_delta=1' (if I remember the option
correctly) on so that the changes from the "other" master is replicated
to the slave attached.You can either have "triggered" sync or timed sync
at that point.

Michelle


-- 
Michelle Sullivan
http://www.mhix.org/