Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On 25/09/2009, at 12:50 PM, Selena Deckelmann wrote:

On Thu, Sep 24, 2009 at 8:09 AM, Cédric Villemain
<cedric.villemain@xxxxxxxxxx> wrote:
Le jeudi 24 septembre 2009, Selena Deckelmann a écrit :
Hi!

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

No, definitely not!  You can replicate to any number of systems. And
you can group them in whatever groups you'd like.  Multi-master (as
Joshua said) only works between two nodes, but master->slave can be
from a master, to any number of slaves.


I use bucardo extensively across multiple sites and with complex replication requirements. It does a great job.
regards
Grant
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux