Support for cloud-based multi-tenant environments using connection labeling

摘要

A system and method for connection labeling for use with connection pools, including support for cloud-based multi-tenant environments using connection labeling. In accordance with an embodiment, the system comprises a connection pool, including a plurality of connection objects which provide connections that software applications can use to make requests to access the database, wherein each of the connections can be labeled according to the configuration of particular applications; and a connection pool logic that identifies connections labeled as high-cost connections, and controls the creation or repurposing of high-cost connections to serve requests from the multiple tenants or tenant applications.

主权项

1. A system for connection labeling for use with connection pools, comprising:
a computer including a processor and a database, and providing a multi-tenant cloud environment that includes or provides access to the database, for use by a plurality of tenant applications in a cloud-based environment; a connection pool, including a plurality of connection objects which provide connections that the plurality of tenant applications use to make requests to access the database, wherein each connection of the connections is labeled according to configuration information of one or more of the plurality of tenant applications; and a connection pool logic that operates to
receive a request, from a tenant application, for a connection with a particular label,invoke a cost callback method to calculate, for each idle connection in the connection pool, a cost for reconfiguring that idle connection to a state associated with the particular label,identify one or more of the idle connections as high-cost connections by comparing the calculated cost associated with each idle connection, with a high-cost value, wherein each identified high-cost connection is associated with a calculated cost larger than the high-cost value,determine whether a total number of active and idle connections in the connection pool is less than a threshold value defined by the tenant application, andbased on a result of the determining, create a new connection, or repurpose one identified high-cost connection of the identified high-cost connections to serve the request from the tenant application.