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

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

 



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