Make pt-table-sync output exact diffs instead of queries

Registered by Mrten on 2012-08-13

Some time ago, I wrote a script to show me the exact differences between master and replication slave based on the checksum table generated by mk-table-sync. I did this so I could figure out what queries on the master could have caused these differences in replication (which worked out).

Now, I'm in the process of upgrading all servers to 5.5 and I've noticed differences in the replication from a 5.1 to a 5.5 server, so I figured I'd dust off the script so see what it could show me. So I spent today fixing it up because of the changed checksum table format and while doing that it occurred to me that pt-table-sync could also output the exact differences between master and slave, because I suppose it already has all information.

So here's the wistlist request: Could pt-table-sync --print be made to output more than queries?

Blueprint information

Status:
Not started
Approver:
None
Priority:
Undefined
Drafter:
None
Direction:
Needs approval
Assignee:
None
Definition:
New
Series goal:
None
Implementation:
Unknown
Milestone target:
None

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.