How to compare the data between Mysql master and slave databases

This article mainly tells you how to compare the data between the master and slave databases of Mysql. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope this article can bring some practical help to you how to compare the data between Mysql master and slave databases.

First, it is used to count and check whether the records of each table on the database are consistent.

Use information_schema

Select table_name,table_rows from tables where TABLE_SCHEMA = 'your database name' order by table_rows desc

2. The export results are as follows

Third, based on the above statements, execute between the master database and the slave database, and export to the EXCEL table to compare the differences.

Mysql master and slave database data should be compared to tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

Mysql master and slave database data should be compared to tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.