Postgresql HA Cluster

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Postgresql HA Cluster

Brajendra Pratap Singh-2
Hi All,

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.

Please help us to know this.

Thanks & Regards,
Brajendra
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql HA Cluster

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



Reply | Threaded
Open this post in threaded view
|

Re: Postgresql HA Cluster

Andreas Kretschmer-3


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



Reply | Threaded
Open this post in threaded view
|

Re: Postgresql HA Cluster

Andreas Joseph Krogh-2
På mandag 29. juni 2020 kl. 09:40:13, skrev Andreas Kretschmer <[hidden email]>:


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 ;-)
 
Well, BDR, last time I checked, still doesn't support exclusion-constraints, so it's not a drop-in replacement.
 
--
Andreas Joseph Krogh
 
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql HA Cluster

Brajendra Pratap Singh-2
In reply to this post by Laurenz Albe
Hi Albe,

Here is my one more concern regarding patroni and repmgr tool versions compatibility with centos8 and postgresql 10/11/12 versions, could u plz provide ur valuable output.

Thanks
Brajendra

On Mon, 29 Jun, 2020, 1:03 PM Laurenz Albe, <[hidden email]> wrote:
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