tailieunhanh - High Performance MySQL, Third Edition

High Performance MySQL Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko Beijing • Cambridge • Farnham • Köln • Sebastopol • Tokyo All rights reserved. Printed in the United States of America. Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472. O’Reilly books may be purchased for educational, business, or sales promotional use. Online editions are also available for most titles | Baron Schwartz Peter Zaitsev Vadim Tkachenko O REILLY Databases High Performance MySQL How can you bring out MySQL s full power With High Performance MySQL you ll learn advanced techniques for everything from designing schemas indexes and queries to tuning your MySQL 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 MySQL and InnoDB performance features and tools this third edition not only offers specific examples of how MySQL works it also teaches you why this system works as it does with illustrative stories and case studies that demonstrate MySQL s principles in action. With this book you ll learn bow to think in MySQL. Learn the effects of new features in MySQL including stored procedures partitioned databases triggers and views Implement improvements in replication high availability and clustering Achieve high performance when running MySQL in the cloud Optimize advanced querying features such as full-text searches Take advantage of modern multicore CPUs and solid-state disks Explore backup and recovery strategies including new tools for hot online backups Strata Making Data Work The third edition makes a great book even better. The authors are uniquely qualified to write this book. I continue to learn from them and hope you take the time to do so as well. Mark Callaghan Software Engineer Facebook Strata is the emerging ecosystem of people tools and technologies that turn big data into smart decisions. Find information and resources at data. Baron Schwartz is Chief Performance Architect at Percona. He creates tools and techniques to make MySQL easier to use and more dependable. Peter Zaitsev CEO and cofounder of Percona is an expert in database kernels computer hardware and application scaling. He managed the High Performance Group .