High Performance MySQL, Fourth Edition

This book is a guide to getting the most from MySQL. It covers setting service-level objectives, designing schemas, indexes and queries, and tuning the server, operating system and hardware. It also shows database administrators how to scale applications through replication, load balancing, high availability and failover. This fourth edition is updated for cloud-hosted and self-hosted MySQL, InnoDB performance, and new features and tools. Database security and lessons on performance and stability are part of it too.

Why You Should Read?

• Learn how to set service-level objectives before you start tuning your MySQL platform.
• Discover advanced techniques for designing schemas, indexes and queries that help your platform reach its potential.
• Understand safe and practical ways to scale through replication, load balancing, high availability and failover.
• Gain best practices for database security, along with hard-earned lessons in performance and database stability.