[pgpool-general: 1015] Re: pgpool-ha

Lazáro Rubén García Martínez lgarciam at vnz.uci.cu
Tue Sep 18 22:38:58 JST 2012


>1. If I am going to configure two pgpool server (for ha) then both server must be installed pgpool-II and required libraries and as well as pgpool-ha ?

Yes.

pgpool-ha is a Heartbeat agent scripts for pgpool, that means you need to install heartbeat.

You can find more information about this ha software in:
http://www.linux-ha.org/wiki/Heartbeat

In the pgpool-HA package, there is documentation for installing it.

I had configured this software in my work, but after pgpool-II 3.2, I change all thanks to watchdog. Watchdog is a new functionality of pgpool-II 3.2 for serving high availability of pgpool-II. I have migrated to watchdog for this reasons:

1. I only need one software, pgpool-II, not pgpool-HA, heartbeat, Cluster Glue and Resource Agents any more.
2. This functionality is maintained for the pgpool-II comunity.
3. The configuration is very simple and easy to understand.

>3. Is there a gui for this similar to pgpool-admin ?
No

Regards.

________________________________________
From: pgpool-general-bounces at pgpool.net [pgpool-general-bounces at pgpool.net] On Behalf Of Khapare Joshi [khapare77 at gmail.com]
Sent: Tuesday, September 18, 2012 5:21 AM
To: pgpool-general at pgpool.net
Subject: [pgpool-general: 1014] pgpool-ha

Hello all,

I been playing with pgpool and testing before we put in our production environment. At the moment I pgpool in one server and two postgres backend server. This looks working. Now I would like o use pgpool-ha if pgpool1 server goes down. I do not find any documents on how to configure this. It would be really good if somebody share their experiences.

1. If I am going to configure two pgpool server (for ha) then both server must be installed pgpool-II and required libraries and as well as pgpool-ha ?
2. How do I configure pgpool-ha for that purpose ?
3. Is there a gui for this similar to pgpool-admin ?


My ideal setup
===========

2 pgpool server for HA
2 postgres backend server

a) if any of the postgres server goes down or error get an alert
b) if I want to add 3rd postgres server, how do I add without restarting pgpool and without taking down the services. And will the number 3rd postgres server would get replicated all the data from the two server ? how does it work ?
c) similarly, let say one of the postgres server goes down or not responsive how would I know that number one server is not responsive or down ?
d) Let say, postgres server 1 went down, its okay now I server 2 is serving the application, now I fixed the server 1 and i want to put back online, does this server get updated automatically ( i Meant the data).

Basically, I would like to have d) to be synchronized with the data automatically without restarting pgpool or ec.

Sorry for too many question but I would love to hear opinion on this.

Regards,
K
________________________________
Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com

Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com


More information about the pgpool-general mailing list