Re: Fully-automatic streaming replication failover when master dies? - Mailing list pgsql-general

From Sameer Kumar
Subject Re: Fully-automatic streaming replication failover when master dies?
Date
Msg-id CADp-Sm6Y1E8TgMsiEkcBg=S0oV6Cz6Nnv+TXX2DOdaWQMBvsKA@mail.gmail.com
Whole thread Raw
In response to Re: Fully-automatic streaming replication failover when master dies?  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Fully-automatic streaming replication failover when master dies?  (Tatsuo Ishii <ishii@postgresql.org>)
Re: Fully-automatic streaming replication failover when master dies?  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general

On Mon, Jan 27, 2014 at 11:24 AM, Michael Paquier <michael.paquier@gmail.com> wrote:
PostgreSQL supports synchronous multi-master, MongoDB supports write concern, but this causes a performance penalty). 
Anyways I doubt that "PostgreSQL supports synchronous multi-master"
Postgres core taken as such does not support multi-master. The fork of PostgreSQL called Postgres-XC somewhat does, for OLTP applications.

I know about PostgresXC, but I thought it is distributed database (similar to shards of mongoDB). [Though if I am correct there could be tables which are shared across different nodes, but that is not the best way of utilizing features of PostgresXC] I think it is not apt to call it "synchronous" (since there is no replication happening).


Best Regards,
Sameer Kumar | Database Consultant
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M : +65 8110 0350 T: +65 6438 3504 | www.ashnik.com
www.facebook.com/ashnikbiz | www.twitter.com/ashnikbiz

email patch

This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).

Attachment

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Fully-automatic streaming replication failover when master dies?
Next
From: Tatsuo Ishii
Date:
Subject: Re: Fully-automatic streaming replication failover when master dies?