System and method for high availability and load balancing in a database environment

Patent metadata

Field	Value
Publication number	US-10909088-B2
Application number	US-201815912861-A
Country	US
Kind code	B2
Filing date	Mar 6, 2018
Priority date	Sep 6, 2017
Publication date	Feb 2, 2021
Grant date	Feb 2, 2021

Abstract

In accordance with an embodiment, described herein is a system and method for high availability and load balancing in a database environment. A transparency engine can be provided between client applications and a database, and can operate as a proxy engine for the database and as a session abstraction layer for the client applications, to enable the client applications to utilize database features provided by the connection pool without code changes to the client applications. The transparency can keep track of session states, request boundaries and cursors to efficiently reuse the database connections across the client applications. The transparency engine can use the request boundaries and indicators from the database to detect safe places to drain database connections in the event of database outages.

First claim

What is claimed is:

1. A system for high availability and load balancing in a database environment, comprising:
one or more computers including one or more microprocessors;
a software component, executing on the one or more computers, that operates as a transparency engine configured to connect a plurality of client applications to a database and execute queries to fetch rows of data from the database in response to requests from the client applications;
wherein the transparency engine includes one or more row buffers that store rows returned from the database;
wherein the transparency engine includes a connection pool, and is configured to determine request boundaries associated with requests that are received from the plurality of client applications and directed to the database; and
wherein the transparency engine uses the connection pool and the request boundaries to enable the client applications to utilize high availability features of the database, including wherein:
for a particular client application, one or more rows are stored in a row buffer against an application connection ID, and a cursor generated for a query execution; and
wherein the particular application requests a particular data associated with the query, the transparency engine operates to retrieve the one or more rows from the row buffer using the connection ID and cursor, and sends the rows to the client application.

2. The system of claim 1 , wherein the database is a real application cluster database, and wherein the connection pool is a universal connection pool.

3. The system of claim 1 , wherein the plurality of client applications uses different types of drivers to connect to the database through the transparency engine.

4. The system of claim 1 , wherein the software component is a Java application deployed to a cloud environment.

5. The system of claim 1 , wherein the transparency engine operates to detect request boundaries associated with requests from the plurality of client applications that use different database drivers.

6. The system of claim 5 , wherein the transparency engine uses the request boundaries as safe places to drain database connections in the event of a database outage.

7. The system of claim 1 , wherein the transparency engine marks the request boundaries by detecting one or more of a start of a local transaction, a begin/end request, or a ping request to validate a database connection.

8. A method for high availability and load balancing in a database environment, comprising:
providing, at one or more computers including one or more microprocessors, a software component configured to connect a plurality of client applications to a database and execute queries to fetch rows of data from the database in response to requests from the client applications;
providing one or more row buffers that store rows returned from the database;
determining request boundaries associated with requests that are received from the plurality of client applications and directed to the database; and
maintaining a connection pool, wherein the connection pool and the request boundaries enable the client applications to utilize high availability features of the database, including wherein:
for a particular client application, one or more rows are stored in a row buffer against an application connection ID, and a cursor generated for a query execution; and
wherein the particular application requests a particular data associated with the query, the one or more rows are retrieved from the row buffer using the connection ID and cursor, and sent to the client application.

9. The method of claim 8 , wherein the database is a real application cluster database, and wherein the connection pool is a universal connection pool.

10. The method of claim 8 , wherein the software component operates as a transparency engine, and wherein the plurality of client applications uses different types of drivers to connect to the database through the transparency engine.

11. The method of claim 8 , wherein the software component is a Java application deployed to a cloud environment.

12. The method of claim 8 , wherein the software component operates as a transparency engine, and wherein the transparency engine operates to detect request boundaries associated with requests from the plurality of client applications that use different database drivers.

13. The method of claim 12 , wherein the transparency engine uses the request boundaries as safe places to drain database connections in the event of a database outage.

14. The method of claim 8 , wherein the request boundaries are marked by detecting one or more of a start of a local transaction, a begin/end request, or a ping request to validate a database connection.

15. 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 method comprising:
providing, at the one or more computers, a software component configured to connect a plurality of client applications to a database and execute queries to fetch rows of data from the database in response to requests from the client applications;
providing one or more row buffers that store rows returned from the database;
determining request boundaries associated with requests that are received from the plurality of client applications and directed to the database; and
maintaining a connection pool, wherein the connection pool and the request boundaries enable the client applications to utilize high availability features of the database, including wherein:
for a particular client application, one or more rows are stored in a row buffer against an application connection ID, and a cursor generated for a query execution; and
wherein the particular application requests a particular data associated with the query, the one or more rows are retrieved from the row buffer using the connection ID and cursor, and sent to the client application.

16. The non-transitory computer readable storage medium of claim 15 , wherein the request boundaries are marked by detecting one or more of a start of a local transaction, a begin/end request, or a ping request to validate a database connection.

17. The system of claim 1 , wherein the transparency engine stores information related to an application's database session, and uses session states, the request boundaries, and cursors, to reuse database connections maintained by the connection pool across multiple applications.

18. The system of claim 1 , wherein the transparency engine receives notifications from the database descriptive of database events, and sends the notifications to subscribing drivers, connection pools, and application containers.

19. The method of claim 8 , further comprising storing information related to an application's database session, and using session states, the request boundaries, and cursors, to reuse database connections maintained by the connection pool across multiple applications.

20. The method of claim 8 , further comprising receiving notifications from the database descriptive of database events, and sending the notifications to subscribing drivers, connection pools, and application containers.

Assignees

• Oracle Int Corp

Inventors

• Colrain Carol
• Neel Kevin
• Silberkasten Pablo
• Mcmahon Michael
• Verma Saurabh
• Surber Douglas
• De Lavarene Jean

Classifications

• H04L67/5681 Primary

  Pre-fetching or pre-delivering data based on network characteristics · CPC title

• G06F1/30

  Means for acting in the event of power-supply failure or interruption, e.g. power-supply fluctuations (for resetting only G06F1/24) · CPC title

• H04L67/142

  Managing session states for stateless protocols; Signalling session states; State transitions; Keeping-state mechanisms · CPC title

• G06F16/252

  between a Database Management System and a front-end application · CPC title

• H04L67/141

  Setup of application sessions (admission control or resource allocation in data switching networks H04L47/70) · CPC title