[pgpool-general: 7037] Re: What happens to active connections when failover happens?
pengbo at sraoss.co.jp
Mon May 25 15:43:51 JST 2020
On Fri, 22 May 2020 16:44:02 +1000
Rajni Baliyan <saan654 at gmail.com> wrote:
> sorry hit the wrong button and my question did not complete. Below is the
> complete request-
> > Hi pgpool experts,
> > I have a question regarding pgpool connections.
> > What will happen to user connections in below scenarios-
> > - When request is being served on replica and replica went down.
> > - Will connection fail-over to other replica or master ?
> > - Will connection terminate and user has to start new session?
The connection is terminated and user has to start a new session.
> > - When actual failover is happening ?
The actual failover occurs in the following three cases:
(1) the primary server failure is detected by health checking
(2) the queries fail on primary server
(3) If watchdog is enable, the actual failover may be triggered by remote pgpool(watchdog)
> > Is there a good reference ( document/blog etc.)
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
More information about the pgpool-general