[pgpool-general: 5376] pgpool-II and JDBC pool

[Mephysto]

Hi there,
at the moment, I am using pgpool-II as load balancer in master-slave mode
with streaming replication with two postgres nodes. Pgpool is accessed by a
java server application that use a JDBC pool in Payara (a Glassfish fork)
application server.

During startup phase, the application execute about 1800 queries that are
almost all readonly stored functions, but pgpool send queries almost
exclusively toward primary node. This is the situation after some tries:



postgres at postgres=# show pool_nodes;
 node_id |        hostname         | port  | status | lb_weight |  role   |
select_cnt | load_balance_node | replication_delay
---------+-------------------------+-------+--------+-------
----+---------+------------+-------------------+-------------------
 0       | citrix2.redevogames.com | 15004 | up     | 0.250000  | primary |
9520       | true              | 0
 1       | 10.0.0.3                | 5997  | up     | 0.750000  | standby |
10         | false             | 0




The question now is: is it a good idea to use a JDBC pool to connect to
pgpgool or is it better without it?


It can be other reason for this behavior of balancer?


Thanks in advance.


Meph
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170316/b0dfd4c2/attachment.html>