Thread: Cluster fencing tool/software for PostgreSQL cluster with streaming replication
Cluster fencing tool/software for PostgreSQL cluster with streaming replication
From
Vikas Sharma
Date:
Hi,
I am planning for an enterprise grade PostgreSQL cluster and so looking for the tool/softwares which will do the cluster management or fencing to avoid split brain.
Please, could you let me know if there are some tools/software which can do that so it can be used in a production environment.
PostgreSQL12 with streaming replication + repmgr and pgpool for connection management and load balancing.
Regards
Vikas S
Re: Cluster fencing tool/software for PostgreSQL cluster with streaming replication
From
Mladen Gogala
Date:
Hi Vikas! I used to see you on the mailing list for another database, that shall remain unnamed but starts with the letter "O". To answer your question: I have very good experience with Veritas Cluster on both Linux and Solaris (or was it Slowaris? I forgot the exact spelling :). It's an industry standard fail-over cluster and Veritas provides an excellent support for it. Regards On 8/16/21 6:31 AM, Vikas Sharma wrote: > Hi, > > I am planning for an enterprise grade PostgreSQL cluster and so > looking for the tool/softwares which will do the cluster management or > fencing to avoid split brain. > > Please, could you let me know if there are some tools/software which > can do that so it can be used in a production environment. > > PostgreSQL12 with streaming replication + repmgr and pgpool for > connection management and load balancing. > > Regards > Vikas S > > -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com
Re: Cluster fencing tool/software for PostgreSQL cluster with streaming replication
From
Bruce Momjian
Date:
On Mon, Aug 16, 2021 at 10:39:34AM -0400, Mladen Gogala wrote: > Hi Vikas! > > I used to see you on the mailing list for another database, that shall > remain unnamed but starts with the letter "O". To answer your question: I > have very good experience with Veritas Cluster on both Linux and Solaris (or > was it Slowaris? I forgot the exact spelling :). It's an industry standard > fail-over cluster and Veritas provides an excellent support for it. Uh, somehow Vikas Sharma <shavikas@gmail.com> got removed from this email reply; I am adding him here. --------------------------------------------------------------------------- > > Regards > > On 8/16/21 6:31 AM, Vikas Sharma wrote: > > Hi, > > > > I am planning for an enterprise grade PostgreSQL cluster and so looking > > for the tool/softwares which will do the cluster management or fencing > > to avoid split brain. > > > > Please, could you let me know if there are some tools/software which can > > do that so it can be used in a production environment. > > > > PostgreSQL12 with streaming replication + repmgr and pgpool for > > connection management and load balancing. > > > > Regards > > Vikas S > > > > > -- > Mladen Gogala > Database Consultant > Tel: (347) 321-1217 > https://dbwhisperer.wordpress.com > > > -- Bruce Momjian <bruce@momjian.us> https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.
Re: Cluster fencing tool/software for PostgreSQL cluster with streaming replication
From
Jehan-Guillaume de Rorthais
Date:
On Mon, 16 Aug 2021 11:31:23 +0100 Vikas Sharma <shavikas@gmail.com> wrote: > Hi, > > I am planning for an enterprise grade PostgreSQL cluster and so looking for > the tool/softwares which will do the cluster management or fencing to avoid > split brain. Look at Pacemaker, pro support and devel by both RedHat and Suse. Depending on the stack you want to build, you might want to use the pgsql official resource agent or PAF (https://clusterlabs.github.io/PAF/). This specific agent might not be supported by RH/Suse though. Regards,