[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: Any success story using syncRepl with postgresql backend?



Hi P,

Thanks for the info. I will pass this onto my company decision makers
and see whether we like to "renew" the interest.

Thanks,
\Tommy


On Sat, 2008-05-10 at 14:27 +0200, Pierangelo Masarati wrote:
> Tommy Ho wrote:
> > I was wondering if anyone had success with using multi-master
> > replication (syncrepl with mirrormode enabled) using postgresql as the
> > backend?
> > 
> > I had this working using BDB but when I switched over to use postgres as
> > the backend, the synchronization becomes very erratic and inconsistent,
> > deleted data from one master never gets propagated and newly added data
> > will sometimes get sync'd and sometimes it doesn't.
> 
> As far as I remember, sync replication support for back-sql was very 
> experimental, and it broke at some stage of syncrepl development.  So 
> the fact you see an erratic behavior is as much as you could expect. 
> I'd rather expect that no replication occurs at all.  Patches are 
> welcome, as usual, but I don't believe right now there's much interest 
> in having that feature work as intended.  It was pursued at some point 
> relying on some customer's request which was never formalized; as such, 
> interest in that very specialized development reduced, and no one seems 
> to be willing to restore it.  A renewed interest might boost its 
> development, though.
> 
> p.
> 
> 
> 
> Ing. Pierangelo Masarati
> OpenLDAP Core Team
> 
> SysNet s.r.l.
> via Dossi, 8 - 27100 Pavia - ITALIA
> http://www.sys-net.it
> ---------------------------------------
> Office:  +39 02 23998309
> Mobile:  +39 333 4963172
> Email:   pierangelo.masarati@sys-net.it
> ---------------------------------------
> 
>