Method and device for detecting consistency of data of MySQL master and slave servers

Abstract

The invention discloses a method for detecting consistency of data of MySQL master and slave servers. The method comprises the steps of setting default storage engines of the master and slave servers to be InnoDB; performing special database operation in the master sever, wherein the operation is to be written into a binlog file of the master server; determining whether the current database operation to be written into the binlog file is the special database operation by the master server while writing into the binlog file; if so, exporting the master server data; determining whether the currently-performed database operation is the special database operation while reading and implementing content of the binlog file written in the master server through a sever; if so, exporting the slave server; determining whether the exported master server data are the same as the exported master slave data; if so, determining that the exported master server data are consistent to the exported master slave data. The invention further provides a device for detecting consistency of data of the MySQL master and slave servers. With the adoption of the method and device, whether the consistency of the master and slave servers data can be accurately detected at a time.

Description

technical field [0001] The application relates to the field of master-slave server data consistency detection, and specifically relates to a method for MySQL master-slave server data consistency detection; the application also provides a device for MySQL master-slave server data consistency detection. Background technique [0002] MySQL is a relational database management system that speeds up data access and improves flexibility by storing data in different tables instead of putting all data in one large warehouse. In order to achieve server load balancing and enhance the ability of the database system to resist disasters, the MySQL database system, like other popular database systems, also adopts a master-slave synchronization architecture, that is: the system includes two servers: the master server and from the server. The purpose of adopting the above-mentioned architectural approach has the following two aspects. First of all, only the data update operation can be imp...

AI Technical Summary

Problems solved by technology

[0008] First, the possibility of misjudgment cannot be fundamentally avoided

Because the master-slave is in the process of dynamic update, if the master and slave servers are busy (for example: in the case of a large number of update requests), the second query may still be misjudged, and even multiple misjudgments may occur

[0009] Second, performing query operations on the master and slave servers multiple times will cause unnecessary pressure on the server, which will affect the response speed of the server to user business

Images