Two chapters from Jeremy Zawodny's and Derek Balling's book
High Performance MySQL are available over at mysql.com. Server Performance Tuning contains great information on RAID architectures, how to manage tmp tables, avoid disk thrashing, running out of memory and also resolving CPU bottlenecks. There's also a very informative chapter on Replication.