Running pt-table-checksum before pt-table-sync?

I’m sure there are many reasons to run pt-table-checksum before pt-table-sync but I don’t know all the reasons. If I know there are inconsistencies between two databases, is it good enough to just run pt-table-sync --print to see the differences and then sync the changes afterward if they appear to be correct?

Hi Ron, welcome back to the forum. The reason for running pt-table-checksum first is that you can get a picture of each replica status afterwards, by querying the generated checksum summary table on each replica to see if there are any differences with the primary. Other than that, you can run the sync directly if you don’t care.