Good day everyone
I am hoping someone can assist me here.
I have always used pt-table-checksum to verify integrity on master-slave replication and we had our own processes in place to sync those.
However, I recently started looking at someone else’s databases and came across pt-table-sync option.
I do have some questions regarding the use of pt-table-sync however before I run this in order to ensure I do not overwrite data due to incorrect usage.
The databases is in a master-master replication setup and while syncing the tables , the replication from master2 back to master1 has been disabled temporarily.
I have run pt-table-checksum and have a list of databases and tables that are out of sync.
I now need to run pt-table-sync to actually synchronize the tables, however here are my questions / concerns :
- on which one of the hosts do I actually run the pt-table-sync command? (master2 is the database that is mostly out of sync)
- Despite the dry_run option as per the command below (will change to execute once I am happy with the command, or even to print and then process output from there) , is the command I have below correct?
pt-table-sync --dry-run --wait=0 --sync-to-master h=<ip of master2 [slave]>,u=checksum_user,p= --replicate percona.checksums
I would really appreciate the help here as I have not used this tool before and thus very cautious.