The authors of this book - well-known experts with many years of practice - talk about how to create fast and reliable systems based on MySQL. They describe in detail various non-trivial approaches that will allow you to harness the full power of this DBMS. They discuss methods for designing schemas, indexes and queries to achieve maximum performance. Detailed instructions are provided for setting up the MySQL server, operating system and hardware to achieve their full potential. Safe ways to scale applications based on replication and load balancing are described. The second edition has been completely revised and significantly expanded, with special attention paid to fault tolerance, security and data integrity.

The book is recommended for both beginners and experienced users who would like to increase the performance of their MySQL-based applications.