US 11,687,507 B2Granted

Termination of database sessions for planned failover

AssigneeOracle International Corporation

InventorsCarol L. Colrain, Pedro Arturo Cornejo Torres, Kevin S. Neel

Life of this patent

Estimating the term…

Loading patent…

Abstract

Techniques are described for performing session termination(s) for active sessions in response to a planned operation on a database server of a DBMS. In an embodiment, the DBMS receives a request for a planned operation on a database server. The database server may have session(s) established with a client system to receive request(s) to execute database command(s) on the DBMS. In response, the DBMS transmits to the client system a notification to drain a session with the database server, and the DBMS marks the sessions at the database to drain. The DBMS is configured to terminate any drain-marked sessions by the database server when a rule is satisfied, and the failover is expected to succeed, and/or that the session is unlikely to drain or to failover at a later point in the session lifecycle. The DBMS may identify, in a rule set, a rule having rule instructions to detect a possible termination point for the session before the drain timeout period expires. Based on the execution of the rule instructions before the drain timeout expires, the DBMS determines that a termination point for the session is detected where that session will failover. In such a way, sessions are failed over early and at points where the failover is expected to succeed.

Claims20

Dependent claims

A computer-implemented method comprising:

receiving a request for a planned operation on a first database server of a DBMS, the first database server having a particular database session established with a client system to receive one or more requests to execute one or more user calls on the DBMS;
in response to the request for the planned operation for the first database server, transmitting to the client system a request to drain database sessions with the first database server including the particular database session, the DBMS being configured to terminate any database session with the first database server that has not been drained within a drain timeout period;
identifying, in a rule set, first rule data, the first rule data including first rule instructions to detect a possible termination point for the particular database session before the drain timeout period expires;
before the drain timeout period expires, executing the first rule instructions at least by calculating one or more database session behavior metrics for the particular database session of the client system with the first database server;
based on the execution of the first rule instructions before the drain timeout period expires and before the drain timeout period expires, determining whether a termination point for the particular database session is detected using the database session behavior metrics;
based on determining that the termination point for the particular database session is detected and before the drain timeout period expires, terminating the particular database session of the client system with the DBMS at the termination point.

3 more elements

One or more non-transitory computer-readable media storing instructions, wherein the instructions include a set of instructions, which when executed by one or more hardware processors, cause:

receiving a request for a planned operation on a first database server of a DBMS, the first database server having a particular database session established with a client system to receive one or more requests to execute one or more user calls on the DBMS;
in response to the request for the planned operation for the first database server, transmitting to the client system a request to drain database sessions with the first database server including the particular database session, the DBMS being configured to terminate any database session with the first database server that has not been drained within a drain timeout period;
identifying, in a rule set, first rule data, the first rule data including first rule instructions to detect a possible termination point for the particular database session before the drain timeout period expires;
before the drain timeout period expires, executing the first rule instructions at least by calculating one or more database session behavior metrics for the particular database session of the client system with the first database server;
based on the execution of the first rule instructions before the drain timeout period expires and before the drain timeout period expires, determining whether a termination point for the particular database session is detected using the database session behavior metrics;
based on determining that the termination point for the particular database session is detected and before the drain timeout period expires, terminating the particular database session of the client system with the DBMS at the termination point.

3 more elements

Dependencies are inferred from the claim text.

Facts

Application: 17/018,142Filed 11 Sep 2020 · us provisional application
Priority: 12 Sep 2019
Published: US 2021/0081382 A118 Mar 2021
Granted: 27 Jun 2023
Term ends: Not estimatedThe source records don’t support an estimate.

Classification4 codes

G06F 16/21
Of structured data, e.g. relational data: design, administration or maintenance of databases
G06F 16/217
Design, administration or maintenance of databases: database tuning
G06F 16/2365
Updating: ensuring data consistency and integrity
G06F
Computing and data processing