mysql database replication master slave sync checks checksums and resync tables script
$30-5000 USD
Dibatalkan
Dibuat hampir 12 tahun yang lalu
$30-5000 USD
Dibayar ketika dikirim
I need mysql replication scripts that will show any tables from databases that are not identical on master and slave.
So , run one script, for each database, lists the database and the tables that have mismatched table checksums etc...
2. other scripts which will quickly let me resync those tables from the master to the slave...
The scripts may use if you want the percona/maatkit toolkit.
Ideally it should support maatkit-7540 since I have it installed, but I can install the newest versions if need be etc..
They should work on a mysql version 4.1.21 master+slave setup.
and also on separate Mysql version 5.5.25a master+slave setup.
Currently I had been using a script, but I noticed that sometimes it would say some tables do not match, but when I did a mysqldump of the tables from master and host and did a "diff" there was no difference so I don't know where the problem/error lies in the script but I can't trust it since it seems to say some tables are out of sync when in fact they are identical.
I'm attaching the script for reference...
## Deliverables
attached example script I use which doesn't seem too good, it says table checksums mismatch on some tables which mysqldumps of prove are identical. (on a moodle database for example mdl_quiz_grades for some reason shows up mismatching with this cript when its actually identical even after I've manually imported again from the master..)