A distributed data synchronization system and method

Abstract

The invention relates to the technical field of database application, and discloses a distributed data synchronization system and method. In the present invention, the distributed data synchronization system includes a server main station and several server substations; the server main station is the data sending end, and the server substations are the data receiving ends; or the server main station is the data receiving end, and the server substations are the data sending ends; The data synchronization method includes the following steps: the data sending end detects the state of the data to be synchronized in real time, and only sends the data update log to the data receiving end according to the preset data format; the data receiving end receives the data from the data sending end in real time, The data item in the data update log is assigned to the corresponding data item in the data receiving end, so that the data of the data receiving end and the data sending end are consistent. In this way, the data is updated in a timely manner, the pressure is balanced, and the requirements on the server are reduced. At the same time, the data transmission amount is small, the communication flow is saved, and the communication burden is reduced.

Description

technical field [0001] The invention relates to the technical field of database applications, in particular to a distributed data synchronization system and method. Background technique [0002] Different branches of large enterprises are distributed in different regions, and modern enterprises require unified information management. Based on this requirement, there are usually two implementation schemes at present. One is the single database method, that is, the head office and branches use the same database; the other is the multi-database method, that is, each branch uses its own independent database, and then the data in the branch database and the data in the head office database are combined Synchronize. [0003] Among them, the advantage of the single database method is that the data is timely, but the disadvantage is that once there is a problem with the public network, the system will not be able to be used normally, and all performance pressures are concentrated ...

AI Technical Summary

Problems solved by technology

[0003] Among them, the advantage of the single database method is that the data is timely, but the disadvantage is that once there is a problem with the public network, the system will not be able to be used normally, and all the performance pressure is concentrated on the head office.

The advantage of the multi-database method is that it is not affected by the public network, and the performance pressure is distributed among the branches. The disadvantage is that the head office cannot know the data of the branches in real time, and the data of the head office and the branches are synchronized on the public network and face the risk of data leakage.

Images