Transfering database workload among multiple database systems
View Patent ↗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.
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.