AU2005323039B2 - Multipool manager - Google Patents
Multipool manager Download PDFInfo
- Publication number
- AU2005323039B2 AU2005323039B2 AU2005323039A AU2005323039A AU2005323039B2 AU 2005323039 B2 AU2005323039 B2 AU 2005323039B2 AU 2005323039 A AU2005323039 A AU 2005323039A AU 2005323039 A AU2005323039 A AU 2005323039A AU 2005323039 B2 AU2005323039 B2 AU 2005323039B2
- Authority
- AU
- Australia
- Prior art keywords
- multipool
- connection
- manager
- pools
- pool
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F15/00—Digital computers in general; Data processing equipment in general
- G06F15/16—Combinations of two or more digital computers each having at least an arithmetic unit, a program unit and a register, e.g. for a simultaneous processing of several programs
- G06F15/163—Interprocessor communication
- G06F15/173—Interprocessor communication using an interconnection network, e.g. matrix, shuffle, pyramid, star, snowflake
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/50—Allocation of resources, e.g. of the central processing unit [CPU]
- G06F9/5005—Allocation of resources, e.g. of the central processing unit [CPU] to service a request
- G06F9/5027—Allocation of resources, e.g. of the central processing unit [CPU] to service a request the resource being a machine, e.g. CPUs, Servers, Terminals
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/50—Allocation of resources, e.g. of the central processing unit [CPU]
- G06F9/5005—Allocation of resources, e.g. of the central processing unit [CPU] to service a request
- G06F9/5027—Allocation of resources, e.g. of the central processing unit [CPU] to service a request the resource being a machine, e.g. CPUs, Servers, Terminals
- G06F9/505—Allocation of resources, e.g. of the central processing unit [CPU] to service a request the resource being a machine, e.g. CPUs, Servers, Terminals considering the load
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04J—MULTIPLEX COMMUNICATION
- H04J3/00—Time-division multiplex systems
- H04J3/22—Time-division multiplex systems in which the sources have different rates or codes
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L12/00—Data switching networks
- H04L12/66—Arrangements for connecting between networks having differing types of switching systems, e.g. gateways
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2209/00—Indexing scheme relating to G06F9/00
- G06F2209/50—Indexing scheme relating to G06F9/50
- G06F2209/5011—Pool
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Signal Processing (AREA)
- Computer Networks & Wireless Communication (AREA)
- Computer Hardware Design (AREA)
- Multimedia (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Hardware Redundancy (AREA)
- Stereo-Broadcasting Methods (AREA)
- Compression Or Coding Systems Of Tv Signals (AREA)
Description
P.\OPERUUC\2009\DccmbcrUO05 9 I spdocm.23/I2/20 00 -1- SMULTIPOOL MANAGER Field of Invention The present invention relates to a multipool system to connect to database instances.
Background of Invention t Application servers, such as the WebLogicTM Server available from BEA Systems of San SJose, California, allow users to do a number of functions. One of the functions typically supported by application servers is to provide access to a database. In one embodiment, a connection pool such as a Java Database Connectivity (JDBC) connection pool is provided by the application server. The connection pool provides a number of already set up connections with a database. These connections are provided to applications of the application server as needed. Such connection pools allow for a relatively large number of applications in the application server to access a database while reducing the database connection time for the application.
It is generally desirable to overcome or ameliorate one or more of the above described difficulties, or to at least provide a useful alternative.
Summary of Invention In accordance with one aspect of the present invention, there is provided a multipool system to connect to database instances comprising: multiple connection pools, the connection pools adapted to provide connections to database instances; a multipool manager adapted to select and set up connections to a database instance through a connection pool, the multipool manager adapted to keep track of dead and busy connection pools between requests for connections; and multiple applications, the applications adapted to use the connection pools selected by the multipool manager to connect to the database instances; wherein the multipool manager is adapted to obtain authorization from the applications, by calling a callback interface, before switching connection pools.
P.\OPRRWUV\208\Da bcN\DO533039I padoc23/12/2003 00
O
C-2- In accordance with another aspect of the present invention, there is provided a multipool system to connect to database instances comprising: multiple connection pools, the connection pools adapted to provide connections to C database instances; In) a multipool manager adapted to select and set up connections to a database instance O through a connection pool, the multipool manager adapted to keep track of dead and busy connection pools and to asynchronously test whether a connection pool is revived; and multiple applications, the applications adapted to use the connection pools selected by the multipool manager to connect to the database instances; wherein the multipool manager is adapted to obtain authorization from the applications, by calling a callback interface, before switching connection pools.
Brief Description of the Drawings Preferred embodiments of the present invention are hereafter described, by way of nonlimiting example only, with reference to the accompanying drawings, in which: Figure 1 is a diagram illustrating the use of a multipool with a multipool manager of one embodiment.
Figures 2A-2B are diagrams illustrating the use of a multipool manager having an active connection pool list.
Figures 3A-3B are flowcharts that illustrate the use of an active connection pool list of one embodiment.
Figure 4 is a diagram illustrating the operation of a multipool manager of one embodiment of the present invention.
P. OPER\ C%208\Ekcba00 10323 I spdoc-23/12fl008 00 2a Figures 5A-5B are diagrams that illustrate the use of callbacks with a multipool manager of embodiments of the present invention.
O 5 Figure 6 is a flowchart illustrating the use of callbacks with a multipool manager of one C embodiment of the present invention.
Detailed Description of Preferred Embodiments of the Invention Multipools using Automatically Maintained Active Connection Pool List Figure 1 is a diagram that illustrates the operation of a multipool manager 102. In some systems, it is desired to have multiple database instances, such as database instances 104 and 106. The database instances 104 and 106 can each contain a current version of a database run on independent machines, for example. When there are multiple database instances, it can be desirable to use multiple connection pools, such as connection pool 108 and connection pool 110. Rather than dedicating each application, such as applications 112, 114 and 116, to a single connection pool and thus to a single database instance, a multipool system can be used. In a multipool system, a multipool manager 102 can determine which connection pool to use to obtain a connection for an application into the database system.
Diffferent methods for selecting a connection pool are possible. One selection method has a primary connection pool and a backup connection pool. The connections are first attempted at a primary connection pool and then upon failure event, the connections are then sent through a backup connection pool. Another method is a load balancing method where the connections are distributed between multiple connection pools to balance the load at the different connection pools. A round-robin method is an example of a load balancing method.
One embodiment of the present invention comprises a multipool system to connect to database instances comprising multiple connection pools 202 and 204. The connection P: OPER\JUC200\Decmber\2005323039 I spa doc.23/12/200 2b pools 202 and 204 are adapted to provide connections to database instances 206 and 208.
A multipool manager 210 is adapted to select and set up connections to a database instance through a connection pool. The multipool manager 210 is adapted to keep track of dead connection pools between requests for connections.
WO 2006/073865 PCT/US2005/046581 3 The multipool manager 210 can select a connection pool in a manner that avoids any dead connection pools. For the example of figure 2A, the multipool manager can avoid selecting connection pool A if it is dead. In one embodiment, a selection of only non-dead connection pools is done as authorized by an application. In one embodiment, the application indicates by a callback or by configuration info whether to switch connection pools.
The multipool manager 210 can be adapted to maintain a list 212 of active connection pools and to use the list 212 to determine what connection pool to connect through. The term "list" is not meant to imply any specific data structure. The active connection pools on the list can include those connection pools that are not those connection pools determined by the multipool manager to be dead.
Dead connection pools can be tested in the background to see whether they should be returned to the active connection pool list. The list of active connection pools can be a subset of a candidate list provided by an application. Alternatively, separate candidate lists and active lists can be maintained, and the multipool manager can select a connection pool that is on both lists. The multipool manager 210 can store an indication for each connection pool associated with the candidate list indicating whether the connnection pool is active or dead.
In example of figure 2A, the connection pool A is dead, thus not on the active connection pool list 212. An application, such as an application 220, can request a connection into one of the database instances 206 or 208 through the multipool manager 210.
In Figure 2A, the multipool manager 210 selects a connection through the connection pool
B.
The multipool manager 210 can test whether a connection pool has been revived in the background asynchronously. In one embodiment, an asychronous background test module 214 can be used.
Figure 2B illustrates an example of this background testing. In this example, a SQL test query is sent to the dead connection pool A. If the correct answer is obtained from the database instance 206, the multipool manager 210 can update the active connection pool list 212 with an indication of the connection pool A. In this way, the next time an application requests a connection to a database, a connection through the connection pool A is possible.
Figure 3B illustrates a flowchart illustrating the asynchronous testing of a dead connection pools. In one embodiment, preset wait time passes in step 300. The wait time WO 2006/073865 PCT/US2005/046581 4 can be set by an application and stored with the configureation information for the multipool manager or a default value can be used In step 302, the dead connection pool is tested. If the dead connection pool has revived as indicated by the test, the active connection pool list 306 is updated, otherwise, the cycle repeats waiting the preset time in step 300.
Figure 3A illustrates the operation of the request for a connection to a database in one embodiment. In step 308, a request for connection to the database is received at a multipool manager. In step 310, the multipool manager can select a connection pool. In one embodiment, the multipool manager 210 selects a connection pool on an active connection pool list. The connection can then be attemped. In step 312, it is checked whether the connection pool is dead. If the connection pool is dead, in step 314, the active connection pool list is updated and new connection pool is selected from the active pool list. If the connection pool is not dead, in step 315, it is checked to see whether the connection pool is full. If there is no available connections, then the multipool manager can select another connection pool from the active connection pool list, in step 310. If any selected connection pool is not dead or full, then, in step 316, the connection is done through the selected connection pool.
Figure 4 is a flowchart illustrating different conditions that can occur in one embodiment of the present invention. In step 402, a request for a connection to the database is received at a multipool manager. In step 404 a multipool manager selects a connection pool from the active pool list. Its possible, as determined in step 408, that the selected connection pool is a newly revived connection pool. If so, this is called a failback as indicated in step 410. In step 412, it is checked whether the connection pool is dead. If a connection pool is dead, the active connection pool list is updated in step 414, and in step 416, another connection pool is selected from the active connection pool list, this is called a failover condition. In step 418, if the connection pool is not dead it is checked to see whether the connection pool is full. If the connection pool is full, in step 420, it is checked to see whether a spillover is allowed. If it is, in step 422 another connection pool is selected from the active connection pool list. Step 424, shows a connection is made. As described below an application may authorize a failback, failover or spillover condition with a callback or with config information.
One embodiment of the present invention is a multipool manager adapted to select and set up connections to a database instance through a connection pool. The multipool WO 2006/073865 PCT/US2005/046581 manager is adapted to keep track of dead connection pools. The multipool manager implements a selection method in which the multipool manager avoids selecting dead connection pools to provide a connection for an appplication.
One embodiment of the present invention is a multipool system to connect to database instances comprising multiple connection pools. The connection pools are adapted to provide connections to database instances. A multipool manager is adapted to select and set up connections to a database instance through a connection pool. The multipool manager is adapted to keep track of dead connection pools and to asynchronously test whether a connection pool is revived.
Callback Interface for Multipools In some instances it is desirable to check with the application before switching the connection pool. Switching a connection pool can be a complicated process. Sometimes there are preferred database instances and it is not desired that the user switch to another less desirable database instance unless the first database instances are truly unavailable. In one embodiment of the present invention, the multipool manager implements callbacks to an application in order to get authorization from the application for a switch of connection pools.
In one embodiment of the present invention, a multipool system is used to connect to database instances with multiple connection pools. The connection pools 502 and 504 are adapted to provide connections to database instances 508 and 510. A multipool manager 506 is adapted to select and set up connections to a database instance through a connection pool.
The multipool manager 506 is adapted to check with an application 512 before switching connection pools.
In the example of figure 5A, a callback is available from the multipool manager 506 to the application 512. If the connection pool is to be switched, the multipool manager 506 can do a callback to the application 512 to determine whether the application will authorize the switch. In example of figure 5A, the active connection pool list includes connection pool B but not connection pool A. Before switching to connection pool B the multipool pool manager 506 can do a callback to the application 512. In one embodiment, in step 1 a request for connection is received by the multipool manager 506. In step 2, after the multipool manager determines that a connection pool switch may be desirable, a callback is WO 2006/073865 PCT/US2005/046581 6 done to the application 512. The callback can be, for example, the calling of the callback method 514 which is part of the application 512. The multipool manager 506 can store configuration information 506a which may include an indication of what conditions the callback is to be sent and/or an indication of the callback method name, in this case, callback method A. The application code can implement a callback method 514 in any manner. In one embodiment, a callback response is received by the multipool manager in step 3. The callback response can be an indication which multipool manager 506 can use to determine how to connect.
In one embodiment, the callback response indications include an "OK" indication.
When the "OK" indication is received, the multipool manager switches to the new connection pool. Another callback response indication is a "retry" indication. If a "retry" indication is received, the multipool manager 506 can attempt to get a connection with the old connection pool. Another possible callback response indication is a "don't reconnect" indication. When a "don't reconnect" indication is received the multipool manager not attempt to make a connection.
Figure 5B illustrates a possible reason that a "retry" indication might be provided by the callback method. In one example, it may be desirable to do a certain number of attempts onto a primary database instance before switching over to a secondary database instance.
Figure 5B i'nistrates an example in which an independent ping is done from the application 512 to the database iiistie_ 508 as part of the callback method. If the independent ping comes up with an indication that the database instance 508 is still running, the application can send a "retry" indication. If the application 512 is sufficiently convinced that the database instance is down, a "OK" callback response can be sent.
Any callback method can be implemented by the application 512. In one example, the multipool manager has a callback interface that can be implemented by any application code.
Figure 6 is a diagram illustrating the operation of callbacks of one embodiment. In step 602, it is checked if the connection pool is to te switched as determined by the multipool manager. If the connect pool is not to be switched,1 the connection is done to the connection pool in step 604. If the connection is to be switched, then in step 606, it is checked whether a callback is indicated for the condition. If no callback is indicated, then the connection is done through the new connection pool without a callback. If a callback is indicated, in step WO 2006/073865 PCT/US2005/046581 7 610, a callback is done. If an "OK" indication is received, the connection is done with the new connection pool in step 614. If a retry indication is received, a connection is attempted to be done using the old connection pool, in step 616. Otherwise, if a "don't reconnect" indication is received, no connection through a connection pool is done in Step 618.
In one embodiment, a multipool manager is adapted to select and set up connections to a database instance through a connection pool. The multipool manager is adapted to check with an application before switching connection pools.
Detailed Description of One Non-Limiting Example The following description gives one non-limiting implementation of multipool implementation. The discussion below gives one embodiment, but those skilled in the art will understand that other implementations of the above-described concepts can be done.
Any potentially limitating language given below is to be interpreted in the context of the specific non-limiting implementation and is not meant to limit the general concepts.
MultiPools can check with the application before failing over to alternate Pools. This is useful if the configured test for the Pool currently in use encounters a random or transient failure, if the application wants to control when a Database Management System (DBMS) instance that's currently not handling clients is brought back into service or if applications can specified an identity when getting connections from Pools, and connections from a matching pool should be returned. This is useful in cases where the DBMS vendor does not provide native support for setting client identities on anonymous JDBC connections.
A number of improvements can be implemented for multipools.
FAILOVER Existing MultiPool algorithm "HIGH_AVAILABILITY" will be renamed as "FAILOVER". It will also optionally provide the ability to route application requests for connections to alternative Pools if the current Pool is busy.
HEALTH Existing functionality will be improved to mark dead Pools so that application requests for connections are not routed to these Pools.
CALLBACK A callback interface will be provided to applications to control MultiPool decision to failover to alternative Pools when a failed Pool is detected, or to fail back to Pools previously marked dead.
Applications can configure a FAILOVER algorithm. FAILOVER can have connections sent through a primary connection pool and have these connections routed WO 2006/073865 PCT/US2005/046581 8 through a secondary connection pool upon the failure of the primary connection pool.
FAILOVER can optionally also be able to route application requests for connections to alternative Pools if the current Pool is busy.
In one embodiment, applications will also be able to configure the following MultiPool attribute: If set, application requests for connections will be routed to alternate pools if current pool is busy. This is only relevant when running with the HIGH_ALGORITHM algorithm. Default implies feature is disabled.
@param newVal The new attribute value @dynamic @default false public boolean isFailoverRequestIfBusy(); public void setFailoverRequestIfBusy(boolean failoverRequestIfBusy); Applications can be able to implement and register a callback with the system. This callback can be invoked when the MultiPool detects a dead or busy Pool, giving application the ability to control whether MultiPool fails over to an alternative Pool or not.
In one embodiment, applications will be able to implement the following interface: Application can optionally implement this interface if it wants to control the failover behavior of WebLogic Server MultiPools.
If application has registered a class with WebLogic Server that implements this interface, WebLogic Server will invoke this interface's WO 2006/073865 WO 206/03865PCTIUS2005/046581 9 method "lallowPoolFailoveroll and take different actions depending upon the return code from the method's invokation.
ee weblogic .management configuration.JDBCMultiPoolMBeanl~setConnectionPoolFail overCal lbackHandler public interface ConnectionPoolFailoverCailback /name of this interface static public final String IF-NAME- "weblogic j dbc. extensions .ConnectionPoolFailoverCallback"; opcodes for method lallowPoolFailover() static public final mnt OPCODECURRPOOLDEAD 0; static public final mnt OPCODECURRFOOLBUSY 1; static public final mnt OPCODEREENABLECURRPOOL 2; return codes for method lallowPoolFailover() static public final mnt OK 0; application is ok with impending action static public final mnt RETRYCURRENT 1; retry current pool static public final int DONUT -FAILOVER 2; do not failover, WLS will throw weblogic. jdbc .extensions. PoolUnavailableSQLException MultiPc'ol will invoke this method under various failover/failback conditions. Application should return one of the above-defined codes from this method, based upon application-specific semantics.
WO 2006/073865 PCT/US2005/046581 @param will currPool name of connection pool currently in use.
NEVER be null 1 @param will nextPool name of alternate connection pool.
be null for opcode 'OPCODE REENABLE CURR POOL' @param opcode operation being performed OPCODE CURR POOL DEAD 'currPool' is Dead, MultiPool needs to failover application requests for connections to 'nextPool'.
Application should return "RETRY CURRENT" "DONOT FAILOVER", depending on what it wants the MultiPool to do.
OPCODE_CURR_POOL_BUSY 'currPool' is Busy, MultiPool needs to re-route application requests for connections to 'nextPool' Application should return "OK" if it is ok with this action, else should return either of the other return codes.
OPCODE_REENABLE_CURRPOOL 'currPool' was previously found Dead and was consequently disabled. It has now been found healthy, and MultiPool needs to re-enable it.
Application should return "OK" if it is ok with this action, else should return either of the other return codes.
WO 2006/073865 PCT/US2005/046581 11 public int allowPoolFailover(String currPool, String nextPool, int opcode); Application can register this callback in the attribute "ConnectionPoolFailoverCallbackHandler" of JDBCMultiPoolMBean.
Used to set the absolute name of the application class that implements the interface weblogic.jdbc.extensions.ConnectionPoolFailoverCallback.
@see weblogic.jdbc.extensions.ConnectionPoolFailoverCallback @non-dynamic public String getConnectionPoolFailoverCallbackHandler(); public void setConnectionPoolFailoverCallbackHandler(String className); Multipools can be enhanced to internally monitor and track the health of the Pools underneath. If a Pool is determined to be dead, it will be marked so and subsequent application requests for connections will not be routed to that Pool.
In one embodiment, applications will be able to configure the following JDBCMultiPoolMBean attribute: Used to configure the frequency at which the MultiPool checks the health of connection pools that were previously found dead and were consequently disabled.
@param newVal The new attribute value WO 2006/073865 PCT/US2005/046581 12 @dynamic @default 300 void setHealthCheckFrequencySeconds(int newVal); int getHealthCheckFrequencySeconds() Embodiments may be implemented using a conventional general purpose or a specialized digital computer or microprocessor(s) programmed according to the teachings of the present disclosure, as will be apparent to those skilled in the computer art. Appropriate software coding can readily be prepared by skilled programmers based on the teachings of the present disclosure, as will be apparent to those skilled in the software art. The invention may also be implemented by the preparation of integrated circuits or by interconnecting an appropriate network of conventional component circuits, as will be readily apparent to those skilled in the art.
One embodiment includes a computer program product which is a storage medium (media) having instructions stored thereon/in which can be used to program a computer to perform any of the features presented herein. The storage medium can include, but is not limited to, any type of disk including floppy disks, optical discs, DVD, CD-ROMs, micro drive, and magneto-optical disks, ROMs, Rams, EPROM's, EPROM's, Drams, Rams, flash memory devices, magnetic or optical cards, Nan systems (including molecular memory ICs), or any type of media or device suitable for storing instructions and/or data.
Stored on any one of the computer readable medium (media), the present invention includes software for controlling both the hardware of the general purpose/specialized computer or microprocessor, and for enabling the computer or microprocessor to interact with a human user or other mechanism utilizing the results of the present invention, Such software may include, but is not limited to, device drivers, operating systems, execution environments/containers, and user applications.
The foregoing description of preferred embodiments of the present invention has been provided for the purposes of illustration and description. It is not intended to be exhaustive or to limit the invention to the precise forms disclosed. Many modifications and variations will P:OPER\IC2OOSXDobs )\2005323O39 I spa doc-23/1212008 00 -13be apparent to one of ordinary skill in the relevant arts. For example, steps performed, in the embodiments of the invention disclosed can be performed in alternate orders, certain steps can be omitted, and additional steps can be added. The embodiments were chosen and described in order to best explain the principles of the invention and its practical application, thereby enabling others skilled in the art to understand the invention for N various embodiments and with various modifications that are suited to the particular use contemplated. It is intended that the scope of the invention be defined by the claims and their equivalents.
Throughout this specification and the claims which follow, unless the context requires otherwise, the word "comprise", and variations such as "comprises" and "comprising"', will be understood to imply the inclusion of a stated integer or step or group of integers or steps but not the exclusion of any other integer or step or group of integers or steps.
The reference in this specification to any prior publication (or information derived from it), or to any matter which is known, is not, and should not be taken as an acknowledgment or admission or any form of suggestion that that prior publication (or information derived from it) or known matter forms part of the common general knowledge in the field of endeavour to which this specification relates.
Claims (17)
1. A multipool system to connect to database instances comprising: multiple connection pools, the connection pools adapted to provide connections to 5 database instances; a multipool manager adapted to select and set up connections to a database instance f through a connection pool, the multipool manager adapted to keep track of dead and busy connection pools between requests for connections; and multiple applications, the applications adapted to use the connection pools selected by the multipool manager to connect to the database instances; wherein the multipool manager is adapted to obtain authorization from the applications, by calling a callback interface, before switching connection pools.
2. The multipool system of claim 1, wherein the multipool manager tests whether a connection pool has revived.
3. The multipool system of claim 2, wherein the test is done in the background asynchronously.
4. The multipool system of claim 2, wherein the test is done periodically with a time period that can be set by an application.
The multipool system of claim 1, wherein the multipool manager sends connections through a primary connection pool preferentially.
6. The multipool system of claim 5, wherein there is spillover to a secondary connection pool.
7. The multipool system of claim 1, wherein the multipool manager load balances connections through multiple connection pools. P: OPERUC\28\IDkrccmbaO05323039 I wpdo-2/I009 00 O O
8. The multipool system of claim 1, wherein callback configuration information is registered with multipool system.
9. The multipool system of claim 1, wherein the multipool manager maintains a list of O 5 active connection pools and uses the list to determine what connection pool to CN connect through.
A multipool system to connect to database instances comprising: multiple connection pools, the connection pools adapted to provide connections to database instances; a multipool manager adapted to select and set up connections to a database instance through a connection pool, the multipool manager adapted to keep track of dead and busy connection pools and to asynchronously test whether a connection pool is revived; and multiple applications, the applications adapted to use the connection pools selected by the multipool manager to connect to the database instances; wherein the multipool manager is adapted to obtain authorization from the applications, by calling a callback interface, before switching connection pools.
11. The multipool system of claim 10, wherein the multipool manager sends connections through a primary connection pool preferentially.
12. The multipool system of claim 1, wherein if an "OK" indication is returned from the callback interface, the multipool manager switches connection pools.
13. The multipool system of claim 1, wherein if a "retry" indication is returned from the callback interface, the multipool manager does not switch connection pools and retries the original connection pool. P:OPER\RJC\2008\Dccmbr2005323039 I spldoc-23/12/2008 00 O O-16-
14. The multipool system of claim 1, wherein if a "don't reconnect" indication is returned from the callback interface, the multipool manager does not switch connection pools and does not retry the original connection pool. O 5
15. The multipool system of claim 1, wherein the multipool manager checks with the CN applications before a failover.
16. The multipool system of claim 1, wherein the multipool manager checks with the applications before a failback.
17. A multipool system to connect to database instances substantially as hereinbefore described, with reference to the accompanying drawings.
Applications Claiming Priority (7)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| US64044904P | 2004-12-31 | 2004-12-31 | |
| US60/640,449 | 2004-12-31 | ||
| US11/294,214 | 2005-12-05 | ||
| US11/294,147 US20060146877A1 (en) | 2004-12-31 | 2005-12-05 | Multipool using automatically maintained active connection pool list |
| US11/294,214 US7761502B2 (en) | 2004-12-31 | 2005-12-05 | Callback interface for multipools |
| US11/294,147 | 2005-12-05 | ||
| PCT/US2005/046581 WO2006073865A2 (en) | 2004-12-31 | 2005-12-21 | Multipool manager |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| AU2005323039A1 AU2005323039A1 (en) | 2006-07-13 |
| AU2005323039B2 true AU2005323039B2 (en) | 2009-01-15 |
Family
ID=36647997
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| AU2005323039A Active AU2005323039B2 (en) | 2004-12-31 | 2005-12-21 | Multipool manager |
Country Status (5)
| Country | Link |
|---|---|
| EP (1) | EP1844395A4 (en) |
| JP (1) | JP2008525916A (en) |
| KR (1) | KR20070110011A (en) |
| AU (1) | AU2005323039B2 (en) |
| WO (1) | WO2006073865A2 (en) |
Families Citing this family (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP6256904B2 (en) | 2013-04-18 | 2018-01-10 | インターナショナル・ビジネス・マシーンズ・コーポレーションＩｎｔｅｒｎａｔｉｏｎａｌ Ｂｕｓｉｎｅｓｓ Ｍａｃｈｉｎｅｓ Ｃｏｒｐｏｒａｔｉｏｎ | Apparatus and method for distributing processing requests |
| US9268798B2 (en) | 2013-04-26 | 2016-02-23 | Oracle International Corporation | Support for cloud-based multi-tenant environments using connection labeling |
| US9720970B2 (en) | 2013-06-06 | 2017-08-01 | Oracle International Corporation | Efficient storage and retrieval of fragmented data using pseudo linear dynamic byte array |
| US9785687B2 (en) | 2013-06-06 | 2017-10-10 | Oracle International Corporation | System and method for transparent multi key-value weighted attributed connection using uni-tag connection pools |
| US9747341B2 (en) | 2013-06-06 | 2017-08-29 | Oracle International Corporation | System and method for providing a shareable global cache for use with a database environment |
| US9600546B2 (en) | 2013-06-06 | 2017-03-21 | Oracle International Corporation | System and method for marshaling massive database data from native layer to java using linear array |
| US9569472B2 (en) | 2013-06-06 | 2017-02-14 | Oracle International Corporation | System and method for providing a second level connection cache for use with a database environment |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040221031A1 (en) * | 2003-04-29 | 2004-11-04 | Oracle International Corporation | Method and apparatus using connection pools in communication networks |
| US20040250248A1 (en) * | 2003-02-24 | 2004-12-09 | Halpern Eric M. | System and method for server load balancing and server affinity |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6173311B1 (en) * | 1997-02-13 | 2001-01-09 | Pointcast, Inc. | Apparatus, method and article of manufacture for servicing client requests on a network |
| US6199110B1 (en) * | 1997-05-30 | 2001-03-06 | Oracle Corporation | Planned session termination for clients accessing a resource through a server |
| JP3518292B2 (en) * | 1997-12-02 | 2004-04-12 | 日本電気株式会社 | Client server system |
-
2005
- 2005-12-21 JP JP2007549495A patent/JP2008525916A/en active Pending
- 2005-12-21 AU AU2005323039A patent/AU2005323039B2/en active Active
- 2005-12-21 KR KR1020077017651A patent/KR20070110011A/en not_active Application Discontinuation
- 2005-12-21 WO PCT/US2005/046581 patent/WO2006073865A2/en active Application Filing
- 2005-12-21 EP EP05855184A patent/EP1844395A4/en not_active Withdrawn
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040250248A1 (en) * | 2003-02-24 | 2004-12-09 | Halpern Eric M. | System and method for server load balancing and server affinity |
| US20040221031A1 (en) * | 2003-04-29 | 2004-11-04 | Oracle International Corporation | Method and apparatus using connection pools in communication networks |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2006073865A2 (en) | 2006-07-13 |
| WO2006073865A3 (en) | 2006-08-31 |
| JP2008525916A (en) | 2008-07-17 |
| EP1844395A4 (en) | 2009-08-05 |
| EP1844395A2 (en) | 2007-10-17 |
| KR20070110011A (en) | 2007-11-15 |
| AU2005323039A1 (en) | 2006-07-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7761502B2 (en) | Callback interface for multipools | |
| AU2005323039B2 (en) | Multipool manager | |
| CN1754146B (en) | System and method for server load balancing and server affinity | |
| US10178184B2 (en) | System and method for session handling in a multitenant application server environment | |
| US7260818B1 (en) | System and method for managing software version upgrades in a networked computer system | |
| JP6047564B2 (en) | System and method for providing improved session affinity and connectivity in a clustered database environment | |
| JP3851272B2 (en) | Stateful program entity workload management | |
| JP6615796B2 (en) | System and method for partition migration in a multi-tenant application server environment | |
| US7426661B2 (en) | Method and system for minimizing loss in a computer application | |
| US20080244552A1 (en) | Upgrading services associated with high availability systems | |
| US20050262495A1 (en) | Administration mode for server applications | |
| TWI511046B (en) | Dynamic cli mapping for clustered software entities | |
| US6990602B1 (en) | Method for diagnosing hardware configuration in a clustered system | |
| US11184432B2 (en) | System and method for dynamic auto-scaling based on roles | |
| WO2003014956A1 (en) | Grouping services in a distributed computing application | |
| US7165097B1 (en) | System for distributed error reporting and user interaction | |
| US20050262494A1 (en) | Production redeployment through application versioning | |
| US8015432B1 (en) | Method and apparatus for providing computer failover to a virtualized environment | |
| US20190097895A1 (en) | System and method for dynamic auto-scaling based on roles | |
| US20180081673A1 (en) | System and method for handling lazy deserialization exceptions in an application server environment | |
| US20040162807A1 (en) | Cooperative, simultaneous operation on data by many processes, with concurrent retention of process status, resumed processing, and minimal consumption of inter-nodal throughput | |
| US20070011328A1 (en) | System and method for application deployment service | |
| Birman et al. | Overcoming the ‘d’in cap: Using isis2 to build locally responsive cloud services | |
| Almeida | Dynamic reconfiguration of object-middleware-based distributed systems | |
| CN101460921A (en) | Next generation clustering |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| FGA | Letters patent sealed or granted (standard patent) | ||
| PC | Assignment registered |
Owner name: ORACLE INTERNATIONAL CORPORATION Free format text: FORMER OWNER WAS: BEA SYSTEMS, INC. |