Is your Replications in Sync?

April 12, 2010

Here is a quick way to see if your replicated tables are in sync. I found this on http://www.mysqldbahelp.com/2010/04/pager-md5sum-quick-way-to-compare.html I haven’t tested this yet. I’ll update it when I do.

I set the pager output to md5sum. Here is 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)

Tweet

tags: ,
posted in Commentary by mark

Follow comments via the RSS Feed | Leave a comment | Trackback URL

Leave Your Comment

 



Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org
Creative Commons License
MySQL Fan Boy by Mark Grennan is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.
HOME