Automated self-healing database system and method for implementing the same

A computing system comprising a processor and a memory, wherein the memory comprises computer-executable instructions that are capable of causing the computing system to:

• periodically capture snapshots of data stored at a standby database that is a replica of the primary database;
• store the snapshots of data in a snapshot storage system comprising separate storage hardware that is not implemented at the primary site;
• automatically detect unavailability of a primary database at a primary site, wherein the primary site further comprises an application server that writes data to the primary database and reads data from the primary database when the primary database is available;
• determine whether the standby database is still available at the primary site;
• and
• automatically initiate a failover processing sequence when the primary database has been detected to be unavailable and the standby database has been determined to be available, wherein the failover processing sequence comprises:
• automatically enabling the standby database as readable and writable and assigning the standby database the role of primary database at the primary site to start replicating data to other standby databases;
• and
• after a failover role transition, using a pre-established connection between the application server and the standby database to allow the application server to read data from the standby database and to write data to the standby database resulting in the standby database assuming role of the primary database at the primary site.

An automated self-healing database system, comprising:

• a primary site, comprising:
• a primary database;
• an application server that writes data to the primary database and reads data from the primary database when the primary database is available;
• a standby database that is a replica of the primary database;
• a snapshot storage system comprising separate storage hardware that is remotely located and not implemented at the primary site;
• and
• a self-healing module configured to:
• periodically capture snapshots of data stored at the standby database,
• wherein the snapshot storage system is configured to store the snapshots of data;
• automatically detect unavailability of the primary database;
• determine whether the standby database of the primary site is available;
• and
• automatically initiate a failover processing sequence when the self-healing module detects that the primary database is unavailable and determines that the standby database of the primary site is available, wherein the failover processing sequence comprises:
• automatically enabling the standby database as readable and writable and assigning the standby database the role of primary database at the primary site to start replicating data to other standby databases;
• and
• after a failover role transition, using a pre-established connection between the application server and the standby database to allow the application server to read data from the standby database and to write data to the standby database resulting in the standby database assuming role of the primary database at the primary site.