Book : High Performance Mysql Optimization, Backups, And...

-Titulo Original : High Performance MySQL: Optimization, Backups, And Replication

-Fabricante :

OReilly Media

-Descripcion Original:

How can you bring out MySQLa??s full power? With High Performance MySQL, youa??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 MySQLa??s principles in action. With this book, youa??ll learn how to think in MySQL. Learn the effects of new features in MySQL 5.5, 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 multi-core CPUs and solid-state disks Explore backup and recovery strategiesa??including new tools for hot online backups About the Author Peter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Masters Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling. He serves as CEO of Percona, while keeping touch with his technical roots by continuing to do consulting for key customers. Vadim Tkachenko is the CTO and co-founder of Percona, and an authoron the MySQLPerformanceBlog and SSDPerformanceBlog blogs. Vadim leads Perconas development group, which produces the Percona Server, Percona XtraDB Cluster, and Percona XtraBackup.