Re: Multi Master Replication

On Wed, Dec 18, 2013 at 10:25 PM, Michael Paquier
<michael(dot)paquier(at)gmail(dot)com> wrote:

> On Thu, Dec 19, 2013 at 7:12 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)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.