System and method for handling database failover
First Claim
1. A system comprising:
- a first database server including a database instance;
a second database server in communication with the first database server, the second database server including a mirror of the database instance, wherein the first database server and the second database server are in a primary and secondary server relationship with the second database server as a secondary server;
a third database server in communication with the second database server, the third database server configured to store a copy of a database within the database instance; and
an application server configured to be placed in communication with the first, second, and third database servers, configured to assign the first database server as a primary server and the second database server as the secondary server for the application server, to fail over between the first and second database servers, further configured to fail over between the second and third database servers, and to assign the third database server as the primary server for the application server when the first database server is decommissioned, wherein the third database server and the second database server are in a new primary and secondary server relationship with the second database server as the secondary server.
14 Assignments
0 Petitions
Accused Products
Abstract
A system includes a first database, a second database, a third database, and an application server. The first database server includes a database instance. The second database server is in communication with the first database server. The second database server includes a mirror of the database instance. The third database server is in communication with the second database server. The third database server is configured to store a copy of a database within the database instance. The application server is configured to be placed in communication with the first, second, and third database servers, configured to fail over between the first and second database servers, and further configured to fail over between the second and third database servers.
-
Citations
17 Claims
-
1. A system comprising:
-
a first database server including a database instance; a second database server in communication with the first database server, the second database server including a mirror of the database instance, wherein the first database server and the second database server are in a primary and secondary server relationship with the second database server as a secondary server; a third database server in communication with the second database server, the third database server configured to store a copy of a database within the database instance; and an application server configured to be placed in communication with the first, second, and third database servers, configured to assign the first database server as a primary server and the second database server as the secondary server for the application server, to fail over between the first and second database servers, further configured to fail over between the second and third database servers, and to assign the third database server as the primary server for the application server when the first database server is decommissioned, wherein the third database server and the second database server are in a new primary and secondary server relationship with the second database server as the secondary server. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A non-transitory computer readable medium comprising a plurality of instructions to manipulate a processor, the plurality of instructions comprising:
-
instructions to cause an application server to fail over from a primary database server to a secondary database server, the secondary database server including a mirror of a database instance located on the primary database server; instructions to identify a database within the database instance on the primary and secondary databases being accessed by the application server; instructions to connect the application server with the secondary database server for access to the identified database in response to a domain name system request for the secondary database server; instructions to copy the identified database from the secondary database server to a new database server; instructions to break a first communication link between the primary database server and the secondary database server; instructions to mirror the identified database between the secondary database server and the new database server; instructions to remap a domain name system request for the primary database server to the new server, wherein the domain name system request for the primary database server is different than the domain name system request for the secondary database server; and instructions to connect the application server with the new database server for access to the identified database in response to the domain name system request for the primary database server. - View Dependent Claims (7, 8, 9, 10, 11)
-
-
12. A non-transitory computer readable medium comprising a plurality of instructions to manipulate a processor, the plurality of instructions comprising:
-
instructions to mirror a database of a database instance stored on both a primary database server and on a secondary database server, wherein the primary database server and the secondary database server have an existing primary and secondary server relationship; instructions to initiate an application server to fail over from the primary database server to the secondary database server; instructions to store a copy of the database of the database instance located on the secondary database server onto a new primary database server; instructions to remove the database from the primary database server in response to a completion of the copying of the database from the secondary database server onto the new primary database server; instructions to begin mirroring the database between the secondary database server and the new primary database server; instructions to store the new primary database server in the application server; instructions to break the mirroring between the primary database server and the secondary database server; and instruction to initiate the application server to fail over from the secondary database server to the new primary database server containing the database, wherein the new primary database server and the secondary database server have a new primary and secondary server relationship. - View Dependent Claims (13, 14, 15, 16, 17)
-
Specification