The invention relates to the technical field of
database synchronization, in particular to a multi-node
database synchronization method based on
data partitioning, which comprises the following steps of: 1, performing
data partitioning and node role allocation; 2, synchronization mechanism configuration, wherein the synchronization mechanism configuration comprises master and slave node copy setting and data initialization and import; 3, incremental
data synchronization, asynchronous / semi-synchronous replication and conflict detection; 4, using a protocol to optimize large file and
mass data transmission; step 5, performing
parallel processing on the fragmented data at a plurality of nodes; and step 6, carrying out redundant
backup on the data fragments at a plurality of nodes. According to the invention, data division and node role allocation are carried out; and data distribution: routing the change event to a corresponding node according to a fragmentation rule, or
broadcasting a write set through a group communication protocol, carrying out redundant
backup on the data fragmentation at a plurality of nodes, and finally checking the consistency of the fragmentation data regularly, so that the method has the advantages of being capable of realizing efficient synchronization of the multi-node
database, giving consideration to the performance and the consistency and the like.