Transaction identifier-based multi-computer-room synchronization method, computing equipment and storage medium

Abstract

The invention discloses a transaction identifier-based multi-computer-room synchronization method, computing equipment and a storage medium. The method comprises the following steps: reading a first write data log record in a log file of a first machine room, and judging whether a domain identifier contained in a transaction identifier of the first write data log record is consistent with a domain identifier corresponding to the first machine room or not; if yes, performing synchronous data writing operation in a second machine room according to the first data writing log record, and recording a second data writing log record of the synchronous data writing operation and a transaction identifier of the second data writing log record in a log file of the second machine room, wherein the domain identifier contained in the transaction identifier of the second write data log record is set as the domain identifier corresponding to the first computer room; if not, neglecting the synchronization of the first write data log record, so that loop replication is broken, the problem of replication loopback in multi-machine-room bidirectional synchronization is solved, and the data synchronization efficiency is further improved due to the fact that the judgment process is simple.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a multi-computer room synchronization method based on transaction identification, computing equipment and storage media. Background technique [0002] With the growth of business volume and the expansion of business scope, a single computer room often cannot provide stable and reliable services. In this case, deploying multiple computer rooms is a more common choice. At the same time, the data in each computer room must be kept consistent and synchronized to provide accurate and consistent services to the outside world. [0003] Multi-computer room data synchronization is usually realized based on the write data log records of the computer room database. Any data write operation to the computer room database will generate a write data log record in the log file, and replay the write data log record in another computer room to complete a data synchronization. However, th...

AI Technical Summary

Problems solved by technology

However, this synchronization method has the problem of cyclic replication under the two-way synchronization mechanism, that is, after another computer room completes data synchronization, it will also generate a write data log record in the log file, resulting in an infinite loopback problem

[0004] At present, the solution adopted to solve the loopback problem is to add a preset mark in the data operation statement, thereby identifying that the data is synchronized. The above solution not only needs to analyze the specific data, but also leads to excessive data transmission, which affects the synchronization efficiency. Therefore, there is an urgent need for an efficient technical solution that can solve the problem of cyclic replication in the two-way synchronization of multiple computer rooms

Images