Within the WSO2 platform, we use Tomcat JDBC pooling as the default pooling framework due to its production ready stability and high performance. The goal of tuning the pool properties is to maintain a pool that is large enough to handle peak load without unnecessarily utilising resources. These pooling configurations can be tuned for your production server in general in the
<DSS_HOME>/repository/conf/datasources/master-datasources.xml file, and for each of the RDBMS datasources created in your server:
- Tune the pooling configurations for the production server in the
- Tune the configurations for each of the datasourcesRDBMS datasource, at the time of creating the datasource using the management console. See Managing Datasources and Creating Datasources for details on how datasources area created and added to data servicesRead about configuring an RDBMS datasource and creating a data service with RDBMS datasource for details.
The following parameters should be considered when tuning the connection pool: