[pgpool-general: 5051] Re: PGPool - Load Balancing - Query or connection level
Tatsuo Ishii
ishii at sraoss.co.jp
Mon Oct 17 21:45:41 JST 2016
> Hi I have setup PGPool with Load Balancing enabled. I notice that the Load Balancing is done at the connection level - not at the query level. ie: only new connections are LB, where as an open connection in PGAdmin for example and run multiple selects statements in PGSQLAdmin window are run against same node ie: Master.
>
> So, first of all how does the PGPool LB work - connection (ie: each connection/query will be LB across server or query level?
>
> Can I specify one or the other.
Pgpool-II's load balancing is connection level. Once a session from
client to Pgpool-II is established, the load balancing target server
will not be changed until the session ends.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
More information about the pgpool-general
mailing list