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

Hi!

On Wed, Sep 23, 2009 at 10:11 AM, Bryan Montgomery <monty@english.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.

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

--
http://chesnok.com/daily - me
http://endpoint.com - work