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

Nikolay Mastilo (HM) nikm71 at hotmail.com
Mon Jun 27 23:58:25 JST 2022


Hello!

Oh, it's all clear now!

Thank you very much!

Regards,
   Nikola

27.06.2022 16:25, Bo Peng пишет:
> 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
>


More information about the pgpool-general mailing list