Two-Tier Failover Service for Data Disaster Recovery

A computer-readable storage medium having computer-executable instructions stored thereon which, when executed by a computer, cause the computer to:

• identify a request to access content by an application associated with an application identifier;
• retrieve, from a database information table, a first record corresponding to the application identifier, the first record comprising a reference identifier, a database name of a database, and a failover value;
• retrieve, from a server information table, a second record corresponding to the reference identifier, the second record comprising an indication of a first server computer as a primary server computer and an indication of a second server computer as a secondary server computer;
• and
• generate a connection specification to either the first server computer or the second server computer based on the first record and the second record.

A two-tier failover system, comprising:

• a data store comprising a server information table and a database information table, the database information table comprising a first record and a second record, the first record associated with a first application identifier and comprising a reference identifier, a first database name of a first database, and a first failover value specifying that no database-level failover has been initiated, the second record associated with a second application identifier and comprising the reference identifier, a second database name of a second database, and a second failover value specifying that database-level failover has been initiated, the server information table comprising a third record, the third record associated with the reference identifier and comprising an indication of a first server computer as a primary server computer and an indication of a second server computer as a secondary server computer;
• a processor;
• a memory communicatively coupled to the processor;
• and
• a program module which executes in the processor from the memory and which, when executed by the processor, causes the processor to
• identify a request to access content by a first application associated with the first application identifier,
• retrieve, from the database information table, the first record corresponding to the first application identifier, the first record comprising the reference identifier, the first database name of the first database, and the first failover value,
• retrieve, from the server information table, the third record corresponding to the reference identifier, the third record comprising the indication of the first server computer as the primary server computer and the indication of the second server computer as the secondary server computer, and
• generate a first connection specification to the first server computer based on the first record and the third record.