Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Follow the feed
Showing entries 1 to 1 of 1 « Previous | Next »
Displaying posts with tag: md5sum (reset)
Apr
12
2010
pager md5sum - the quick way to compare results
Posted by Trent Hornibrook on Mon 12 Apr 2010 05:37 UTC
Tags:

I had a QA boffin email me with a question around the validity of data for a specific row in a development slave. Heres how I checked for him.

I set the pager output to md5sum. Heres an example:

Slave:
mysql> pager md5sum -
PAGER set to 'md5sum -'
mysql> select * from Residential where PropertyNumber = 106360678\G
0b07947002b59de27b6979fdcb57905a -
1 row in set (0.00 sec)


Master:
mysql> pager md5sum -
PAGER set to 'md5sum -'
mysql> select * from Residential where PropertyNumber = 106360678\G
1c6ac79d3fb2fd994ceb97406e9f2b1a -
1 row in set (0.00 sec)


Now onto why the slave is out of sync....