[pgpool-general: 5380] Re: pgpool-II and JDBC pool

[Mephysto]

Any ideas about this topic?

Regards.

Meph

On 16 March 2017 at 15:25, Mephysto <mephystoonhell at gmail.com> wrote:

> 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/20170322/58174a93/attachment.html>