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

Lazáro Rubén García Martínez lgarciam at vnz.uci.cu
Wed Sep 19 01:33:33 JST 2012


>This sound cool. So, you configured two pgpool II server with watchdog ?  Can you share the configuration  ? that would be good. I installed pgpool-II from postgres repo and pgpool-II 3.2 is not available yet. I hope this will be available there too.

I have 4 servers, 2 servers with postgresql and 2 servers with pgpool, in each pgpool servers runs the watchdog for the high availability of pgpool-II.

In this link you can find a good tutorial for using the watchdog functionality.

http://www.pgpool.net/pgpool-web/contrib_docs/watchdog/en.html

Regards.
________________________________________
From: Khapare Joshi [khapare77 at gmail.com]
Sent: Tuesday, September 18, 2012 10:40 AM
To: Lazáro Rubén García Martínez
Subject: Re: [pgpool-general: 1014] pgpool-ha

HI,

Thanks for you answers

On Tue, Sep 18, 2012 at 1:38 PM, Lazáro Rubén García Martínez <lgarciam at vnz.uci.cu<mailto:lgarciam at vnz.uci.cu>> wrote:
>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.
This is what I would like to have.

2. This functionality is maintained for the pgpool-II comunity.
3. The configuration is very simple and easy to understand.


This sound cool. So, you configured two pgpool II server with watchdog ?  Can you share the configuration  ? that would be good. I installed pgpool-II from postgres repo and pgpool-II 3.2 is not available yet. I hope this will be available there too.



Regards.

________________________________________
From: pgpool-general-bounces at pgpool.net<mailto:pgpool-general-bounces at pgpool.net> [pgpool-general-bounces at pgpool.net<mailto:pgpool-general-bounces at pgpool.net>] On Behalf Of Khapare Joshi [khapare77 at gmail.com<mailto:khapare77 at gmail.com>]
Sent: Tuesday, September 18, 2012 5:21 AM
To: pgpool-general at pgpool.net<mailto: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


________________________________
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