Custom Connection Profile for iseries Improves MuleSoft Integration Performance
A client in the healthcare field wasexperiencing serious degradation in performance with database queries. The versionof their integration platform, MuleSoft 3.9, did not offer out-of-the-boxsupport for their legacy iSeries system and DB2 database. Although MuleSoft’sAnypoint Platform provides a Generic database connector that could be used withDB2, it was found to create a new database connection for each query. Thiscreated heavy loads and slowed performance for the system’s resources.
The solution needed to remove ad hocconnections to the database to lessen system load. To achieve this, a third-partylibrary called HikariCP was used to create a custom connection profile. The newconnection profile caches database connections from the connection pool perapplication instead of creating a new connection for each query. Theseconnections to the database can then be re-used. Profiles can specify thenumber of connections to be pre-cached and indicate a time-to-live value,reducing the number of unused connections occupying the pool.
With the new custom connection profile,connections are always available when a new request is added. As a result,resource utilization became more predictable and the client saw an impressivedrop of nearly 70% in response times, all but eliminating the performanceissues caused by DB2 queries.