Application resiliency management using a database driver

• US 10,303,678 B2
• Filed: 06/29/2016
• Issued: 05/28/2019
• Est. Priority Date: 06/29/2016
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Ghosh, Sujan S., Joshi, Vinayak, Mathai, Shilu, Springgay, Michael R.
• Primary Examiner(s): Channavajjala, Srirama
• Application Number:
  US15/196,033
• Publication Number:
  US 20180004797A1
• Time in Patent Office: 1,063 Days
• CPC Class Codes: G06F 11/0751 Error or fault detection not based on redundancy power supply failures G06F1/30; network fault management H04L41/06
• CPC Class Codes: G06F 11/1474 in transactions G06F16/20 takes precedence
• CPC Class Codes: G06F 11/30 Monitoring
• CPC Class Codes: G06F 16/2308 Concurrency control transaction processing G06F9/466
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: G06F 16/2433 Query languages
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/2453 Query optimisation
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 2201/80 Database-specific techniques

Abstract

Disclosed aspects relate to using a database driver to manage application resiliency with respect to a shared pool of configurable computing resources. A transaction request having a set of command data is received. The set of command data for the transaction request is captured in a memory device coupled with the database driver. The transaction request is connected with a first asset of the shared pool of configurable computing resources. An error event is detected related to the first asset. It is ascertained that the error event indicates a configuration for an automatic client reroute (ACR) operation. Using the ACR operation, the transaction request is connected with a second asset of the shared pool of configurable computing resources. The set of command data for the transaction request is transmitted from the memory device coupled with the database driver to the second asset.

Claims

1. A computer-implemented of using a database driver to manage application resiliency with respect to a shared pool of configurable computing resources, the method comprising:

receiving, by the database driver, a transaction request having a set of command data, wherein the transaction request includes a non-seamless transaction request, wherein the set of command resources comprises one or more units of work, and wherein a unit of work comprises the complete processing operation between a first commit-rollback data-point and a second commit-rollback data-point;

capturing, in a memory device coupled with the database driver, the set of command data for the transaction request, wherein the command data comprises Structured Queried Language (SQL) operations and session resources for an initial a current unit of work, and wherein the session resources comprises a set of special registers, a set of client device information, a set of global variables, a set of global temporary tables, a set of properties, and a set of configurations;

connecting the transaction request with a first asset of the shared pool of configurable computing resources to process the transaction request, wherein the shared pool of configurable computing resources is geographically disconnected from the database driver;

detecting an error event related to the first asset of the shared pool of configurable computing resources, wherein the error occurs after a first operation within the current unit of work;

ascertaining that the error event indicates a configuration for an automatic client reroute (ACR) operation;

connecting, using the ACR operation, the transaction request with a second asset of the shared pool of configurable computing resources to process the transaction request, wherein connecting the transaction request to the second asset is done without user input, and wherein the second asset is selected based on a workload balancing algorithm;

transmitting, from the memory device coupled with the database driver to the second asset of the shared pool of configurable computing resources to process the transaction request, the set of command data for the transaction request and session resources;

determining a successful execution of the transaction request with respect to the second asset of the shared pool of configurable computing resources; and

removing, from the memory device coupled with the database driver, the set of command data for the transaction request.

2. The method of claim 1, further comprising:

receiving, in advance of capturing the set of command data for the transaction request, an indication to use the database driver to manage application resiliency.

3. The method of claim 2, wherein the indication to use the database driver to manage application resiliency is without a set of application-originated code to handle the error event.

4. The method of claim 1, wherein the transaction request includes a write request.

5. The method of claim 1, further comprising:

detecting a failure related to the second asset of the shared pool of configurable computing resources; and

returning an error notification.

6. The method of claim 5, further comprising:

ascertaining that the failure indicates an ineligibility for the ACR operation.

7. The method of claim 1, wherein the capturing, the connecting, the detecting, the ascertaining, the connecting, and the transmitting each occur without interaction with an application which sent the transaction request.

