Method, device, equipment and storage medium for data synchronization

Abstract

The present application provides a method, device, device and storage medium for data synchronization, the method comprising: receiving a database instruction provided by a business end; parsing the database instruction to determine the type of the database instruction; if the type of the database instruction is a data manipulation instruction or Data definition instruction, set the capture context in the thread context of the current running thread; call the current running thread to execute the database command; save the update result of the database after the database command is executed according to the capture context; send the update result to the consumer end of the database, so that The consumer realizes data synchronization based on the update result. This solution directly captures and sends the update result of the database to the consumer, so that the consumer does not need to process log data that is not related to the update result during data synchronization, and improves the efficiency of data synchronization at the consumer.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular to a data synchronization method, device, equipment and storage medium. Background technique [0002] When operating a database on the business side, it is often necessary to synchronize the operations on the database to the consumer side of the database. This process is called data synchronization. The consumer side can refer to the program that needs to use the data of the database. Specifically, it can be It can be other databases, or other applications. [0003] For example, after adding or deleting some data in the database, the consumer needs to add or delete the same data locally, so as to ensure that the consumer uses the latest data of the database. [0004] An existing database synchronization technology is that the database regularly sends its own redo log (Redo Log) to the consumer side of the database. The Redo Log contains all recent operation records of the...

AI Technical Summary

Problems solved by technology

[0005] However, the database often receives batch processing instructions (such as instructions to delete or update a batch of data that meet specific conditions), and the database needs to parse the batch processing instructions into specific operation instructions. The parsing process will also be recorded in RedoLog, and consumption The parsing process does not need to be repeated when the end realizes data synchronization, so in the prior art, the consumer end needs to waste a lot of time parsing the Redo Log, resulting in low efficiency of data synchronization

Images