Automated online upgrade of database replication

Patent metadata

Field	Value
Publication number	US-11630814-B2
Application number	US-202017117272-A
Country	US
Kind code	B2
Filing date	Dec 10, 2020
Priority date	Dec 10, 2020
Publication date	Apr 18, 2023
Grant date	Apr 18, 2023

Abstract

In an approach to improve online database replication by automating the upgrading of a database replications system online. Additionally, embodiments of the present invention stop an upgrade using a first incremental update strategy on data of a source database, identify an earliest open transaction from a first database to a second database, and identify a last committed log record identifier. Further, embodiments of the present invention execute an adaptive apply strategy on transactions including the earliest open transaction until the last committed log record identifier is reached by the adaptive apply strategy, and resume, by upgrade controller, the upgrade with a second incremental update strategy.

First claim

What is claimed is:

1. A computer-implemented method for automated upgrading of a database replications system online, the method comprising:
determining a consistency of one or more tables in a source database by analyzing one or more open transactions on a replicated table, wherein an earliest open transaction is retrieved to identify the one or more open transactions on the replicated table;
responsive to determining a consistency within the one or more tables of the source database, stopping, by an upgrade controller, an upgrade using a first incremental update strategy on data of the source database, wherein the upgrade controller exploits interfaces based on various incremental update strategies;
responsive to determining there is an earliest open transaction, identifying an earliest open transaction from the source database to a target database;
identifying, by the upgrade controller, a last committed log record identifier;
communicating the identified earliest open transaction and the identified last committed log record identifier to a second incremental update strategy, wherein the communication triggers an adaptive apply strategy;
executing the adaptive apply strategy on one or more transactions including the earliest open transaction until the last committed log record identifier is reached by the adaptive apply strategy; and
resuming, by the upgrade controller, the upgrade with the second incremental update strategy.

2. The method of claim 1 , wherein resuming the upgrade comprises:
transferring an update replication to the second incremental update strategy; and
adopting and executing a newer replication technology.

3. The method of claim 1 , further comprising:
outputting, to a computing device, a notification to alert a user that the upgrade or replication is either complete or has failed, wherein the user interacts with the notification through a user interface on the computing device.

4. The method of claim 1 , wherein executing the adaptive apply strategy further comprises:
deleting one or more changes that have been replicated as inserts, wherein the deleting one or more changes that have been replicated as the inserts includes deleting one or more actual inserts and actual updates;
deleting one or more changes that have been replicated as deletes; and
inserting one or more changes that have been replicated as inserts.

5. The method of claim 1 , further comprising:
executing, by the upgrade controller, the upgrade, wherein the upgrade comprises:
synchronizing metadata associated with a replication process and one or more replicated tables; and
establishing synchronization of a hand over on a per table granularity in terms of in-flight transactions.

6. The method of claim 1 , further comprising:
querying metadata of an existing replication technology to determine table mappings, wherein the metadata is received from the query of the existing replication technology, and is used to establish table mappings in an integrated synchronization for metadata of the integrated synchronization, and wherein integrated synchronization is able to replicate data description language.

7. The method of claim 1 , further comprising:
preventing a loss of data when switching from a first replication technology to a second replication technology, wherein the preventing the loss of data comprises:
applying changes from tables to one or more specific log positions from an existing replication technology; and
retrieving the changes from the one or more log positions by integrated synchronization.

8. A computer program product for automated upgrading of a database replications system online, the computer program product comprising:
one or more computer readable storage media and program instructions stored on the one or more computer readable storage media, the stored program instructions comprising:
program instructions to determine a consistency of one or more tables in a source database by analyzing one or more open transactions on a replicated table, wherein an earliest open transaction is retrieved to identify the one or more open transactions on the replicated table;
responsive to determining a consistency within the one or more tables of the source database, program instruction to stop, by an upgrade controller, an upgrade using a first incremental update strategy on data of the source database, wherein the upgrade controller exploits interfaces based on various incremental update strategies;
program instruction to identify an earliest open transaction from the source database to a target database;
program instruction to identify, by the upgrade controller, a last committed log record identifier;
program instructions to communicate the identified earliest open transaction and the identified last committed log record identifier to a second incremental update strategy, wherein the communication triggers an adaptive apply strategy;
program instruction to execute the adaptive apply strategy on one or more transactions including the earliest open transaction until the last committed log record identifier is reached by the adaptive apply strategy; and
program instruction to resume, by upgrade controller, the upgrade with the second incremental update strategy.

9. The computer program product of claim 8 , wherein resuming the upgrade comprises:
program instruction to transfer an update replication to the second incremental update strategy; and
program instruction to adopt and execute a newer replication technology.

10. The computer program product of claim 8 , further comprising:
program instruction to output, to a computing device, a notification to alert a user that the upgrade or replication is either complete or has failed, wherein the user interacts with the notification through a user interface on the computing device.

11. The computer program product of claim 8 , wherein executing the adaptive apply strategy further comprises:
program instruction to delete one or more changes that have been replicated as inserts, wherein the deleting one or more changes that have been replicated as the inserts includes deleting one or more actual inserts and actual updates;
program instruction to delete one or more changes that have been replicated as deletes; and
program instruction to insert one or more changes that have been replicated as inserts.

12. The computer program product of claim 8 , further comprising:
program instruction to execute, by the upgrade controller, the upgrade, wherein the upgrade comprises:
program instruction to synchronize metadata associated with a replication process and one or more replicated tables; and
program instruction to establish synchronization of a hand over on a per table granularity in terms of in-flight transactions.

13. The computer program product of claim 8 , further comprising:
program instruction to query metadata of an existing replication technology to determine table mappings, wherein the metadata is received from the query of the existing replication technology, and is used to establish table mappings in an integrated synchronization for metadata of the integrated synchronization, and wherein integrated synchronization is able to replicate data description language.

14. The computer program product of claim 8 , further comprising:
program instruction to prevent a loss of data when switching from a first replication technology to a second replication technology, wherein the preventing the loss of data comprises:
program instruction to apply changes from tables to one or more specific log positions from an existing replication technology; and

Assignees

• IBM

Inventors

• Butterstein Dennis
• Beier Felix
• Lueck Einar
• Perathoner-Tschaffler Sabine

Classifications

• G06F11/1474

  in transactions (updating of structured data in databases G06F16/23) · CPC title

• G06F16/2282

  Tablespace storage structures; Management thereof · CPC title

• G06F16/27

  Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor · CPC title

• G06F11/1471

  involving logging of persistent data for recovery · CPC title

• G06F2201/81

  Threshold · CPC title