[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