… write scaling. As Brian writes this works best for read intensive envinronments. Write scaling however can be real problem. Not moderate increase of write ratio can… 140GB as total amount of cache memory you have. Using memcached or similar solutions on the top of things for caching…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
… you need. Especially if it is mostly read only scenario. Why Look for alternatives ? There … invalidation which can offer much better hit ratio for certain application. It is not that …duplication. Memcached is probably the most popular distributed caching system and it works great. I should write …
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
… and how complex replication topologies with multiple tiers filtering and writes to some intermediary slaves people use. For me simple is… you’re using memcache or other caching option. Successful memcache implementations often report 90% cache hit ratio meaning 10 to 1 read ratio drop backs…
Comment: Should you move from MyISAM to Innodb ?
February 1, 2010 By 53 Comments
… use memcache before hitting DB. We use RAID0 with multiple disks on all SLAVES. MASTER machines use RAID5. Ratio of reads-to-writes is 7,000-to-1. Collectively, about 600M DB transactions per day after peeling off 78% of the reads on the memcaches…
