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

Поиск
Список
Период
Сортировка
От Grant Maxwell
Тема Re: Looking for way to replicate master db to multiple mobile databases
Дата
Msg-id 17272525-012E-494F-80AD-0E3A12A99A64@maxan.com.au
обсуждение исходный текст
Ответ на Re: Looking for way to replicate master db to multiple mobile databases  (Selena Deckelmann <selenamarie@gmail.com>)
Список pgsql-general
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@dalibo.com> wrote:
>> Le jeudi 24 septembre 2009, Selena Deckelmann a écrit :
>>> 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.
>>
>> 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Selena Deckelmann
Дата:
Сообщение: Re: Looking for way to replicate master db to multiple mobile databases
Следующее
От: Lew
Дата:
Сообщение: Re: What is the difference of foreign key?