Re: Clustering & Load Balancing & Replication - Mailing list pgsql-general

From Marc Evans
Subject Re: Clustering & Load Balancing & Replication
Date
Msg-id 20061226192858.P6730@me.softwarehackery.com
Whole thread Raw
In response to Re: Clustering & Load Balancing & Replication  (Ben <bench@silentmedia.com>)
List pgsql-general
On Tue, 26 Dec 2006, Ben wrote:

> On Dec 26, 2006, at 7:30 AM, Marc Evans wrote:
>
>> What I have not been able to come up with a good semi-general purpose
>> solution to is cross-data-center HA.
>
>
> Why does log shipping not work for you?

Well, it may, but is short, I believe that this comes down to how to deal
with various failure scenarios. For example, consider a situation where a
data center is cut off from communications with other data centers. Do all
data centers need to switch to a read-only operational mode, or is one of
the centers elected the master? What about a pair of islands, wherein 2
seperate sets of data centers are cut off from each other, but see some
subset of other data centers? For a general purpose solution, some form of
multi-master seems logical, but of course, doesn't yet exist.

- Marc

pgsql-general by date:

Previous
From: Iannsp
Date:
Subject: Re: NEED URGENT HELP....
Next
From: Mike Benoit
Date:
Subject: ORDER BY col is NULL in UNION causes error?