search

BenMorel / mysql-replication-check

A tool to checksum a MySQL slave against its master
MIT License
7 stars 1 forks source link

Add a --databases option #11

Open BenMorel opened 1 year ago

BenMorel commented 1 year ago

It's very common to check a whole database, so having to use --tables=database1.*,database2.* is cumbersome.

It would help if we could use --databases=database1,database2.

If both --tables and --databases was used, we would just merge the two results.

When using --databases, we could add a check that the slave does not have tables not present on the master (check that makes little sense when providing a pattern of tables, so currently not present).

mokraemer commented 10 months ago

so you don't sync the whole server, just some databases? We just use this call mysql-replication-check.php --master-host db1 --slave-host db2 -q