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....
Showing entries 1 to 1
Apr
12
2010
Showing entries 1 to 1