[pgpool-committers: 5708] pgpool: Speed up failover when all of backends are down.

Tatsuo Ishii ishii at sraoss.co.jp
Fri May 3 09:17:31 JST 2019


Speed up failover when all of backends are down.

Pgpool-II tries to find primary node till search_primary_node_timeout
expires even if all of the backend are in down status. This is not
only a waste of time but makes Pgpool-II looked like hanged because
while searching primary node failover process is suspended and all of
the Pgpool-II child process are in defunct state, thus there's no
process which accepts connection requests from clients. Since the
default value of searching primary is 300 seconds, typically this
keeps on for 300 seconds. This is not comfortable for users.

So immediately give up finding primary node regardless
search_primary_node_timeout and promptly finish the failover process
if all of the backend are in down status.

Discussion: https://www.pgpool.net/pipermail/pgpool-hackers/2019-May/003321.html

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=ff3c54eb884b8fbb063a4501ed548112d76cc205

Modified Files
--------------
src/main/pgpool_main.c | 19 ++++++++++++++++++-
1 file changed, 18 insertions(+), 1 deletion(-)



More information about the pgpool-committers mailing list