Database recovery and database recovery testing
A method of database recovery includes starting a first database server, starting a second database server, starting a third database server, and starting an application server after starting the first database server, the second database server, and the third. The first, second, and third database servers are configured to store data according to first, second, and third database management systems, respectively, and the application server is configured to run application modules of a set of application modules. The method of database recovery further includes starting a search module, starting a product catalog management module, starting a web connectivity module after starting the search module, starting a graphical user interface module after starting the web connectivity module, and starting at least one business operations module.
1 . A method of database recovery, the method comprising:
detecting a failure of at least one of a first database server, a second database server, and an application server;
in response to detecting the failure of the at least one of a first database server, a second database server, and an application server, transitioning a backup server system from an inactive state to an active state, wherein:
the backup server system comprises a backup first database server, a backup second database server, and a backup application server,
the first backup database server is configured to store data according to a first database management system,
the second backup database server is configured to store data according to a second database management system,
the backup application server is configured to run application modules of a set of application modules, and
the set of application modules comprises:
a web connectivity module configured to allow other application modules of the set of application modules to connect to the Internet;
a product catalog management module for managing a product catalog;
a search module for searching at least one of the first database server and the second database server; and
a graphical user interface module configured to allow a user to interact with one or more application modules of the set of application modules;
after transitioning the backup server system from the inactive state to the active state:
starting the search module;
starting the product catalog management module;
starting the web connectivity module after starting the search module, wherein the web connectivity module is configured to request data from the search module; and
starting the graphical user interface module, wherein the graphical user interface module is configured to request data from the web connectivity module and to request data from the search module.
2 . The method of claim 1 , wherein the set of application modules further comprises at least one business operations module configured to request data from at least one of the search module, the product catalog management module, and the web connectivity module, and further comprising starting the at least one business operations module after starting the at least one of the search module, the product catalog management module, and the web connectivity module.
3 . The method of claim 1 , wherein the at least one business operations module is one or more of a credit card verification module, a shipping address verification module, a reporting module, or a financial consolidation module.
4 . The method of claim 1 , and further comprising, in response to detecting the failure of the at least one of the first database server, the second database server, and the application server, transitioning a third backup database server from an inactive state to an active state, and wherein the search module is configured to search at least one of the first backup database server, the second backup database server, and the third backup database server.
5 . The method of claim 1 , further comprising validating, after starting the at least one business operations module, connections used by application modules of the set of application modules.
6 . The method of claim 5 , further comprising using, after validating connections used by the set of application modules, the backup application server, the first backup database server, the second backup database server, and the third backup database server to perform a business operation.
7 . The method of claim 6 , further comprising validating, after starting the at least one business operations module, functionality of application modules of the set of application modules.
8 . The method of claim 7 , wherein validating connections used by application modules of the set of application modules comprises validating that:
the web connectivity module is able to request data from the search module;
the graphical user interface module is able to request data from the web connectivity module;
the graphical user interface module is able to request data from the search module; and
the at least one business operations module is able to request data from at least one of the search module, the product catalog management module, and the web connectivity module.
9 . The method of claim 1 , further comprising:
copying, before starting the first database server and the second database server:
a first data set from the first database server to the first backup database server; and
a second data set from the second database server to the second backup database server.
10 . The method of claim 9 , and further comprising copying, before starting the application server, the set of application modules from the application server to the backup application server.
11 . The method of claim 1 , wherein:
in the inactive state, at least one of the first backup database server and the second backup database server is configured to allow data to be copied to the at least one of the first backup database server and the second backup database server; and
in the active state, the at least one of the first backup database server and the second backup database server is configured to allow data to be read from the at least one of the first backup database server and the second backup database server.
12 . The method of claim 1 , wherein transitioning the backup server system from the inactive state to the active state comprises:
transitioning the first backup database server from the inactive state to the active state;
transitioning the second backup database server from the inactive state to the active state; and
after transitioning the first backup database server and the second backup database server from the inactive state to the active state, transitioning the backup application server from the inactive state to the active state.