8. The method of claim 1, wherein the receiving, the capturing, the connecting, the detecting, the ascertaining, the connecting, and the transmitting each occur in an automated fashion without user intervention.

9. A system of using a database driver to manage application resiliency with respect to a shared pool of configurable computing resources, the system comprising:

a memory having a set of computer readable computer instructions, and

a processor for executing the set of computer readable instructions, the set of computer readable instructions including;

receiving, by the database driver, a transaction request having a set of command data, wherein the transaction request includes a non-seamless transaction request, wherein the set of command resources comprises one or more units of work, and wherein a unit of work comprises the complete processing operation between a first commit-rollback data-point and a second commit-rollback data-point;

capturing, in a memory device coupled with the database driver, the set of command data for the transaction request, wherein the command data comprises Structured Queried Language (SQL) operations and session resources for an initial a current unit of work, and wherein the session resources comprises a set of special registers, a set of client device information, a set of global variables, a set of global temporary tables, a set of properties, and a set of configurations;

connecting the transaction request with a first asset of the shared pool of configurable computing resources to process the transaction request, wherein the shared pool of configurable computing resources is geographically disconnected from the database driver;

detecting an error event related to the first asset of the shared pool of configurable computing resources, wherein the error occurs after a first operation within the current unit of work;

ascertaining that the error event indicates a configuration for an automatic client reroute (ACR) operation;

connecting, using the ACR operation, the transaction request with a second asset of the shared pool of configurable computing resources to process the transaction request, wherein connecting the transaction request to the second asset is done without user input, and wherein the second asset is selected based on a workload balancing algorithm;

transmitting, from the memory device coupled with the database driver to the second asset of the shared pool of configurable computing resources to process the transaction request, the set of command data for the transaction request and session resources;

determining a successful execution of the transaction request with respect to the second asset of the shared pool of configurable computing resources; and

removing, from the memory device coupled with the database driver, the set of command data for the transaction request.

10. A computer program product of using a database driver to manage application resiliency with respect to a shared pool of configurable computing resources, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, the program instructions executable by a processor to cause the processor to perform a method comprising:

receiving, by the database driver, a transaction request having a set of command data, wherein the transaction request includes a non-seamless transaction request, wherein the set of command resources comprises one or more units of work, and wherein a unit of work comprises the complete processing operation between a first commit-rollback data-point and a second commit-rollback data-point;

capturing, in a memory device coupled with the database driver, the set of command data for the transaction request, wherein the command data comprises Structured Queried Language (SQL) operations and session resources for an initial a current unit of work, and wherein the session resources comprises a set of special registers, a set of client device information, a set of global variables, a set of global temporary tables, a set of properties, and a set of configurations;

connecting the transaction request with a first asset of the shared pool of configurable computing resources to process the transaction request, wherein the shared pool of configurable computing resources is geographically disconnected from the database driver;

detecting an error event related to the first asset of the shared pool of configurable computing resources, wherein the error occurs after a first operation within the current unit of work;

ascertaining that the error event indicates a configuration for an automatic client reroute (ACR) operation;

connecting, using the ACR operation, the transaction request with a second asset of the shared pool of configurable computing resources to process the transaction request, wherein connecting the transaction request to the second asset is done without user input, and wherein the second asset is selected based on a workload balancing algorithm;

transmitting, from the memory device coupled with the database driver to the second asset of the shared pool of configurable computing resources to process the transaction request, the set of command data for the transaction request and session resources;

determining a successful execution of the transaction request with respect to the second asset of the shared pool of configurable computing resources; and

removing, from the memory device coupled with the database driver, the set of command data for the transaction request.

11. The computer program product of claim 10, wherein the program instructions are stored in a computer readable storage medium in a data processing system, and wherein the program instructions were downloaded over a network from a remote data processing system.

12. The computer program product of claim 10, wherein the program instructions are stored in the computer readable storage medium in a server data processing system, and wherein the program instructions are downloaded over a network to the remote data processing system for use in the computer readable storage medium with the remote data processing system.