[pgpool-general: 6702] Re: PGPool does not balance queries correctly. Java Application.

Lachezar Dobrev l.dobrev at gmail.com
Mon Sep 9 21:43:25 JST 2019


  Last time I had such issues I noticed, that all the jobs were
executed in a transaction, and AFAIK transactions are not load
balanced.

На ср, 4.09.2019 г. в 18:53 ч. Franklin Anderson de Oliveira Souza
<franklinbr at gmail.com> написа:
>
> Hello Everyone,
>
> I have four node postgresql with pgpol ahead:
>
> 0 node: master
> lb_weight: 0.25
>
> 1 node: slave1
> lb_weight: 0.25
>
> 2 node: slave2
> lb_weight: 0.25
>
> 3 node: slave3
> lb_weight: 0.25
>
> JBoss of a Java application is sending 99% queries only to the
> master node 0.
> PGPool and PostgreSQL servers are properly configured and i use method streaming replication. (pgpool.conf.sample-stream.)
> Do I need to validate some parameter in the java configuration to perform the correct balancing based on the lb_weight set?
>
> Obs:
> When I run a simple shell script (psql) perform queries from pgpool the balancing occurs perfectly
>
> thankful
>
> --
> foobar
> _______________________________________________
> 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