Dynamically configurable resource pool

• US 20040088413A1
• Filed: 11/04/2002
• Published: 05/06/2004
• Est. Priority Date: 11/04/2002
• Status: Active Grant

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Oracle America, Inc. (Oracle Corporation)
• Inventors: Kumar, Ajay, Dutt, Bala, Kannan, Srinivasan, K, Venugopal Rao, Bhogi, Sankara R.
• Granted Patent: US 8,145,759 B2
• Time in Patent Office: Days
• US Class Current: 709/226
• CPC Class Codes: G06F 2209/5011 Pool
• CPC Class Codes: G06F 9/5061 Partitioning or combining of resources

Abstract

A dynamically configurable resource pool may provide a pool of computing resource for use in a computing system or application, such as a connection pool or a thread pool for server systems such as application and web server systems. In one embodiment, a server may include a resource pool configured to provide a plurality of computing resources. Other components in the server may be configured to request use of one of the computing resources from the connection pool. The resource pool may include a resource pool manager configured to service requests for the computing resources. The resource pool manager may manage configuration of the resource pool. The resource pool manager may also be configured to receive a configuration change request to change the configuration of the resource pool while the resource pool is available for use.

Claims

1. A system, comprising:

a resource pool configured to provide a plurality of computing resources;

a plurality of requesters each configured to request use of one of the computing resources from the connection pool;

wherein the resource pool comprises a resource pool manager configured to service requests for the computing resources, wherein the resource pool manager is further configured to manage configuration of the resource pool, wherein the resource pool manager is configured to;

receive a configuration change request to change the configuration of the resource pool while the resource pool is available for use;

dynamically evaluate the configuration change request based on current usage of the resource pool to determine the impact of implementation of the requested configuration change on the current usage of the resource pool;

if implementation of the requested configuration change would disrupt usage of the resource pool, delay implementation of the requested configuration change until the configuration change can be implemented without disrupting usage of the resource pool.

2. The system as recited in claim 1, wherein, if implementation of the requested configuration change would not disrupt usage of the resource pool, the resource pool manager is configured to perform the requested configuration change for the resource pool while the resource pool is available for use.

3. The system as recited in claim 1, wherein the resource pool comprises a connection pool, and wherein the computing resources comprise connections to one or more backend systems.

4. The system as recited in claim 3, wherein the one or more backend systems comprise one or more databases, wherein one or more of the connections of the connection pool are database connections.

5. The system as recited in claim 3, wherein the configuration change request comprises a request to change the maximum number of connections for the connection pool.

6. The system as recited in claim 5, wherein, if currently implemented, the configuration change request to change the maximum number of connections would cause one or more connections currently in use to be lost, the connection pool manager is configured to delay implementation of the configuration change request until the number of connections currently in use is less than or equal to the number indicated in the configuration change request.

7. The system as recited in claim 3, wherein the connection pool manager comprises a wait queue, wherein if a request is received for a connection when the connection pool is at a maximum size and none of the connections are available, the connection pool manager is configured to store the request in the wait queue.

8. The system as recited in claim 7, wherein the configuration change request comprises a request to change the number of entries in the wait queue.

9. The system as recited in claim 8, wherein, if currently implemented, the configuration change request to change the number of entries in the wait queue would cause one or more pending connection requests in the wait queue to be lost, the connection pool manager is configured to delay implementation of the configuration change request until the number of connection requests pending in the wait queue is less than or equal to the number of wait queue entries indicated by the configuration change request.

10. The system as recited in claim 3, wherein the connection pool manager is further configured to provide statistics on current usage of the connection pool.

11. The system as recited in claim 3, wherein the connection pool manager comprises:

a main unit configured to service connection requests and configuration change requests for the connection pool;

a wait queue unit coupled to the main unit and configured to queue connection requests when the connection pool is at a maximum size and none of the connections are available; and

a statistics unit configured to calculate cumulative usage statistics for the connection pool.

12. The system as recited in claim 11, wherein the plurality of requesters execute within a multi-threaded environment, wherein the main unit, the wait queue unit, and the statistics unit are each configured to be locked separately to synchronize concurrent requests to the connection pool.

13. The system as recited in claim 11, wherein the statistics unit is configured to provide one or more of the cumulative usage statistics for the connection pool in response to a cumulative statistic request.

14. The system as recited in claim 13, wherein the statistics unit and main unit are configured to respond concurrently to cumulative statistic requests and connection requests respectively.

15. The system as recited in claim 13, wherein the main unit is configured to provide current statistics for connection pool usage.

16. The system as recited in claim 1, wherein the resource pool comprises a thread pool.

17. A method, comprising:

initiating a resource pool for providing a plurality of computing resources to a plurality of requesters;

providing computing resources from the resource pool to a plurality of requesters;

receiving a configuration change request to change the configuration of the resource pool while the resource pool is available for use;

dynamically evaluating the configuration change request based on current usage of the resource pool to determine the impact of implementation of the requested configuration change on the current usage of the resource pool;

if implementation of the requested configuration change would disrupt usage of the resource pool, delaying implementation of the requested configuration change until the configuration change can be implemented without disrupting usage of the resource pool.

18. The method as recited in claim 17, further comprising, if implementation of the requested configuration change would not disrupt usage of the resource pool, performing the requested configuration change for the resource pool while the resource pool is available for use.

19. The method as recited in claim 17, wherein the resource pool comprises a connection pool, and wherein the computing resources comprise connections to one or more backend systems.

20. The method as recited in claim 19, wherein the one or more backend systems comprise one or more databases, wherein one or more of the connections of the connection pool are database connections.

