Re: Multi Master Replication - Mailing list pgsql-general

From Wolfgang Keller
Subject Re: Multi Master Replication
Date
Msg-id 20131219155201.bb38120fa2a62d1cc0515944@gmx.net
Whole thread Raw
In response to Re: Multi Master Replication  (Chris Travers <chris.travers@gmail.com>)
Responses Re: Multi Master Replication
List 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


pgsql-general by date:

Previous
From: Laurentius Purba
Date:
Subject: Re: Is it advisable to pg_upgrade directly from 9.0 to 9.3?
Next
From: Chris Travers
Date:
Subject: Re: Multi Master Replication