Archive for the ‘pager’ Category

pager md5sum — the quick way to compare results

Апрель 12th, 2010
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....

PlanetMySQL Voting: Vote UP / Vote DOWN
 

Posted in md5sum, mysql, pager

Комментарии отключены