Re: Multi Master Replication

From: Wolfgang Keller <feliphil(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Multi Master Replication
Date: 2013-12-19 14:52:01
Message-ID: 20131219155201.bb38120fa2a62d1cc0515944@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 2. With sync replication, you have coordination problems and
> therefore it is never (at least IME) a win compared to master-slave
> replication since all writes must occur in the same order in the set,
> or you need global sequences, or such.

*snip*

> You will never get better read or write throughput,

Better read throughput is trivial to achieve even with other solutions
than multi-master replication.

And for better write throughput, the developers of Postgres-XC
(supported by NTT, among others) beg to differ:

http://postgresxc.wikia.com/wiki/Postgres-XC_Wiki
http://postgres-xc.sourceforge.net/

As does Bettina Kemme (of Postgres-R fame).

Sincerely,

Wolfgang

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2013-12-19 15:18:21 Re: Multi Master Replication
Previous Message Laurentius Purba 2013-12-19 14:07:25 Re: Is it advisable to pg_upgrade directly from 9.0 to 9.3?