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

From: ethode <joshua(at)ethode(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Alternative to Multi-Master Replication with 2 Data centers??
Date: 2014-03-29 18:35:18
Message-ID: 1396118118945-5797886.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2014-03-29 19:50:48 Re: Alternative to Multi-Master Replication with 2 Data centers??
Previous Message Adrian Klaver 2014-03-29 17:17:26 Re: [ADMIN]openvz and shared memory trouble