[pgpool-general: 8263] Re: load_balance_mode is off by default but balancing works?

Bo Peng pengbo at sraoss.co.jp
Mon Jun 27 22:25:22 JST 2022


Hello,

> Hello,
> 
> 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. 
pgpool.conf.sample sets load_balance_mode = on.

Regards,
 
> Regards,
>     Nikola
> 
> 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
https://www.sraoss.co.jp/


More information about the pgpool-general mailing list