Transfering database workload among multiple database systems

• US 7,567,990 B2
• Filed: 12/13/2006
• Issued: 07/28/2009
• Est. Priority Date: 12/30/2004
• Status: Active Grant

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: Teradata US, Inc. (Teradata Corporation)
• Inventors: Fastner, Thomas A., Mitchell, Mark A.
• Primary Examiner(s): Le; Uyen T.
• Application Number:
  US11/638,647
• Publication Number:
  US 20070094238A1
• Time in Patent Office: 958 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A system includes at least two database systems that both store a common portion of a relational database and that are configured to share in execution of a database workload against that relational database. The system also includes a system-management component configured to receive indication that a first one of the database systems is ceasing operation and, in response, take a second one of the database systems to an operational state in which at least a portion of the database workload that is scheduled to be carried out by the first database system is transferred to the second database system.

Claims

1. A method for use in managing operation of at least two database systems that both store a common portion of a relational database and that are configured to share a database workload against that relational database, the method comprising:

receiving indication that a first one of the database systems is ceasing operation; and

, in response

taking a second one of the database systems to an operational state in which at least a portion of the database workload that is scheduled to be carried out by the first database system is transferred to the second database system;

where receiving indication that the first database system is ceasing operation includes receiving indication that the first database is ceasing operation as a result of an unplanned shutdown, and in response;

taking the second database system to a second operational state in which it carries out the portion of the database workload transferred to it in addition to at least some portion its own portion of the database workload and stores information indicating that the first database system ceased operation as a result of an unplanned shutdown; and

then

taking the second database system to a third operational state in which it continues to carry out the portion of the database workload transferred to it in addition to at least some portion its own portion of the database workload and stores information indicating that the first database system ceased operation as a result of a planned shutdown.

2. The method of claim 1, further comprising:

receiving indication that the first database system is resuming operation; and

, in response

taking the second database system to a fourth operational state in which at least a portion of the transferred workload is transferred back to the first database system.

3. The method of claim 2, further comprising taking the second database system to an operational state in which the first and second database systems again share the database workload.

4. A system comprising:

(a) at least two database systems that both store a common portion of a relational database and that are configured to share a database workload against that relational database; and

(b) a system-management component configured to receive indication that a first one of the database systems is ceasing operation and, in response, take a second one of the database systems to an operational state in which at least a portion of the database workload that is scheduled to be carried out by the first database system is transferred to the second database system;

where the system-management component, in receiving indication that the first database system is ceasing operation, is configured to receive indication that the first database is ceasing operation as a result of an unplanned shutdown, and in response;

take the second database system to a second operational state in which it carries out the portion of the database workload transferred to it in addition to at least some portion of its own portion of the database workload and stores information indicating that the first database system ceased operation as a result of an unplanned shutdown; and

then

take the second database system to a third operational state in which it continues to carry out the portion of the database workload transferred to it in addition to at least some portion of its own portion of the database workload and stores information indicating that the first database system ceased operation as a result of a planned shutdown.

5. The system of claim 4, where the system-management component is subsequently configured to receive indication that the first database system is resuming operation and, in response, take the second database system to a fourth operational state in which at least a portion of the transferred workload is transferred back to the first database system.

6. The system of claim 5, where the system-management component is subsequently configured to take the second database system to an operational state in which the first and second database systems again share the database workload.