Method, device and system for database synchronization

Abstract

The invention relates to the technical field of internet and especially relates to a method, a device and a system for synchronizing databases. The synchronizing method comprises the following steps: arranging a synchronizing device independent from a main database and a spare database and respectively communicating the synchronizing device with the main database and the spare database; sending a synchronizing request to the main database by the synchronizing device; responding to the synchronizing request by the main database and sending a synchronizing log of the main database to the synchronizing device; analyzing the synchronizing log by the synchronizing device and acquiring data changing information of the main database; sending the acquired data changing information to the spare database by the synchronizing device and performing data synchronization on the main and spare databases according to the data changing information. Through the synchronizing device provided by the invention, if the main database collapses during the synchronizing process, the data backup does not depend on the running state of the main database because the synchronizing log recording the data changing information is stored in the synchronizing device, and the data synchronization is performed by the spare database according to the synchronizing log with zero loss.

Description

technical field [0001] The invention relates to the technical field of the Internet, in particular to a database synchronization method, device and system. Background technique [0002] More and more enterprises use database products such as MySql open source database for data storage and application. In case of a disk failure, the data of the MySql database will be lost. In order to avoid the occurrence of the above situation, the data is generally synchronized to another server asynchronously by setting up MySql replication. This method can ensure that the data is not completely lost to a certain extent, but its disadvantage is that due to the redo log or binary log data Still in memory, when the MySql database crashes, the data cannot be persisted. Asynchronous replication cannot guarantee that all MySql data is fully synchronized to another server, and zero loss cannot be achieved. Contents of the invention [0003] The object of the present invention is to provide a...

AI Technical Summary

Problems solved by technology

In order to avoid the occurrence of the above situation, the data is generally synchronized to another server asynchronously by setting up MySql replication. This method can ensure that the data is not completely lost to a certain extent, but its disadvantage is that due to the redo log or binary log data Still in the memory, when the MySql database crashes, the data cannot be persisted. Asynchronous replication cannot guarantee that all MySql data is completely synchronized to another server, and zero loss cannot be achieved.

Images