Hybrid data replication

Patent metadata

Field	Value
Publication number	US-9672126-B2
Application number	US-201113326892-A
Country	US
Kind code	B2
Filing date	Dec 15, 2011
Priority date	Dec 15, 2011
Publication date	Jun 6, 2017
Grant date	Jun 6, 2017

Abstract

System, method, computer program product embodiments and combinations and sub-combinations thereof for hybrid data replication are described. Aspects include identifying a type of database data replication, the type including a combination of replication approaches, and managing replication based on the identified type, including coordinated switching from one replication approach to another automatically with transactional consistency maintained among source and target databases.

First claim

What is claimed is:

1. A computer-implemented method, the method comprising:
identifying, by a computing device and upon completion of a load process, within a hybrid data replication process, a type of database data replication, the type including a snapshot replication approach and a continuous replication approach, each approach occurring during the hybrid data replication process;
receiving, by the computing device, replication process markers that determine how database data replication is to change during the hybrid data replication process, wherein the replication process markers identify whether transactions were suspended during the load process;
determining, based on the markers, that a first set of data was not suspended, and a second set of data was suspended;
compiling a set of transactions that occurred on the second set of data during a suspended period, wherein the compiling occurs in parallel with the first set of data continuing to replicate using the continuous replication approach based on a first compilation; and
applying the compiled set of transactions to the second data set.

2. The computer-implemented method of claim 1 wherein the type further comprises a combination of log-based replication followed by non-log-based replication, complete non-log-based replication followed by incremental non-log-based replication, and non-log-based replication followed by log-based replication.

3. The computer-implemented method of claim 1 , wherein one or more compensating components perform the determining, compiling, and applying.

4. The computer-implemented method of claim 3 further comprising utilizing the compensating components for replication without complete suspension, wherein the set of transactions for a table storing the second set of data are suspended while the table is being materialized, and while the continuous replication approach for the non-materialized first set of data stored in a second table continues.

5. The computer-implemented method of claim 1 wherein the type changes based on a level of a table of database data, a publisher of database data, and a subscriber of database data.

6. The computer-implemented method of claim 1 wherein the type changes among tables of a same source database.

7. The computer-implemented method of claim 6 wherein coordinated switching for one table occurs while replication of another table continues uninterrupted.

8. The computer-implemented method of claim 1 , further comprising:
managing multiple replication approaches in parallel, including a log and non-log based replication approach.

9. The method of claim 1 wherein a manager identifies the strategy policy for the non-materialized second table for database data replication.

10. The method of claim 1 wherein the continuous replication is log-based and wherein the snapshot replication is not log based.

11. The method of claim 1 , wherein the replication process markers are used during the snapshot replication to support a switchover to the continuous replication.

12. The method of claim 1 , wherein the materialization is atomic.

13. A system for hybrid data replication in a database system environment, the system comprising:
a source database;
a target database; and
a replication processing system in communication with the source database and target database, replication processing system configured to:
identify, within a hybrid data replication process and upon completion of a load process, a type of database data replication, the type including a snapshot replication approach and a continuous replication approach, each approach occurring during the hybrid data replication process;
receive replication process markers that determine how database data replication is to change during the hybrid data replication process, wherein the replication process markers identify whether transactions were suspended during the load process;
determine, based on the markers, that a first set of data was not suspended, and a second set of data was suspended;
compile a set of transactions that occurred on the second set of data during a suspended period, wherein the compiling occurs in parallel with the first set of data continuing to replicate using the continuous replication approach based on a first compilation; and
apply the compiled set of transactions to the second data set.

14. The system of claim 13 wherein the type further comprises a combination of log-based replication followed by non-log-based replication, complete non-log-based replication followed by incremental non-log-based replication, and non-log-based replication followed by log-based replication.

15. The system of claim 13 , wherein one or more compensating components are configured to perform the determining, compiling, and applying.

16. The system of claim 15 wherein the replication processing system further utilizes the compensating components for replication without complete suspension, wherein the set of transactions for a table storing the second set of data are suspended while the table is being materialized, and while the continuous replication approach for the non-materialized first set of data stored in a second table continues.

17. The system of claim 13 wherein the type changes based on a level of a table of database data, a publisher of database data, and a subscriber of database data.

18. The system of claim 13 wherein the type changes among tables of a same source database.

19. The system of claim 18 wherein coordinated switching for one table occurs while replication of another table continues uninterrupted.

20. The system of claim 13 wherein the replication processing system further manages multiple replication approaches in parallel, including a log and non-log based replication approach.

21. A computer program product having control logic stored therein embodied within a non-transitory computer readable medium, said control logic enabling a processor to perform hybrid data replication in a database system environment, the control logic comprising:
computer readable program code enabling a processor to:
identify, within a hybrid data replication process and upon completion of a load process, a type of database data replication, the type including a snapshot replication approach and a continuous replication approach, each approach occurring during the hybrid data replication process;
receive replication process markers that determine how database data replication is to change during the hybrid data replication process, wherein the replication process markers identify whether transactions were suspended during the load process;
determine, based on the markers, that a first set of data was not suspended, and a second set of data was suspended
compile a set of transactions that occurred on the second set of data during a suspended period, wherein the compiling occurs in parallel with the first set of data continuing to replicate using the continuous replication approach based on a first compilation; and
apply the compiled set of transactions to the second data set.

22. The computer program product of claim 21 wherein the type further comprises a combination of log-based replication followed by non-log-based replication, complete non-log-based replication followed by incremental non-log-based replication, and non-log-based replication followed by log-based replication.

23. The computer program product of claim 21 , the computer readable program co

Assignees

• Dewall Rhett Dondi
• Shang Heping
• Sybase Inc

Inventors

• Dewall Rhett Dondi
• Shang Heping

Classifications

• G06F2201/84

  Using snapshots, i.e. a logical point-in-time copy of the data · CPC title

• G06F2201/80

  Database-specific techniques · CPC title

• G06F11/1662

  the resynchronized component or unit being a persistent storage device (re-synchronization of failed mirror storage G06F11/2082; rebuild or reconstruction of parity RAID storage G06F11/1008) · CPC title

• G06F16/2379

  Updates performed during online database operations; commit processing · CPC title

• G06F16/2358

  Change logging, detection, and notification (replication G06F16/27) · CPC title