|
Problem |
What is the database impact of sharing a datasource across
multiple application servers or in a workload managed environment? |
|
Solution |
WebSphere® Application Server connection pooling enables
administrators to establish a pool of database connections that can be
shared by applications on an application server. Datasources and
connection pools generally have a one-to-one relationship. However, in the
case of a work load managed application, one pool is created for each
clone or server group member.
A datasource creates one pool and has one max connections setting per
application server. When implementing workload management, clones or
server group members are considered separate application servers, meaning
each clone or member of the server group has its own pool of connections
to the database. The max database connections opened by that datasource
would then be calculated as the number of application servers or clones
that use the datasource multiplied by the number of max connections
specified in the datasource properties.
This same concept applies when calculating the number of minimum
connections established with the database. |
|
|
|
|
|
|