Re: Database Synchronization

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Database Synchronization
Дата
Msg-id 469E3515.4070006@archonet.com
обсуждение исходный текст
Ответ на Re: Database Synchronization  (Chris Browne <cbbrowne@acm.org>)
Ответы Re: Database Synchronization  ("Jyoti Seth" <jyotiseth2001@gmail.com>)
Список pgsql-sql
Chris Browne wrote:
> dev@archonet.com (Richard Huxton) writes:
>>
>> http://www.slony.info/

> But it is worth noting one thing about the synchronization...
> 
> Slony-I's strategy is pretty simple: One node is considered the
> "master," and the other node is forcibly made to conform to what is on
> the master.
> 
> If you want to synchronize back and forth (e.g. - multimaster
> replication of some sort), Slony-I is not suitable...

Except in the case when you can have separate tables for the data. If 
you have a london_sales table only updated in London and a paris_sales 
table only updated in Paris then you have something inching towards 
multi-master.

--   Richard Huxton  Archonet Ltd


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

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: Database Synchronization
Следующее
От: PostgreSQL Admin
Дата:
Сообщение: pgmemcache