'Replication' Tag

• Slapping MySQL-Proxy

  June 28, 2010

  I have old applications that need to read (and write) MyISAM tables that themselves receive lots of bulk updates. Time to try MySQL-Proxy. MySQL Proxy is light on documentation and very few people written anything about working.   Most of what I have read says MySQL-Proxy is not ready for prim time.  I have hope so [...]

  posted in Commentary by mark

• 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 [...]

  posted in Commentary by mark