High Performance MySQL

Learn how to maximize the power of MySQL with High Performance MySQL. This guide covers advanced techniques for designing schemas, indexes, and queries, as well as tuning your MySQL server, operating system, and hardware. Discover practical ways to safely scale applications through replication, load balancing, high availability, and failover. With updated examples from MySQL 5.5 and InnoDB performance, this third edition provides illustrative case studies and stories that demonstrate MySQL's principles in action. Optimize your querying features, take advantage of multi-core CPUs and solid-state disks, and explore backup and recovery strategies with this comprehensive guide.