PaaS Internals - Database Resident Connection Pooling

Post date: Sep 28, 2013 9:28:47 AM

Elastic scaling, multitenancy, routing and efficient load balancing are all concerns that are handled by PaaS solutions behind the scenes. One aspect that is not that visible is the means to provide efficiency at the connection pooling level between application servers and database servers. Here comes Database Resident Connection Pooling (DRCP) into play.

This capability uses physical connections between application server clusters and database server clusters efficiently by employing a background process on the database side to maintain the connection pool and allowing different application processes to share sessions with the same host machine as well as across different host machines. This feature improves database scalability especially in the case of applications that cannot be deployed as multithreaded since database requests are now performed independent of session state, relieving applications of holding connections to the database persistently.

More on PaaS Overview and the main implementation aspects of a cloud based offering on top of Oracle Weblogic, here: http://www.oraclejavamagazine-digital.com/javamagazine/20130910?sub_id=Vc1Gau9K6zPr&folio=36#pg37.