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
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 |