As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo! You'll learn advanced configuration, benchmarking, and investigating logs. Topics include:

• A review of configuration and setup options
• Storage engines and table types
• Benchmarking
• Indexes
• Query Optimization
• Application Design
• Server Performance
• Replication
• Load-balancing
• Backup and Recovery
• Security