Users Guide

Cluster Constraints | Clustering
110 OMNM 6.5.3 Installation Guide
Database Connections
By default each deployed application server has 60 database pool connections available. In
distributed systems, size connections by multiplying the number of application servers deployed in
the system by 60 to get a starting point for the total number of required database connections.
NOTE:
This is just a general starting point and as demand on the system grows, various web and OpenManage
Network Manager components requiring connections naturally increase.
The database connection pools configuration file locations for Oracle and MySQL appear below
with their default max connection pool sizes. These numbers determine the overall pool
requirements per application server.
Oracle database file locations:
Oware connection pools
/oware/jboss-5.1/owareconf/oracle-ds.xml
corepool uses default max-pool-size (5)
jobpool uses default max-pool-size (10)
userpool uses default max-pool-size (25)
Performance connection pools
/owareapps/performance/server/conf/pm-oracle-ds.xml
pmpool uses default max-pool-size (10)
OpenManage Network Manager connection pools
/owareapps/dellemc/server/conf/rc-oracle-ds.xml
eventhistory pool uses default max-pool-size (10)
MySQL database file locations:
Oware connection pools
/oware/jboss-5.1/oware/conf/mysql-ds.xml
corepool uses default max-pool-size (5)
jobpool uses default max-pool-size (10)
userpool uses default max-pool-size (25)
Performance connection pools
/owareapps/performance/server/conf/pm-mysql-ds.xml
pmpool uses default max-pool-size (10)
OpenManage Network Manager connection pools
/owareapps/dellemc/server/conf/rc-mysql-ds.xml
eventhistory pool uses default max-pool-size (10)
To calculate total number of connections:
Add the number of pool connections per server times the number of deployed servers. That equals
the total number of maximum database connections
For example, if your cluster has 12 servers, the suggested total is 12 x 60 = 720 connections. Again,
this is just a general starting point and to account for an natural increase in database connections.
Best practice here would be to increase that number by at least a factor of at 5 for a total of 3600
connections.