[pgpool-general: 7037] Re: What happens to active connections when failover happens?

[Bo Peng]

hello,

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