Re: Setup pgpool-II with streaming replication

On 9/6/2016 2:10 PM, Ashish Chauhan wrote:
> ...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