Method and apparatus for providing database system replication in a mixed propagation environment

• US 5,937,414 A
• Filed: 02/28/1997
• Issued: 08/10/1999
• Est. Priority Date: 02/28/1997
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle Corporation
• Inventors: Lim, Peter, Souder, Benny, Downing, Alan, Stamos, James, Sun, Harry, Doo, Lip Boon
• Primary Examiner(s): Amsbury, Wayne
• Assistant Examiner(s): PARDO, THUY N
• Application Number:
  US08/808,522
• Time in Patent Office: 893 Days
• Field of Search: 707/10, 707/202, 707/203, 707/204, 707/205, 711/117, 395/200.43, 395/500, 395/489, 395/182.18, 395/444
• US Class Current: 707/616
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• 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/959 Network
• CPC Class Codes: Y10S 707/99953 Recoverability
• CPC Class Codes: Y10S 707/99954 Version management

Abstract

A method and apparatus for replicating data among sites is provided. The method allows changes to the same body of data to be replicated synchronously to some destination sites and asynchronously to other destination sites. Such mixed propagation configurations allow synchronous updating to selected remote copies of replicated data where data integrity is a high priority, and asynchronous propagation to remaining copies of replicated data in order to allow transactions to be committed locally regardless of whether the transaction is committed at a remote copy of the replicated data. The propagation mode is selectable by a user on a site-to-site basis for each replicated body of data, thus providing a mix of availability and consistency that is not possible in purely synchronous or purely asynchronous replication systems.

Claims

1. A method for maintaining multiple copies of a body of data at multiple sites, the method comprising the steps of:

detecting a change to a first copy of the body of data at a first site;

in response to detecting the change to the first copy, performing the steps of;

asynchronously propagating the change to a second copy of the body of data at a second site; and

synchronously propagating the change to a third copy of the body of data at a third site.

2. The method of claim 1 wherein the step of synchronously propagating the change to the third copy comprises the step of making permanent the change to the first copy at said first site only after receiving verification that the change has been successfully made to the third copy of the body of data at the third site.

3. The method of claim 2 wherein the step of making permanent the change to the first copy at said first site is performed without regard to whether the change is successfully made to the second copy of the body of data at the second site.

4. The method of claim 3 wherein the step of making permanent the change to the first copy at said first site is performed prior to propagating the change to the second site.

5. A computer network comprising:

a first site having a first copy of a body of data;

a second site having a second copy of the body of data;

a third site having a third copy of the body of data; and

a replication mechanism which is configured to respond to changes being made to the first copy by synchronously propagating the changes to the second site and asynchronously propagating the changes to the third site.

6. The computer network of claim 5 wherein the replication mechanism is further configured to respond to changes being made to the second copy by asynchronously propagating the changes to the first site.

7. A method for replicating data in a computer system, the method comprising the steps of:

maintaining a first copy of a body of data at a first site;

maintaining a second copy of the body of data at a second site;

synchronously propagating to said second site changes made to said first copy;

asynchronously propagating to said first site changes made to said second copy.

8. The method of claim 7 further comprising the steps of:

while said first site is operational, causing all new changes to said body of data to be initially made at said first site; and

while said first site is not operational after a failure at said first site, causing all new changes to said body of data to be initially made at said second site.

9. The method of claim 8 further comprising the steps of, after the first site becomes operational again after a failure:

applying to the first copy all changes that were made to the second copy while the first site was unavailable; and

causing all new changes to said body of data to be initially made at said first site.

10. A method for maintaining an updatable snapshot at a first site that reflects data stored at a second site, the method comprising the steps of:

periodically transmitting change information from the second site to the first site;

in response to receiving the change information at the first site, revising the snapshot to reflect changes identified in the change information; and

synchronously propagating to said second site changes made to the updatable snapshot at the first site.

11. The method of claim 10 further comprising the step of making changes made to the updatable snapshot permanent at the first site only after receiving confirmation that the changes were successfully made at the second site.

12. The method of claim 10 wherein the step of revising the snapshot includes the step of determining which changes in said change information apply to data that has been selected for said snapshot.

13. A computer-readable medium carrying sequences of instructions for maintaining multiple copies of a body of data at multiple sites, the sequences of instructions comprising instructions for performing the steps of:

detecting a change to a first copy of the body of data at a first site;

in response to detecting the change to the first copy, performing the steps of;

asynchronously propagating the change to a second copy of the body of data at a second site; and

synchronously propagating the change to a third copy of the body of data at a third site.

14. The computer-readable medium of claim 13 wherein the step of synchronously propagating the change to the third copy comprises the step of making permanent the change to the first copy at said first site only after receiving verification that the change has been successfully made to the third copy of the body of data at the third site.

15. The computer-readable medium of claim 14 wherein the step of making permanent the change to the first copy at said first site is performed without regard to whether the change is successfully made to the second copy of the body of data at the second site.

16. The computer-readable medium of claim 15 wherein the step of making permanent the change to the first copy at said first site is performed prior to propagating the change to the second site.

17. A computer-readable medium carrying sequences of instructions for replicating data in a computer system, the sequences of instructions comprising instructions for performing the steps of:

maintaining a first copy of a body of data at a first site;

maintaining a second copy of the body of data at a second site;

synchronously propagating to said second site changes made to said first copy;

asynchronously propagating to said first site changes made to said second copy.

18. The computer-readable medium of claim 17 further comprising instructions for performing the steps of:

while said first site is operational, causing all new changes to said body of data to be initially made at said first site; and

while said first site is not operational after a failure at said first site, causing all new changes to said body of data to be initially made at said second site.

19. The computer-readable medium of claim 18 further comprising instructions for performing the steps of, after the first site becomes operational again after a failure:

applying to the first copy all changes that were made to the second copy while the first site was unavailable; and

causing all new changes to said body of data to be initially made at said first site.

20. A computer-readable medium carrying sequences of instructions for maintaining an updatable snapshot at a first site that reflects data stored at a second site, the sequences of instructions comprising instructions for performing the steps of:

periodically transmitting change information from the second site to the first site;

in response to receiving the change information at the first site, revising the snapshot to reflect changes identified in the change information; and

synchronously propagating to said second site changes made to the updatable snapshot at the first site.

21. The computer-readable medium of claim 20 further comprising sequences of instructions for performing the step of making changes made to the updatable snapshot permanent at the first site only after receiving confirmation that the changes were successfully made at the second site.

22. The computer-readable medium of claim 20 wherein the step of revising the snapshot includes the step of determining which changes in said change information apply to data that has been selected for said snapshot.