Data consistency verifying method for cross-machine-room database

Abstract

A data consistency verifying method for a cross-machine-room database comprises the steps that 1, a consistency verifying environment is set, wherein a main node database and a sub-node database are deployed in a machine room of each region, and identical list structures are arranged in the databases; 2, verifying task information is configured, wherein the verifying task information comprises thefrequency of verification execution, a database list with verifying needs and list fields with verifying needs; 3, the main node databases actively trigger verifying tasks every other fixed time periods according to the frequency of verification execution; 4, after the sub-node databases receive the verifying task information, databases, data lists and list field information instructions in the information are extracted; 5, the main node databases keep the state of receiving data sent by the sub-node databases all the time, verifying results are received, the verifying results are compared atthe same time, and whether the verifying results of all sub-nodes are consistent or not is judged.

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