Обсуждение: Setup pgpool-II with streaming replication
Hi,
We do have Postgres 9.4 streaming replication in Prod environment, currently we are having issue with our DB connections and planning to implement PgPool-II for database pooling with streaming replication.
Key Challenges:
· Cannot afford downtime on db servers.
· Add PgPool-II with current streaming replication.
· Not planning to use PgPoolAdmin tool.
I gone through below articles but some or other way require DB server restart which is not possible in our case. Could you please provide some documentation or steps how to achive connection pooling without any downtime?
http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/
Thanks,
Ashish Chauhan
I gone through below articles but some or other way require DB server restart which is not possible in our case. Could you please provide some documentation or steps how to achive connection pooling without any downtime?
...Cannot afford downtime on db servers...
thats an impossible target in general unless you expect computer systems to run perfectly forever without ever needing hardware or software maintenance. there are strategies to /minimize/ downtime, such as having active/standby failover, but the simple act of failing over requires a short downtime where your applications are forcibly disconnected from the formerly active database and have to reconnect to the newly activated master, restarting any transactions that were in progress at the time of interruption. then there's the issues of building fully redundant network infrastructure, as well as redundant pooling. In my experience, the more pieces you add to a system in an attempt to make it more robust, the more fragile and delicate it becomes.
-- john r pierce, recycling bits in santa cruz
Thanks Venkata for your reply.
Currently, we have two Postgres server with master-slave streaming replication. All application servers are directly pointing to master server only. I am planning to setup new server for PgPool, at the time of divert app server to PgPool, I will pool out application server one by one from Load balancer and point it to PgPool which will not affect our application.
Could you pls send me steps how to install PgPool without PgPoolAdmin?
http://www.pgpool.net/docs/latest/tutorial-en.html#install
Thanks Venkata for your reply.
Currently, we have two Postgres server with master-slave streaming replication. All application servers are directly pointing to master server only. I am planning to setup new server for PgPool, at the time of divert app server to PgPool, I will pool out application server one by one from Load balancer and point it to PgPool which will not affect our application.
Could you pls send me steps how to install PgPool without PgPoolAdmin?
Thanks,
Ashish
From: Venkata B Nagothi [mailto:nag1010@gmail.com]
Sent: Wednesday, September 07, 2016 5:46 PM, 17:46
To: Ashish Chauhan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Setup pgpool-II with streaming replication
I gone through below articles but some or other way require DB server restart which is not possible in our case. Could you please provide some documentation or steps how to achive connection pooling without any downtime?
DB server restart ? Why do you think you need to restart the database ? that can be confirmed if you could help us know your planned architecture and the existing database configuration settings.
Yes, downtime is definitely needed as the Application needs to connect to the database using pgPool port instead of DB port which is something to do with the Application server.
Regards,
Venkata B N
Fujitsu Australia
Hi Ashish, could you please help me setting up the pgpool , i am currenlty into same like u had asked to setup . I have mater/slave 9.4 and i would need to setup pgpool so that app connects to pgpool and diverts the connection to new master . Could u please help me with ur thoughts? Thanks, Subash -- View this message in context: http://www.postgresql-archive.org/Setup-pgpool-II-with-streaming-replication-tp5920011p5947166.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.