SYSTEM AND METHOD FOR USING A GRIDLINK DATA SOURCE TO CONNECT AN APPLICATION SERVER WITH A CLUSTERED DATABASE

• US 20120066363A1
• Filed: 06/24/2011
• Published: 03/15/2012
• Est. Priority Date: 09/15/2010
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Revanuru, Naresh, Irudayaraj, Rajkumar, Felts, Stephen, Somogyi, Alex, Zhou, Tong, Zhao-Perez, Frances
• Granted Patent: US 9,092,460 B2
• Time in Patent Office: Days
• US Class Current: 709/223
• CPC Class Codes: G06F 15/17318 Parallel communications techniques, e.g. gather, scatter, reduce, roadcast, multicast, all to all
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/278 Data partitioning, e.g. horizontal or vertical partitioning
• CPC Class Codes: G06F 9/45504 Abstract machines for programme code execution, e.g. Java virtual machine [JVM], interpreters, emulators
• CPC Class Codes: H04L 41/042 comprising distributed management centres cooperatively managing the network
• CPC Class Codes: H04L 41/0686 Additional information in the notification, e.g. enhancement of specific meta-data
• CPC Class Codes: H04L 49/358 Infiniband Switches
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]
• CPC Class Codes: H04L 67/10 in which an application is distributed across nodes in the network software deployment G06F8/60; multiprogramming arrangements G06F9/46
• CPC Class Codes: H04L 67/1001 for accessing one among a plurality of replicated servers
• CPC Class Codes: H04L 67/1004 Server selection for load balancing
• CPC Class Codes: H04L 67/1027 Persistence of sessions during load balancing
• CPC Class Codes: H04L 67/1034 Reaction to server failures by a load balancer
• CPC Class Codes: H04L 67/1095 Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
• CPC Class Codes: H04L 67/14 Session management for real-time applications in data packet communications networks H04L65/1066
• CPC Class Codes: H04L 67/142 Managing session states for stateless protocols; Signalling session states; State transitions; Keeping-state mechanisms
• CPC Class Codes: H04L 67/146 Markers for unambiguous identification of a particular session, e.g. session cookie or URL-encoding
• CPC Class Codes: H04L 69/14 Multichannel or multilink protocols
• CPC Class Codes: Y10T 409/308904 : Multiple row dividing head
• CPC Class Codes: Y10T 409/309072 : including cutter limited to rotary motion
• CPC Class Codes: Y10T 409/309128 : with means to adjust work support vertically
• CPC Class Codes: Y10T 409/309352 : Cutter spindle or spindle support
• CPC Class Codes: Y10T 409/309408 : with cutter holder

Abstract

A system and method can support using a data source to connect an application server with a clustered database. The clustered database includes a plurality of database instances and is associated with a notification service. The notification service can be used by the clustered database to broadcast notifications that describe a state change in the plurality of database instances. The data source includes a connection pool, which manages a set of connections to the plurality of database instances in the clustered database. The data source operates to register with the notification service to receive notifications on the change of the clustered database, wherein the application server operates to configure and manage connection to the clustered database, adaptively according to the state change of the clustered database at run time.

Claims

1. A system to support connecting an application server with a clustered database, comprising:

a notification service associated with a plurality of database instances in the clustered database, wherein the notification service is used by the clustered database to broadcast notifications that describe a state change in the clustered database; and

a data source associated with the application server, wherein data source is associated with a connection pool, which manages a set of connections to the plurality of database instances in the clustered database, and

wherein the data source operates to register with the notification service to receive notifications on the change of the clustered database, wherein the application server operates to configure and manage connection to the clustered database, adaptively according to the state change of the clustered database at run time.

2. The system according to claim 1, wherein:

the state change of the clustered database includes one of;

one or more database instances have been stopped or taken out by an unplanned outage, and

a database instance is added in or restarted after an outage.

3. The system according to claim 1, wherein:

the data source provides database fast connection failover capabilities and responds to database service events to ensure each said connection to a database instance is valid.

4. The system according to claim 1, wherein:

the data source operates to use metrics to monitor actions taken by the application server.

5. The system according to claim 1, wherein:

the data source operates to poll the set of connections to the plurality of database instances in the clustered database as an alternative to the notification service.

6. The system according to claim 1, wherein:

the data source operates to receive notifications from the notification service that contain load balancing advisory events.

7. The system according to claim 1, further comprising:

the data source ensures that all database operation within context of a global transaction are directed to a same database instance.

8. The system according to claim 1, further comprising:

the data source supports a graceful shut down operation of a targeted database instance in the clustered database.

9. The system according to claim 8, wherein:

the data source allows any in progress transactions to complete before closing and recreating one or more physical connections.

10. The system according to claim 8, wherein:

the data source cleans up idle connections so that new requests for connections are not sent to the targeted database instance in the clustered database.

11. A method for supporting connecting an application server to a clustered database, comprising:

providing a notification service that is associated with a plurality of database instances in the clustered database, wherein the notification service is used by the clustered database to broadcast notifications that describe a state change in the clustered database; and

providing a data source associated with the application server, wherein data source is associated with a connection pool, which contains a set of connections to the plurality of database instances in the clustered database, and

allowing the data source to register with the notification service to receive notifications on the change of the clustered database, wherein the application server operates to configure and manage connection to the clustered database, adaptively according to the state change of the clustered database at run time.

12. A machine readable medium having instructions stored thereon that when executed cause a system to:

providing a notification service that is associated with a plurality of database instances in a clustered database, wherein the notification service is used by the clustered database to broadcast notifications that describe a state change in the clustered database; and

providing a data source associated with an application server, wherein data source is associated with a connection pool, which contains a set of connections to the plurality of database instances in the clustered database, and

allowing the data source to register with the notification service to receive notifications on the change of the clustered database, wherein the application server operates to configure and manage connection to the clustered database, adaptively according to the state change of the clustered database at run time.