Re: Looking for way to replicate master db to multiple mobile databases

Le jeudi 24 septembre 2009, Selena Deckelmann a écrit :
> Hi!
>
> On Wed, Sep 23, 2009 at 10:11 AM, Bryan Montgomery <monty(at)english(dot)net>
wrote:
> > Hi,
> > I'm looking for a way to replicate am master database to multiple (100+)
> > databases that are taken in to the field. Currently for each laptop we
> > dump and load the tables. However,there is only a small percentage of
> > data that changes on a frequent basis.
> >
> > I've been looking around and come across pyerplica, londiste and bucardo
> > - the documentation on most of these is fairly sparse. It seems that
> > Bucardo may be the best bet - at least initially.
>
> Bucardo is a good choice for this usage model because it was
> originally designed to work over a lossy network connections.

yes, but isn't bucardo designed to 2 nodes only ?

>
> You could issue 'kicks' for each laptop sync when you know for sure
> that a laptop has got an active network connection to your master.
> It's also pretty efficient with updates, only copying the current row
> (that's changed) a single time, rather than multiple times if there
> have been multiple changes to that row since the last time a sync
> occurred.
>
> -selena
>

--
----
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org