Re: Real application clustering in postgres.

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Real application clustering in postgres.
Date: 2020-03-09 14:30:07
Message-ID: 6eadecdf-f001-8bb7-567e-7fa0f34fc025@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am 05.03.20 um 13:07 schrieb Laurenz Albe:
> There is a closed-source implementation that you can buy:
> https://www.2ndquadrant.com/en/resources/postgres-bdr-2ndquadrant/
>
> But multi-master replication is complicated to get right, and
> an applicatoin that uses it has to be specifically designed for that.

Depends. We have an automation tool for setup (TPAexec), and as long you
are not using special feature like CAMO (Commit At Most Once) you can
use applications without changes.
(you have to set some parameters, for instance for sequences)

It works well, we have a lot of happy customers. Some of them using it
for globally distributed databases, other for high availability with 5
nines.
Here you can find more information:
https://www.2ndquadrant.com/en/resources/postgres-bdr-2ndquadrant/

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kouber Saparev 2020-03-09 15:47:23 Re: Is it safe to rename an index through pg_class update?
Previous Message greigwise 2020-03-09 14:06:14 Re: Table with many NULLS for indexed column yields strange query plan