Re: Fully-automatic streaming replication failover when master dies?

From: Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Dmitry Koterov <dmitry(dot)koterov(at)gmail(dot)com>, Susan Cassidy <susan(dot)cassidy(at)decisionsciencescorp(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Fully-automatic streaming replication failover when master dies?
Date: 2014-01-27 03:35:11
Message-ID: CADp-Sm6Y1E8TgMsiEkcBg=S0oV6Cz6Nnv+TXX2DOdaWQMBvsKA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jan 27, 2014 at 11:24 AM, Michael Paquier <michael(dot)paquier(at)gmail(dot)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

[image: email patch]

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tatsuo Ishii 2014-01-27 03:47:19 Re: Fully-automatic streaming replication failover when master dies?
Previous Message Michael Paquier 2014-01-27 03:24:54 Re: Fully-automatic streaming replication failover when master dies?