Datasource connection pool usage in a cluster

[mylos78]

Hi all!

I'm going to set up a cluster of nodes in Domain mode which contains a Datasource definition within it. My question is: will the pool of connection be created on every node that is part of the cluster ? (So I have to request to the DB Administrator a total of connections = number of nodes * maxavailable connections)

Thanks

Mylos

[f_marchioni]

Mind it: Datasource connection pools are created on every node of the cluster.

Simple proof of concept: deploy a datasource on a cluster of two nodes. Set min_pool_size to lets say 10 and enable prefill. This means you will reclaim 10 connections from the DB on each node.

mysql> show status like 'Conn%';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| Connections   | 22    |

+---------------+-------+

1 row in set (0.00 sec)

(2 connections are open mysql shells)

Hope it helps,

Francesco

[mylos78]

Thanks Francesco!