Minimizing replication search on failover

• US 9,063,996 B2
• Filed: 08/26/2013
• Issued: 06/23/2015
• Est. Priority Date: 06/29/2011
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Holden, Russell, Spencer, William A.
• Primary Examiner(s): LE, DEBBIE M
• Application Number:
  US14/010,147
• Publication Number:
  US 20140059006A1
• Time in Patent Office: 666 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: G06F 16/273 Asynchronous replication or reconciliation

Abstract

A method, system, and program product are provided for minimizing replication when a new server is replicated with. A replication application for a client computer having a replica of a database thereon is executed by a processor in a computer to receive for a replication service comprising a plurality of servers containing replicas of the database, an indication of each healthy server in the replication service and a determined period of time within which replication is assured to have been completed for each healthy server. The replication application updates a replication history after successful completion of each replication by adding an entry comprising an identification for the server replicated with and a timestamp for the time of replication and by adding an entry for each other healthy server in the replication service containing an identification for the respective server and an imputed timestamp adjusted for the determined period of time.

Claims

1. A computer program product comprising:

a computer readable storage medium; and

computer usable code stored on the computer readable storage medium, where, if executed by a processor, the computer usable code causes a computer to;

receive an identity and a quality of service metric for each healthy server in a replication service, wherein the quality of service metric is to include a period of time within which replication is assured to be completed;

update a replication history with the identity and with a time stamp when a replication of a database is to be performed, wherein the time stamp is to include a time of completion of the replication; and

calculate an imputed time stamp for each healthy server in the replication service that is not replicated with to update the replication history, wherein the imputed time stamp is to include the time stamp modified by the quality of service metric.

2. The computer program product of claim 1, wherein the computer usable code, if executed, further causes a computer to receive an indication to perform the replication.

3. The computer program product of claim 2, wherein the indication is to include one or more of a change to a replica of the database, a passing of a period of time, and a user action.

4. The computer program product of claim 1, wherein the replication history is to include one or more of a table and a file.

5. The computer program product of claim 1, wherein the computer usable code, if executed, further causes a computer to calculate the imputed time stamp by subtracting the period of time within which replication is assured to be completed from the time of completion of the replication.

6. The computer program product of claim 1, wherein the computer usable code, if executed, further causes a computer to perform a replication for a period of time beginning with the imputed time stamp.

7. A method comprising:

receiving an identity and a quality of service metric for each healthy server in a replication service, wherein the quality of service metric includes a period of time within which replication is assured to be completed;

updating a replication history with the identity and with a time stamp when a replication of a database is performed, wherein the time stamp includes a time of completion of the replication; and

calculating an imputed time stamp for each healthy server in the replication service that is not replicated with to update the replication history, wherein the imputed time stamp includes the time stamp modified by the quality of service metric.

8. The method of claim 7, further including receiving an indication to perform the replication.

9. The method of claim 8, wherein the indication includes one or more of a change to a replica of the database, a passing of a period of time, and a user action.

10. The method of claim 7, wherein the replication history includes one or more of a table and a file.

11. The method of claim 7, further including calculating the imputed time stamp by subtracting the period of time within which replication is assured to be completed from the time of completion of the replication.

12. The method of claim 7, further including performing a replication for a period of time beginning with the imputed time stamp.

13. An apparatus comprising a processor to:

receive an identity and a quality of service metric for each healthy server in a replication service, wherein the quality of service metric is to include a period of time within which replication is assured to be completed;

update a replication history with the identity and with a time stamp when a replication of a database is to be performed, wherein the time stamp is to include a time of completion of the replication; and

calculate an imputed time stamp for each healthy server in the replication service that is not replicated with to update the replication history, wherein the imputed time stamp is to include the time stamp modified by the quality of service metric.

14. The apparatus of claim 13, wherein the processor is to receive an indication to perform the replication.

15. The apparatus of claim 14, wherein the indication is to include one or more of a change to a replica of the database, a passing of a period of time, and a user action.

16. The apparatus of claim 13, wherein the replication history is to include one or more of a table and a file.

17. The apparatus of claim 13, wherein the processor is to calculate the imputed time stamp by subtracting the period of time within which replication is assured to be completed from the time of completion of the replication.

18. The apparatus of claim 13, wherein the processor is to perform a replication for a period of time beginning with the imputed time stamp.