Re: Slony-I for circular replication

On Thu, 30 Mar 2006 09:22:38 -0500
Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> wrote:
> On Thursday 30 March 2006 08:34, Bojidar Mihajlov wrote:
> > Can Slony-I be used for circular replication (A
> > <replicates> B <replicates> A)
> > or there is some kind of problem with locking or
> > anything else?
>
> Sounds like you want some kind of synchronous federated multi-master
> repication... which Slony-I wont do and I don't know of any system that will.
> You might be able to get some of that functionality using views and multiple
> replication sets, but that conversation really ought to take place on a more
> appropriate list, like the Slony list for example.

I had to do multi-master replication for a major project and we wound
up writing our own replication system. The problem is that this sort of
thing really has to be based on your own business rules. There is no
way to make it generic. At least, that was the conclusion we came to.

--
D'Arcy J.M. Cain <darcy(at)druid(dot)net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.