Alternative to Multi-Master Replication with 2 Data centers??

Поиск
Список
Период
Сортировка
От ethode
Тема Alternative to Multi-Master Replication with 2 Data centers??
Дата
Msg-id 1396118118945-5797886.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Alternative to Multi-Master Replication with 2 Data centers??  (John R Pierce <pierce@hogranch.com>)
Re: Alternative to Multi-Master Replication with 2 Data centers??  (Paul Jungwirth <pj@illuminatedcomputing.com>)
Список pgsql-general
We are load balancing 2 data centers.

Our current approach was using a software layer in our CMS to send data
between data centers, but write/update frequency made this approach
difficult and bug laden.

Currently we're considering several options, of which Multi-master
replication appears to be the top option.

BOTH data centers need to be writable, otherwise we could use Master/Slave.
If DC1 goes down our LB is failing over to DC2.  The failure causing
failover could be DB related OR be web server related.

It doesn't appear to be realistic to keep both DC's updated on inserts
and/or updates without using Multi-master or some other 3rd party software
that appear to do the same thing as Multi-master.

Any other solutions I should be considering



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Alternative-to-Multi-Master-Replication-with-2-Data-centers-tp5797886.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [ADMIN]openvz and shared memory trouble
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Alternative to Multi-Master Replication with 2 Data centers??