Connection pool use of runtime load balancing service performance advisories

• US 8,626,890 B2
• Filed: 11/03/2010
• Issued: 01/07/2014
• Est. Priority Date: 08/14/2003
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Colrain, Carol L., Surber, Douglas N., Irudayaraj, Rajkumar A.
• Primary Examiner(s): Nguyen, Tammy
• Application Number:
  US12/938,545
• Publication Number:
  US 20110055368A1
• Time in Patent Office: 1,161 Days
• Field of Search: 709/223, 709/220, 709/226, 709/201, 709/227
• US Class Current: 709/223
• CPC Class Codes: G06F 2209/508 Monitor
• CPC Class Codes: G06F 9/505 considering the load
• CPC Class Codes: G06F 9/5083 Techniques for rebalancing the load in a distributed system

Abstract

Runtime connection load balancing of work across connections to a clustered computing system involves the routing of requests for a service, based on the current operational performance of each of the instances that offer the service. A connection is selected from an identified connection pool, to connect to an instance that provides the service for routing a work request. The operational performance of the instances may be represented by performance information that characterizes the response time and/or the throughput of the service that is provided by a particular instance on a respective node of the system, and is relative to other instances that offer the same service.

Claims

1. A computer-implemented method for managing connections to a computing system that comprises a plurality of computing nodes that host a plurality of server instances that provide a service, the method comprising:

periodically gravitating connections between server instances of said plurality of server instances to other server instances of said plurality of server instances, wherein said periodically gravitating is based on performance information of said plurality of server instances;

wherein said connections are associated with a connection pool and said connection pool includes at least two connections to a server instance of said plurality of server instances that provides said service; and

wherein said periodically gravitating includes allocating new connections associated with said connection pool to said other server instances;

wherein the method is performed by one or more computing devices.

2. The method of claim 1, further comprising:

in response to a request for a connection to said computing system for requesting said service, selecting a particular connection that is associated with said service, to route a request for performance of work associated with said service;

wherein said selecting is based on substantially current performance information for said server instances that provide said service that is associated with said selected connection.

3. A non-transitory machine-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform:

periodically gravitating connections between server instances of a plurality of server instances that provide a service to other server instances of said plurality of server instances, wherein said periodically gravitating is based on performance information of said plurality of server instances;

wherein said connections are associated with a connection pool and said connection pool includes at least two connections to a server instance of said plurality of server instances that provides said service; and

wherein said periodically gravitating includes allocating new connections associated with said connection pool to said other server instances.

4. The non-transitory machine-readable storage medium of claim 3, said instructions further comprising instructions which, when executed by one or more processors, causes the one or more processors to perform:

in response to a request for a connection to said computing system for requesting said service, selecting a particular connection that is associated with said service, to route a request for performance of work associated with said service;

wherein said selecting is based on substantially current performance information for said server instances that provide said service that is associated with said selected connection.