Data synchronization method and relevant device

Abstract

The embodiment of the invention discloses a data synchronization method and a relevant device. The method comprises the steps that a main node acquires redoing logs of a changed page during transaction submission, and a page identifier of the changed page, a current transaction snapshot and log serial numbers are recorded; the main node writes the redoing logs into a storage node, and the redoinglogs are used for the storage node to fix data in the changed page; and the main node sends an invalidity instruction message to a slave node, wherein the invalidity instruction message contains the page identifier, the current transaction snapshot and the log serial numbers and is used for instructing a data page corresponding to an invalid page identifier of the slave node, determining version information of a data page visible to the message according to the current transaction snapshot and acquiring a data page successfully fixed through a target redoing log from the storage node, and theserial number of the target redoing log is greater than or equal to the log serial number corresponding to the version information. By the adoption of the embodiment, data synchronization efficiency and accuracy are improved.

Description

technical field [0001] The invention relates to the field of databases, in particular to a data synchronization method and related equipment. Background technique [0002] At present, the application of cloud computing is becoming more and more common. "Cloud" can be used for storage and computing. "Cloud" is a group of computers. Each group includes hundreds of thousands or even millions of computers. The computer can be updated at any time, ensuring that the "cloud" is immortal. Using cloud computing technology, users don't need to care about which "cloud" the storage or calculation takes place on, and they can quickly calculate and find data at any place using any device (such as a computer, mobile phone, etc.), and don't need to worry about data loss . Among them, the database, as the core basic component of cloud computing, provides users with reliable cloud database services. The "cloud" environment has the following characteristics: (1) computing and storage are se...

AI Technical Summary

Problems solved by technology

Among them, since most of the mechanisms are used to fill holes with other storage nodes, there is a shortage of data in some storage nodes, and it is necessary to coordinate with other nodes to obtain

However, the writing mechanism of the above scheme is too complicated, and the log storage node that receives the redo log needs to cooperate with other storage nodes to maintain a consistent state. As a result, it takes too long to fill the vacancy, which affects the read service

Moreover, transferring redo logs between the master computing node and the slave computing nodes, and a large number of filling vacancies of the storage nodes will occupy a large amount of network resources

Images