Postgresql HA Cluster
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
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
På mandag 29. juni 2020 kl. 09:40:13, skrev Andreas Kretschmer <
andreas@a-kretschmer.de <mailto:andreas@a-kretschmer.de>>:
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
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, <laurenz.albe@cybertec.at>
wrote:
Show quoted text
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