…slave) which is very IO bound showing 100% IO subsystem utilization on 5% of CPU usage ? This is the true challenge becomes because MySQL…means there are higher demands for IO subsystem performance. By far the best method is trying, if you…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…What are advantages/disadvantages of filtering-out tables from replication in master side vs slave side? A: You…MySQL Proxy 0.8.2 still says: “MySQL Proxy is currently an Alpha release and should not…means that the slave…
Post: Here's a quick way to Foresee if Replication Slave is ever going to catch up and When!
August 29, 2012 By 11 Comments
…IO happening, Not all queries are created equal – some would run for seconds, while others can be instant, Batch jobs: some sites would run…mysql -e ‘show slave status\G’ | grep Seconds_Behind_Master | awk ‘{print \$2}’” while sleep $delay; do…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…slave…IO resources which may not be available, especially for CPU bound MySQL Load. The benefit in this case is less space requirement if you…What…by default already. With real server grade CPU deployment the performance should be even better, meaning you should get over +-100MB/second you…
