APPLICATION RESILIENCY MANAGEMENT USING A DATABASE DRIVER

• US 20180225325A1
• Filed: 02/07/2017
• Published: 08/09/2018
• Est. Priority Date: 02/07/2017
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Ghosh, Sujan S., Joshi, Vinayak, Kundu, Amitava, Mathai, Shilu
• Application Number:
  US15/427,028
• Publication Number:
  US 20180225325A1
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/24542 Plan optimisation
• CPC Class Codes: G06F 9/5066 Algorithms for mapping a plurality of inter-dependent sub-tasks onto a plurality of physical CPUs mappping at compile time, see G06F8/451

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 may be received. An updated set of global property data for the database driver may be detected. The updated set of global property data for the database driver may be captured in a memory device coupled with the database driver. An operational member asset of the shared pool of configurable computing resources may be determined to process the transaction request. The transaction request may be connected with the operational member asset of the shared pool of configurable computing resources. The set of command data for the transaction request may be transmitted to the operational member of the shared pool of configurable computing resources.

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 a transaction request having a set of command data;

detecting an updated set of global property data for the database driver;

capturing, in a memory device coupled with the database driver, the updated set of global property data for the database driver;

determining, based on the updated set of global property data for the database driver and related to an automatic client reroute (ACR) operation, an operational member asset of the shared pool of configurable computing resources to process the transaction request;

connecting, using the ACR operation, the transaction request with the operational member asset of the shared pool of configurable computing resources to process the transaction request; and

transmitting, to the operational member asset of the shared pool of configurable computing resources to process the transaction request, the set of command data for the transaction request.

2. The method of claim 1, further comprising:

receiving, from a user, an updated global property file which includes the updated set of global property data for the database driver.

3. The method of claim 1, further comprising:

modifying, to establish the updated set of global property data for the database driver, an outdated set of global property data in a dynamic fashion.

4. The method of claim 3, further comprising:

removing, from an ordered data structure, a first cluster member entry for a first cluster member;

adding, to the ordered data structure, a second cluster member entry for a second cluster member; and

changing an order of cluster members entries in the ordered data structure which includes;

rearranging, in the ordered data structure to establish the updated set of global property data for the database driver, a third cluster member entry for a third cluster member to be subsequent to a fourth cluster member entry for a fourth cluster member, wherein the outdated set of global property data had the fourth cluster member entry for the fourth cluster member subsequent to the third cluster member entry for the third cluster member.

5. The method of claim 1, further comprising:

monitoring, by the database driver, a global property file for an indication of the updated set of global property data for the database driver.

6. The method of claim 5, further comprising:

running a daemon thread to monitor the global property file, wherein the daemon thread checks for the indication of the updated set of global property data for the database driver on a temporally-periodic basis.

7. The method of claim 5, further comprising:

running a daemon thread to monitor the global property file, wherein the daemon thread checks for the indication of the updated set of global property data for the database driver on an event-based basis.

8. The method of claim 1, further comprising:

connecting the transaction request with a first member asset of the shared pool of configurable computing resources to process the transaction request;

detecting an error event related to the first member asset of the shared pool of configurable computing resources; and

ascertaining that the error event indicates a configuration for the ACR operation.

9. The method of claim 1, further comprising:

deploying, at a first physical location which differs from a set of locations having the shared pool of configurable computing resources, the memory device coupled with the database driver.

10. The method of claim 1, further comprising:

configuring the set of command data to include both;

a set of Structured Query Language (SQL) statements, and

a set of session resources.

11. The method of claim 10, further comprising:

configuring the set of session resources to include;

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.

13. The method of claim 1, further comprising:

detecting a failure related to the operational member asset of the shared pool of configurable computing resources;

ascertaining that the failure indicates an ineligibility for the ACR operation; and

returning an error notification.

14. The method of claim 1, further comprising:

sensing, when carrying-out the transaction request of a source application, an unplanned outage of a set of member assets of the shared pool of configurable computing resources;

adding, to the updated set of global property data for the database driver, an entry for the operational member asset; and

carrying-out, without interaction with the source application, performance of the transaction request in both a dynamic fashion and a resilient fashion.

15. The method of claim 1, further comprising:

executing, without interaction with an application which sent the transaction request, each of;

the receiving, the detecting, the capturing, the determining, the connecting, and the transmitting.

16. The method of claim 1, further comprising:

executing, in a dynamic fashion to streamline using the database driver to manage application resiliency with respect to the shared pool of configurable computing resources, each of;

the receiving, the detecting, the capturing, the determining, the connecting, and the transmitting.

17. The method of claim 1, further comprising:

executing, in an automated fashion without user intervention, each of;

the receiving, the detecting, the capturing, the determining, the connecting, and the transmitting.

18. The method of claim 1, wherein the transaction request includes a write request, further comprising:

deploying, at a first physical location which differs from a set of locations having the shared pool of configurable computing resources, the memory device coupled with the database driver;

configuring the set of command data to include both;

a set of Structured Query Language (SQL) statements, and

a set of session resources;

configuring the set of session resources to include;

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 write request with a first member asset of the shared pool of configurable computing resources to process the write request;

detecting an error event related to the first member asset of the shared pool of configurable computing resources;

monitoring, by the database driver running a daemon thread, a global property file for an indication of the updated set of global property data for the database driver;

receiving, from a user, an updated global property file which includes the updated set of global property data for the database driver;

modifying, to establish the updated set of global property data for the database driver, an outdated set of global property data in a dynamic fashion;

ascertaining that the error event indicates a configuration for the ACR operation; and

receiving an indication to use the database driver to manage application resiliency, 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.

12. The method of claim 1, further comprising:

receiving an indication to use the database driver to manage application resiliency, wherein the indication to use the database driver to manage application resiliency is without a set of application-originated code to handle an error event.

12-1. (canceled)

19. A system of using a database driver to manage application resiliency with respect to a shared pool of configurable computing resources, the method 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 a transaction request having a set of command data;

detecting an updated set of global property data for the database driver;

capturing, in a memory device coupled with the database driver, the updated set of global property data for the database driver;

determining, based on the updated set of global property data for the database driver and related to an automatic client reroute (ACR) operation, an operational member asset of the shared pool of configurable computing resources to process the transaction request;

connecting, using the ACR operation, the transaction request with the operational member asset of the shared pool of configurable computing resources to process the transaction request; and

transmitting, to the operational member asset of the shared pool of configurable computing resources to process the transaction request, the set of command data for the transaction request.

20. 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 a transaction request having a set of command data;

detecting an updated set of global property data for the database driver;

capturing, in a memory device coupled with the database driver, the updated set of global property data for the database driver;

determining, based on the updated set of global property data for the database driver and related to an automatic client reroute (ACR) operation, an operational member asset of the shared pool of configurable computing resources to process the transaction request;

connecting, using the ACR operation, the transaction request with the operational member asset of the shared pool of configurable computing resources to process the transaction request; and

transmitting, to the operational member asset of the shared pool of configurable computing resources to process the transaction request, the set of command data for the transaction request.