Cross-machine-room database data synchronization method and device

Abstract

The embodiment of the invention provides a cross-machine room database data synchronization method and device, and the method comprises the steps: determining first data of a source machine room database; verifying the first data in the source computer room database to obtain a first verification result; verifying the second data of the target computer room database to obtain a second verificationresult; wherein the second data is data obtained after the first data is synchronized to the target machine room; and if the first verification result is inconsistent with the second verification result, controlling the source machine room database to send the first data to the target machine room database again. When data synchronization is carried out, data consistency verification is carried out on the synchronous data, and when the data is inconsistent, the synchronous data is automatically recovered, so that the accuracy of cross-machine-room synchronous data is further ensured.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a data synchronization method across computer room databases and a data synchronization device across computer room databases. Background technique [0002] At present, for some large-scale website businesses, cross-computer room mirror replication of databases, disaster recovery backup, etc. are often considered in terms of system availability. When local data is unavailable due to force majeure factors, system access can be quickly provided through asynchronous database backup or mirroring. [0003] In the Internet industry, the application scenarios of data synchronization in remote computer rooms are very extensive, and each company has its own synchronization system. However, data synchronization across databases in computer rooms cannot directly connect the database in the source computer room to the database in the destination computer room. Data synchronization ca...

AI Technical Summary

Problems solved by technology

[0004] Due to network jitter, human error or data retransmission, the data content of the destination computer room will be inconsistent with the data content of the source computer room.

The data inconsistency in the computer room is difficult to find, and the recovery steps are complicated. When the data in the computer room is inconsistent, the problem is more exposed to the business layer, which will lead to business instability and inaccurate data analysis.

Images