Database synchronization method and database system

Abstract

The invention discloses a database synchronization method and system. The method comprises the steps that a main database and a sub-database are divided into a plurality of zones, and each main data zone and each sub data zone are respectively provided with a main binary system journal file and a sub binary system journal file. When data changing happens in the main data zones, data changing is recorded in the main binary system journal files, the data changing record is transmitted to the sub-database, data changing is recorded in the sub binary system journal files, and data changing is carried out in the sub data zones of the sub-database. According to the method and the database system, the database is divided into the zones, the binary system journal files are arranged corresponding to the database zones, multithreading concurrent processing binary system journal file synchronization is used, and the problem that during a binary system journal file synchronization process, database end playback is slow, and database end system resource using rate is low is solved. In addition, data of the main database is transmitted to the sub-database end in a batch mode, and data lost from the sub-database end are reduced as much as possible.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database synchronization method and a database system. Background technique [0002] In the application of the database, the master-slave-slave mode is generally adopted for the system with a huge amount of visits. This method can reduce the pressure on the database. The binary log Binlog is often used in the database system to record the DDL and DML (except data query statements) statements that the system has currently executed. These statements are backed up to the binlog in real time in the form of events, reflecting the changes of data in the database. Binlog has two main functions in the database system: as a real-time backup of database system data, binlog can be used for data recovery when an exception occurs in the database system; binlog is also used for master-slave data replication of the database system cluster, and the master node Its binlog is passed to the s...

AI Technical Summary

Problems solved by technology

Moreover, in the process of database synchronization, the slave node usually uses a single thread to synchronize the binlog, and the master node sends much faster than the slave node, and the processing speed is slower, which will cause the data lag of the slave node, and the single thread cannot make full use of system resources, which often occurs When the slave node data is seriously lagging behind, the system resource usage is low

When the slave node data lags behind, if the master node is abnormal, the data that the master node has not sent to the slave node will be lost, resulting in the failure of data synchronization

Images