On Sun, May 18, 2008 at 8:05 AM, Issac Goldstand <[EMAIL PROTECTED]> wrote: > Also, do people have concrete > benchmarks of keeping a read-only replication mysql on the webservers vs a > single read/write shared mysql server?
Any time you can spread the reads over multiple servers it will help. This is particularly true for MyISAM tables where reads blocks writers. (InnoDB tables behave like Oracle and Postgres, with a MVCC model.) > I also thought to buffer common DB query results (like php's sessions) in > memcached on reads I suspect that caching on the level of db queries will get annoying if you try to do it everywhere. You'd be better off caching at a higher "object" level if you can, or just caching specific high-value queries. - Perrin
