Re: Multi Master Replication - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Multi Master Replication
Date
Msg-id CAOR=d=1daWHDKLga=xL=450Xv7NuGn7mF4Pab8kDYc3CBvTMcA@mail.gmail.com
Whole thread Raw
In response to Re: Multi Master Replication  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Multi Master Replication  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
On Wed, Dec 18, 2013 at 10:25 PM, Michael Paquier
<michael.paquier@gmail.com> wrote:

> On Thu, Dec 19, 2013 at 7:12 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:

>> When people start talking multi-master replication my first response
>> is to ask what problem you're trying to solve. Sometimes MM Rep IS the
>> answer. But quite often it's not the best one for your problem. So to
>> OP I'd ask what problem they're trying to solve.

> Yes that's actually the right approach, multi-master replication is
> often cited as a marketing term for a fantastic technology that can
> solve a lot of problems, which could be solved with a couple of
> Postgres servers using a single-master, multiple-slave approach, or by
> simply design a system that can do data sharding among a set of
> Postgres servers to achieve some kind of write scalability.

Sharding with plproxy is pretty easy and can scale hugely.


pgsql-general by date:

Previous
From: Bob Futrelle
Date:
Subject: Installed postgres.app 9.3.1.0. pgadmin doesn't appear to see it
Next
From: Amit Langote
Date:
Subject: Re: unexpected pageaddr error in db log