[pgpool-general: 5363] How to understand 'load_balance_node' in pgpool-II 3.6.1

晓庆 paul_wang79 at qq.com
Tue Mar 14 14:06:54 JST 2017


Hi,
My pgpool upgrade from 3.5.x to 3.6.1. When I execute 'show pool_nodes', I see a different return result, It's cool!
But I want to know what's the meaning of 'load_balance_node'?
Maybe it means that the 'true' node is responsible for the 'load balancer',Is that right?
Note: I have two Pgpool nodes and two postgresql nodes, I configured VIP in pgpool nodes;



postgres=# show pool_nodes;
 node_id |  hostname  | port | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay 
---------+------------+------+--------+-----------+---------+------------+-------------------+-------------------
 0       | pg-server1 | 5432 | up     | 0.500000  | primary | 0          | false             | 0
 1       | pg-server2 | 5432 | up     | 0.500000  | standby | 0          | true              | 0
(2 rows)


Regards.
paul_wang79 at qq.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170314/f7d754de/attachment.html>


More information about the pgpool-general mailing list