A Data Consistency Checking Method for Cross-Computer Room Databases

Abstract

A method for data consistency verification across a computer room database, comprising: 1: setting of a consistency verification environment, specifically: deploying a master node database and a subnode database in computer rooms in various regions, and each database is provided with The same table structure; 2) Configure the verification task information. The verification task information includes the frequency of verification execution, the database tables with verification requirements, and the table fields with verification requirements; 3) According to the frequency of verification execution, each After a fixed period of time, the master node database actively triggers the verification task; 4) After each subnode database receives the verification task information, it extracts the database, data table and table field information instructions in the information; 5) The master node database keeps receiving the information The status of the data sent by each sub-node database, while receiving the verification results, compare the verification results, and determine whether the verification results of each sub-node are consistent.

Description

technical field [0001] The invention belongs to the field of online data interaction of multiple databases, and in particular relates to a data consistency verification method for cross-computer room databases. Background technique [0002] With the development of the B2B e-commerce industry, there are more and more Internet service businesses, and the user base is also increasing. In order to ensure the reliability, the website will be deployed in computer rooms in different regions, and the database system will be deployed in each computer room. , and provide a complete website service, and the data between the databases of each computer room is copied to each other to ensure that each computer room has a complete set of data. However, the biggest challenge of multi-computer rooms is the data update delay caused by network delay between the computer rooms, which eventually leads to data inconsistency between the databases of each computer room. In the existing master-stan...

AI Technical Summary

Problems solved by technology

Although the patent can locate the data with differences with a small amount of calculation and network data transmission, the patent still only stays in the research on the consistency verification of the main and standby databases, and the verification in the form of groups is not necessary. It is suitable for a large amount of inconsistent data, but it will cause the problem of repeated data query due to inconsistent data scattered in different groups. At the same time, the patent does not give a clear solution on how to realize automatic timing verification of data between cross-regional databases

Images