Intelligent disaster recovery for database connection failures

摘要

Embodiments of the invention provide techniques for disaster recovery in the event of a database connection failure. In one embodiment, a network address for a secondary server may be stored in multiple data objects of a client computer. In the event of a failed connection to a primary server, the network address of the secondary server may be retrieved from one of the data objects stored in the client computer. When an updated network address for the secondary server is received, it may be propagated to the data objects of the client computer.

主权项

1. A computer-implemented method for a database driver providing database access to client application on a client computer system to connect to a failover computer system, comprising:
attempting, by the client application, to re-establish a connection between the client computer system and the first computer system after the client computer system is disconnected from the first computer system, wherein the first computer system hosts a database application accessed at a primary network address by a database driver on the client computer system; upon determining the client application is unable to re-establish the connection between the client computer system and the first computer system, retrieving a first network address of a first failover computer system from one or more data objects stored by the client computer system, wherein the first network address was received from the first computer system prior to attempting to re-establish the connection, and wherein the one or more data objects stored on the client application are accessed in a predetermined order until the first network address is retrieved, wherein retrieving the network address of the first failover address comprises accessing, in the predetermined order on the client computer system, the database driver, a data source object managed by the database driver, a directory interface object, and a domain name system (DNS) object, until the network address of the first failover computer system is retrieved; establishing a connection between the client computer system and the failover computer system, wherein the first failover computer system hosts a backup of the at least one database application; receiving, from the failover computer system, a second network address for a second failover computer system; and storing the second network address in at least a first one of the one or more data objects stored by the client computer system, wherein storing the second network address comprises:
determining whether the one or more data objects store the same network address as the received second network address, andif not, storing the received network address in at least one of the one or more data objects.