Cross-room database synchronization method and system

Abstract

The invention discloses a cross-room database synchronization method which is used for performing cross-room data synchronization on a target database from a source database. The cross-room database synchronization method comprises step 100, monitoring changes of the source database at a source database terminal; step 110, extracting change data of the source database in turn through a plurality of parallel processes which are serially numbered; step 120, sending the extracted data through the parallel processes after combination and compression; step 130, receiving the data sent from the parallel processes at a target database terminal, loading according to the order of the parallel processes to obtain data to be synchronized and updating the target database according to the data to be synchronized. According to the cross-room database synchronization method and device, the thinking of multi-threaded parallel processing is adopted, the characteristics of SQL (Structured Query Language) semantic execution are adopted, and accordingly the problem of the synchronization delay of a cross-room and cross-regional network can be alleviated through the complete transmission scheme such as data combination, compression and parallel processing.

Description

technical field [0001] The present application relates to the field of computer and network technologies, and in particular to a method and system for synchronous transmission of databases across computer rooms. Background technique [0002] At present, for some large-scale website businesses, cross-computer room mirror replication of databases, disaster recovery backup, etc. are often considered in terms of system availability. When local data is unavailable due to force majeure factors, system access can be quickly provided through asynchronous database backup or mirroring. [0003] When doing database synchronization, the current general practice is to analyze the change log of the database DML / DDL, send it to the target database, and then re-execute the database DML / DDL change to achieve consistency between the databases on both sides. This approach is aimed at database synchronization across computer rooms and cross-regional networks. One of the problems is the amount o...

AI Technical Summary

Problems solved by technology

[0016] 3) The mysql change log file binlog records each database change in detail, which can be used to analyze the historical change records of the database after detailed viewing by the DBA (database administrator). It is not specially designed for efficient synchronization of the database, so it exists A lot of redundant data, resulting in a huge amount of data

[0017] Aiming at the synchronous business across computer rooms and cross-regional networks, the traditional single tcp working mode will generate data accumulation and cause network congestion when faced with database change synchronization during peak hours

Images