Обсуждение: Postgresql HA Cluster

On Sun, 2020-06-28 at 09:10 +0530, Brajendra Pratap Singh wrote:
> Is there any functionality present in postgresql for High Availability Cluster where we can setup
> multiple nodes/instances in READ-WRITE mode for single database so that incase of one node/instance
> failure it will automatically failover the traffic to 2nd node/instance (without
> failure or in less time) ,this is just like oracle RAC concept .
> 
> Here High Availability Cluster means there will be zero downtime incase of any one node/instance failure.

There is no such functionality built into PostgreSQL.

An architecture like Oracle RAC is not ideal for high availability, since the
ASM/Tablespace/Segment "file system" is a single point of failure.

You can use Solutions like Patroni or repmgr for high availability.

That would not provode a multi-master solution, though.  There are some
commercial solutions for that, but be warned that it would require non-trivial
changes to your application.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

Am 29.06.20 um 09:33 schrieb Laurenz Albe:
> That would not provode a multi-master solution, though.  There are some
> commercial solutions for that, but be warned that it would require non-trivial
> changes to your application.

not really with BDR3 ;-)


Andreas


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

Am 29.06.20 um 09:33 schrieb Laurenz Albe:
> That would not provode a multi-master solution, though.  There are some
> commercial solutions for that, but be warned that it would require non-trivial
> changes to your application.

not really with BDR3 ;-)