Method and device for abnormity detection in data synchronization

Abstract

The invention aims at providing a method and device for abnormity detection in data synchronization. Specifically, the method comprises the following steps: determining a target range corresponding to synchronous data to be detected in a backup database in the synchronization process of a main database and the backup database; obtaining benchmark data corresponding to the target range; and detecting whether the synchronous data to be detected is consistent to corresponding data in the main database according to the benchmark data. Compared with the prior art, the method and device for abnormity detection in data synchronization have the advantage of efficiently and correctly realizing the consistency detection of the synchronous data between the main database and the backup database in real time through determining the target range to be detected in the backup database and the benchmark data corresponding to the target range in the synchronization process of the main database and the backup database, and detecting whether the synchronous data to be detected in the backup database is consistent to the corresponding data in the main database according to the benchmark data.

Description

technical field [0001] The present application relates to the field of computers, and in particular to a technology for anomaly detection in data synchronization. Background technique [0002] In the prior art, a typical deployment mode of a database system is an active-standby mode, that is, a database system consists of a main database and a backup database corresponding to the main database. Among them, the database system ensures the data consistency of the primary database and the backup database through a data synchronous replication mechanism. Specifically, when performing a data update operation on the database system, the data to be updated is written into the primary database, and after the data writing is completed, the data is synchronously copied to the backup database. In this way, if the primary database fails, the backup database can take over the tasks of the primary database to continuously provide data services to users, thereby achieving the purpose of d...

AI Technical Summary

Problems solved by technology

[0003] In the process of synchronous data replication between the primary database and the backup database, because the data needs to go through processing links such as parsing, transmission, and writing, there may be hidden dangers such as data loss and damage in any processing link, resulting in synchronization to the backup database. Errors occur in the data in the database, which may cause the backup database to fail to run normally after taking over the tasks of the primary database

In this case, the synchronous replication mechanism will not be able to guarantee the data consistency of the primary database and the backup database 100%.

[0004] At present, the self-verification technology for the data synchronization and replication process between the primary database and the backup database is almost blank

Moreover, even if the self-verification function is added to the data synchronization replication mechanism of the primary database and the backup database, the performance of the data synchronization replication process itself will be seriously affected to a certain extent due to the verification of the synchronization data while the data synchronization is being replicated. decline

In addition, if the data synchronization replication process itself is abnormal, the self-verification function will not be able to perform effectively

Images