Thread: Cluster fencing tool/software for PostgreSQL cluster with streaming replication

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


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




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,