21. The method as recited in claim 19, wherein the configuration change request comprises a request to change the maximum number of connections for the connection pool.

22. The method as recited in claim 21, further comprising, if currently implemented, the configuration change request to change the maximum number of connections would cause one or more connections currently in use to be lost, delaying implementation of the configuration change request until the number of connections currently in use is less than or equal to the number indicated in the configuration change request.

23. The method as recited in claim 19, wherein the connection pool manager comprises a wait queue, the method further comprising if a request is received for a connection when the connection pool is at a maximum size and none of the connections are available, storing the request in the wait queue.

24. The method as recited in claim 23, wherein the configuration change request comprises a request to change the number of entries in the wait queue.

25. The method as recited in claim 24, further comprising, if current implementation of the configuration change request to change the number of entries in the wait queue would cause one or more pending connection requests in the wait queue to be lost, delaying implementation of the configuration change request until the number of connection requests pending in the wait queue is less than or equal to the number of wait queue entries indicated by the configuration change request.

26. The method as recited in claim 19, further comprising providing statistics on current usage of the connection pool.

27. The method as recited in claim 19, further comprising:

a main unit servicing connection requests and configuration change requests for the connection pool;

a wait queue unit coupled to the main unit queuing connection requests when the connection pool is at a maximum size and none of the connections are available; and

a statistics unit calculating cumulative usage statistics for the connection pool.

28. The method as recited in claim 27, wherein the plurality of requesters execute within a multi-threaded environment, the method further comprising locking the main unit, the wait queue unit, and the statistics unit separately to synchronize concurrent requests to the connection pool.

29. The method as recited in claim 27, further comprising providing one or more of the cumulative usage statistics for the connection pool in response to a cumulative statistic request.

30. The method as recited in claim 29, further comprising responding concurrently to cumulative statistic requests and connection requests respectively.

31. The method as recited in claim 29, further comprising providing current statistics for connection pool usage.

32. The method as recited in claim 17, wherein the resource pool comprises a thread pool.

33. A computer accessible medium comprising program instructions configured to enable computer operations comprising:

initiating a resource pool for providing a plurality of computing resources to a plurality of requestors;

providing computing resources from the resource pool to a plurality of requesters;

receiving a configuration change request to change the configuration of the resource pool while the resource pool is available for use;

dynamically evaluating the configuration change request based on current usage of the resource pool to determine the impact of implementation of the requested configuration change on the current usage of the resource pool;

if implementation of the requested configuration change would disrupt usage of the resource pool, delaying implementation of the requested configuration change until the configuration change can be implemented without disrupting usage of the resource pool.

34. The computer accessible medium as recited in claim 33, wherein the program instructions are configured to enable computer operations further comprising, if implementation of the requested configuration change would not disrupt usage of the resource pool, performing the requested configuration change for the resource pool while the resource pool is available for use.

35. The computer accessible medium as recited in claim 33, wherein the resource pool comprises a connection pool, and wherein the computing resources comprise connections to one or more backend systems.

36. The computer accessible medium as recited in claim 35, wherein the one or more backend systems comprise one or more databases, wherein one or more of the connections of the connection pool are database connections.

37. The computer accessible medium as recited in claim 35, wherein the configuration change request comprises a request to change the maximum number of connections for the connection pool.

38. The computer accessible medium as recited in claim 37, wherein the program instructions are configured to enable computer operations further comprising;

if currently implemented, the configuration change request to change the maximum number of connections would cause one or more connections currently in use to be lost, delaying implementation of the configuration change request until the number of connections currently in use is less than or equal to the number indicated in the configuration change request.

39. The computer accessible medium as recited in claim 35, wherein the connection pool manager comprises a wait queue, wherein the program instructions are configured to enable computer operations further comprising if a request is received for a connection when the connection pool is at a maximum size and none of the connections are available, storing the request in the wait queue.

40. The computer accessible medium as recited in claim 39, wherein the configuration change request comprises a request to change the number of entries in the wait queue.

41. The computer accessible medium as recited in claim 40, wherein the program instructions are configured to enable computer operations further comprising, if current implementation of the configuration change request to change the number of entries in the wait queue would cause one or more pending connection requests in the wait queue to be lost, delaying implementation of the configuration change request until the number of connection requests pending in the wait queue is less than or equal to the number of wait queue entries indicated by the configuration change request.

42. The computer accessible medium as recited in claim 35, wherein the program instructions are configured to enable computer operations further comprising providing statistics on current usage of the connection pool.

43. The computer accessible medium as recited in claim 35, wherein the program instructions are configured to enable computer operations further comprising:

a main unit servicing connection requests and configuration change requests for the connection pool;

a wait queue unit coupled to the main unit queuing connection requests when the connection pool is at a maximum size and none of the connections are available; and

a statistics unit calculating cumulative usage statistics for the connection pool.

44. The computer accessible medium as recited in claim 43, wherein the plurality of requesters execute within a multi-threaded environment, wherein the program instructions are configured to enable computer operations further comprising locking the main unit, the wait queue unit, and the statistics unit separately to synchronize concurrent requests to the connection pool.

45. The computer accessible medium as recited in claim 43, wherein the program instructions are configured to enable computer operations further comprising providing one or more of the cumulative usage statistics for the connection pool in response to a cumulative statistic request.

46. The computer accessible medium as recited in claim 45, wherein the program instructions are configured to enable computer operations further comprising responding concurrently to cumulative statistic requests and connection requests respectively.

47. The computer accessible medium as recited in claim 45, wherein the program instructions are configured to enable computer operations further comprising providing current statistics for connection pool usage.

48. The computer accessible medium as recited in claim 33, wherein the resource pool comprises a thread pool.