Automated self-healing database system and method for implementing the same
First Claim
1. A method in a database system comprising a primary site, wherein the primary site further comprises an application server that writes data to a primary database and reads data from the primary database when the primary database is available, the method comprising:
- automatically detecting, by a self-healing module, unavailability of the primary database;
determining, by the self-healing module, whether a standby database of the primary site is available, wherein the standby database is a replica of the primary database;
temporarily allowing the application server to have read-only access from the standby database at the primary site when the self-healing module determines that the standby database is available at the primary site so that the application server can still read data from the standby database and satisfy read-only requests while the primary database is down and it is being determined whether the primary database will recover; and
automatically initiating a failover processing sequence by the self-healing module when the self-healing module detects that the primary database is unavailable and determines that the standby database 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, wherein no new connection establishment is needed due to the pre-established connection when the fail over role transition happens.
1 Assignment
0 Petitions
Accused Products
Abstract
An automated self-healing database system is provided that includes a primary database, an application server that writes data to the primary database and reads data from the primary database when it is available, a standby database that is a replica of the primary database, and a self-healing module (SHM). The SHM can automatically detect unavailability of the primary database, and if the standby database is available, the SHM can automatically enable the standby database as readable and writable, assign the standby database the role of primary database at the primary site to start replicating data to other standby databases, and use 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.
168 Citations
17 Claims
-
1. A method in a database system comprising a primary site, wherein the primary site further comprises an application server that writes data to a primary database and reads data from the primary database when the primary database is available, the method comprising:
-
automatically detecting, by a self-healing module, unavailability of the primary database; determining, by the self-healing module, whether a standby database of the primary site is available, wherein the standby database is a replica of the primary database; temporarily allowing the application server to have read-only access from the standby database at the primary site when the self-healing module determines that the standby database is available at the primary site so that the application server can still read data from the standby database and satisfy read-only requests while the primary database is down and it is being determined whether the primary database will recover; and automatically initiating a failover processing sequence by the self-healing module when the self-healing module detects that the primary database is unavailable and determines that the standby database 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, wherein no new connection establishment is needed due to the pre-established connection when the fail over role transition happens. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A method in a database system comprising a primary site, wherein the primary site further comprises an application server that writes data to a primary database and reads data from the primary database when the primary database is available, the method comprising:
-
automatically detecting, by a self-healing module, unavailability of the primary database, wherein the primary database comprises a first database server and a first storage sub-system; determining, by the self-healing module, whether a standby database of the primary site is available, wherein the standby database is a replica of the primary database, wherein the standby database comprises a second database server and a second storage sub-system; and automatically initiating a failover processing sequence by the self-healing module when the self-healing module detects that the primary database is unavailable and determines that the standby database is available, wherein the failover processing sequence comprises; before automatically enabling the standby database, automatically attaching the first storage sub-system from the first database server to the second database server for recovery; 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, wherein no new connection establishment is needed due to the pre-established connection when the fail over role transition happens.
-
-
8. 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:
-
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 a standby database is still available at the primary site, wherein the standby database is a replica of the primary database; temporarily allow the application server to have read-only access from the standby database at the primary site when the self-healing module determines that the standby database is available at the primary site so that the application server can still read data from the standby database and satisfy read-only requests while the primary database is down and it is being determined whether the primary database will recover; 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, wherein no new connection establishment is needed due to the pre-established connection when the fail over role transition happens. - View Dependent Claims (9)
-
-
10. 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:
-
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, wherein the primary database comprises a first database server and a first storage sub-system; determine whether a standby database is still available at the primary site, wherein the standby database is a replica of the primary database, wherein the standby database comprises a second database server and a second storage sub-system; 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; before automatically enabling the standby database, automatically attaching the first storage sub-system from the first database server to the second database server for recovery before automatically enabling; 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, wherein no new connection establishment is needed due to the pre-established connection when the fail over role transition happens.
-
-
11. 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; and a self-healing module configured to; automatically detect unavailability of the primary database; determine whether the standby database of the primary site is available; temporarily allow the application server to have read-only access from the standby database at the primary site when the self-healing module determines that the standby database is available at the primary site so that the application server can still read data from the standby database and satisfy read-only requests while the primary database is down and it is being determined whether the primary database will recover; 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, wherein no new connection establishment is needed due to the pre-established connection when the fail over role transition happens. - View Dependent Claims (12, 13, 14, 15, 16)
-
17. 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; and a self-healing module configured to; 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; before automatically enabling the standby database, automatically attaching the first storage sub-system from the first database server to the second database server for recovery; 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, wherein no new connection establishment is needed due to the pre-established connection when the fail over role transition happens.
Specification