[pgpool-general: 8263] Re: load_balance_mode is off by default but balancing works?
pengbo at sraoss.co.jp
Mon Jun 27 22:25:22 JST 2022
> We run docker image pgpool/pgpool:4.2.2 in Kubernetes.
> I found that
> - if I set load_balance_mode off, load balancing doesn't work
> - if I remove load_balance_mode parameter from environment variables
> list, assuming the default value of load_balance_mode, load balancing
> works! And 'pgpool SHOW load_balance_mode' command returns 'on'.
In 4.2.x, the default value of load_balance_mode is "off".
However, Pgpool-II docker image uses the sample configuration file
pgpool.conf.sample sets load_balance_mode = on.
> 22.06.2022 12:17, Bo Peng пишет:
> > Hello,
> >> For our Pgpool, we did not set the parameter load_balance_mode. Its
> >> default is off. When we noticed this, we checked it by command "pgpool
> >> show load_balance_mode". Check returned 0. This means balancing was
> >> disabled. Correctly?
> >> However, the load balancing worked, according to various checks (for
> >> example, "show pool_nodes" command), read requests were routed to
> >> read-only replicas.
> >> Could you comment on this behavior of Pgpool?
> > If you are using Pgpool-II 4.3, the default value of
> > load_balance_mode is "on".
> > https://www.pgpool.net/docs/latest/en/html/runtime-config-load-balancing.html#GUC-LOAD-BALANCE-MODE
> >> Thanks in advance.
> >> --
> >> Regards,
> >> Nikola
> >> _______________________________________________
> >> pgpool-general mailing list
> >> pgpool-general at pgpool.net
> >> http://www.pgpool.net/mailman/listinfo/pgpool-general
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
More information about the pgpool-general