How can you bring out My SQL's full power? With High Performance My SQL, you'll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your My SQL server, operating system, and hardware to their fullest potential.
This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.
Updated to reflect recent advances in My SQL and Inno DB performance, features, and tools, this third edition not only offers specific examples of how My SQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate My SQL's principles in action.
With this book, you'll learn how to think in My SQL.
Learn the effects of new features in My SQL 5.
5, including stored procedures, partitioned databases, triggers, and views Implement improvements in replication, high availability, and clustering Achieve high performance when running My SQL in the cloud Optimize advanced querying features, such as full-text searches Take advantage of modern multi-core CPUs and solid-state disks Explore backup and recovery strategies--including new tools for hot online backups.
O'reilly Media High performance mysql: optimization, backups, and replication, paperback/baron schwartz
