Multi-computer room synchronization method, computing equipment and storage medium based on transaction identification

Abstract

The invention discloses a multi-computer room synchronization method, computing equipment and storage medium based on transaction identification. The method includes: reading the first write data log record in the log file of the first computer room, and judging whether the domain identifier contained in the transaction identifier of the first write data log record is consistent with the domain identifier corresponding to the first computer room; if , then execute the write synchronization data operation in the second computer room according to the first write data log record, and record the second write data log record and its transaction identifier of the write synchronization data operation in the log file of the second computer room, wherein, the second The domain identifier contained in the transaction identifier of the write data log record is set as the domain identifier corresponding to the first computer room; if not, the synchronization of the first write data log record is ignored, which breaks the cyclic replication and solves the two-way problem of multiple computer rooms. The problem of replication loopback in synchronization, because the judgment process is simple, further improves the efficiency of data synchronization.

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