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