http://www.randombugs.com/linux/mysql-postgresql-benchmarks.html yet another mysql vs postgresql benchmark using “OSDB”. Small difference between the two, but consider that benchmark was done on 2-way SMP, 3GB ram, 1 SATA DISK and a small dataset.
http://www.fishpool.org/post/2008/03/31/Optimizing-Linux-I/O-on-hardware-RAID explains use linux IO scheulers with presence of smart RAID controllers.
http://www.slideshare.net/cstrep/myoperacom-scalability-v20 slides from my.opera.com architecture presentation. Iptables/linux lvs -> apche/mod_perl -> mysql replication, varnish, memcached
http://mzz.ru/ kind of cool MVC framework, supports a lot of modern features like url routing, etc. documentation seems to be only available in russian
http://www.osdbzine.net/ pdf magazine that covers open-source databases, MySQL, PostgreSQL and alike.
http://www.samag.ru/art/07.2007/07.2007_02.html test uses db schema and usage pattern from popular blog-hosting site. Benchmark uses optimized queries
http://lwn.net/Articles/329626/?format=printable describes recent forks, patch-sets and build of mysql. If you looking at this page deciding which fork of mysql will be better suited for your new project – maybe better to use PostgreSQL instead
http://blogs.nologin.es/slopez/archives/17-Benchmarking-Databases-I.-Volatile-Storage..html PostgreSQL, MySQL and Oracle are compared using reasonable hardware setup and TPC-C like test with BenchmarkSQL tool (JDBC ) . This post will probably disappear soon as the author clearly violates oracle license that does not permit publishing benchmark results w/out permissions
http://www.mysqlperformanceblog.com/2006/08/09/cache-performance-comparison/ gives you an idea how different caching methods perform. Read it before implementing something
http://cookiesareforclosers.com/blog/2008/06/linkedin-architecture interesing notes about LinkedIn architecture (JAVA + MYSQL + ORACLE)