Re: Real application clustering in postgres. - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Real application clustering in postgres.
Date
Msg-id 6eadecdf-f001-8bb7-567e-7fa0f34fc025@a-kretschmer.de
Whole thread Raw
In response to Re: Real application clustering in postgres.  (Laurenz Albe <laurenz.albe@cybertec.at>)
List 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




pgsql-general by date:

Previous
From: greigwise
Date:
Subject: Re: Table with many NULLS for indexed column yields strange queryplan
Next
From: Kouber Saparev
Date:
Subject: Re: Is it safe to rename an index through pg_class update?