System and method for improving application connectivity in a clustered database environment

• US 9,064,003 B2
• Filed: 05/05/2014
• Issued: 06/23/2015
• Est. Priority Date: 06/27/2011
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Somogyi, Alexander, Revanuru, Naresh, Felts, Stephen, Zhou, Tong
• Primary Examiner(s): LE, UYEN T
• Application Number:
  US14/270,062
• Publication Number:
  US 20140236948A1
• Time in Patent Office: 414 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/28 Databases characterised by their database models, e.g. relational or object models
• CPC Class Codes: G06F 16/285 Clustering or classification

Abstract

A clustered database environment includes multiple database instances that appear as one server. An application server can use a data source and connection pools to connect with the clustered database. A notification service broadcasts notifications describing state changes in the database instances, which are then used by the data source and connection pools to control access to the database instances. A data source configuration allows for specification of a preferred affinity policy. A session affinity policy is used to provide database instance affinity for database access made under the context of a web session, whereby database operations are directed to a particular instance for a period of time when the application may be performing multiple, related updates to a specific data set. Directing such operations to a single database instance can be used to improve application performance due to increased local cache utilization.

Claims

1. A system for supporting affinity in a clustered database environment, comprising:

one or more computers, each including one or more processors;

a clustered database, which includes a plurality of database instances;

a notification service associated with the clustered database, which broadcasts notifications that describe state changes within the database instances;

an application server associated with a data source,

wherein the data source includes a connection pool that manages a set of connections to the plurality of database instances, and is associated with an affinity policy that defines which, if any, type of affinity will be used by that data source and the connections therein at runtime, to access the clustered database, and

wherein the data source uses the notifications of state changes received from the notification service to adaptively configure connections to the database instances, for use by applications at the application server; and

wherein, upon receiving a connection reserve request from an application to access a selected database instance, the data source

determines the affinity policy associated with the data source,

determines whether there is already an affinity context associated with the application context for the request, and if not then selects a connection for use with the selected database instance,

stores the instance information with the application context for use on the next connection reserve request.

2. The system of claim 1, wherein the affinity context is initialized when a first connection request related to a session is received at the data source, and preserved for the duration of the web session.

3. The system of claim 1, wherein the affinity context includes a name of the clustered database, a name of a database instance, and a service name provided by the database instance.

4. The system of claim 1, wherein the particular type of affinity is one of a data affinity, temporal affinity, and session or session-based affinity policy.

5. The system of claim 1, wherein the connection requests are in a same HTTP session.

6. A method for supporting affinity in a clustered database environment, comprising:

providing a clustered database, which includes a plurality of database instances;

providing a notification service associated with the clustered database, which broadcasts notifications that describe state changes within the database instances;

providing an application server associated with a data source,

wherein the data source includes a connection pool that manages a set of connections to the plurality of database instances, and is associated with an affinity policy that defines which, if any, type of affinity will be used by that data source and the connections therein at runtime, to access the clustered database, and

wherein the data source uses the notifications of state changes received from the notification service to adaptively configure connections to the database instances, for use by applications at the application server; and

upon receiving a connection reserve request from an application to access a selected database instance, the data source

determining the affinity policy associated with the data source,

determining whether there is already an affinity context associated with the application context for the request, and if not then selects a connection for use with the selected database instance,

storing the instance information with the application context for use on the next connection reserve request.

7. The method of claim 6, wherein the affinity context is initialized when a first connection request related to a session is received at the data source, and preserved for the duration of the web session.

8. The method of claim 6, wherein the affinity context includes a name of the clustered database, a name of a database instance, and a service name provided by the database instance.

9. The method of claim 6, wherein the particular type of affinity is one of a data affinity, temporal affinity, and session or session-based affinity policy.

10. The method of claim 6, wherein the connection requests are in a same HTTP session.

11. A non-transitory computer readable storage medium, including instructions stored thereon which when read and executed by one or more computers cause the one or more computers to perform the steps comprising:

providing a clustered database, which includes a plurality of database instances;

providing a notification service associated with the clustered database, which broadcasts notifications that describe state changes within the database instances;

providing an application server associated with a data source,

wherein the data source includes a connection pool that manages a set of connections to the plurality of database instances, and is associated with an affinity policy that defines which, if any, type of affinity will be used by that data source and the connections therein at runtime, to access the clustered database, and

wherein the data source uses the notifications of state changes received from the notification service to adaptively configure connections to the database instances, for use by applications at the application server; and

upon receiving a connection reserve request from an application to access a selected database instance, the data source

determining the affinity policy associated with the data source,

determining whether there is already an affinity context associated with the application context for the request, and if not then selects a connection for use with the selected database instance,

storing the instance information with the application context for use on the next connection reserve request.

12. The non-transitory computer readable storage medium of claim 11, wherein the affinity context is initialized when a first connection request related to a session is received at the data source, and preserved for the duration of the web session.

13. The non-transitory computer readable storage medium of claim 11, wherein the affinity context includes a name of the clustered database, a name of a database instance, and a service name provided by the database instance.

14. The non-transitory computer readable storage medium of claim 11, wherein the particular type of affinity is one of a data affinity, temporal affinity, and session or session-based affinity policy.

15. The non-transitory computer readable storage medium of claim 11, wherein the connection requests are in a same HTTP session.