High Performance MySQL: Optimization, Backups, and Replication

Tkachenko, Vadim,Zaitsev, Peter,Schwartz, Baron

ISBN 10: 1449314287 / ISBN 13: 9781449314286

Edité par O'Reilly Media, 2012

A propos de cet article

Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority!

N° de réf. du vendeur S_367702308

Détails bibliographiques

• Titre: High Performance MySQL: Optimization, Backups, and Replication
• Éditeur: O'Reilly Media
• Date de parution: 2012
• Langue: anglais
• ISBN à 10 chiffres: 1449314287
• ISBN à 13 chiffres: 9781449314286
• Reliure: Paperback
• Édition: 3ème Édition
• État de l'article: Good

A propos de ce titre

Synopsis

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 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 strategies—including new tools for hot online backups

À propos de l?auteur

Baron Schwartz is a software engineer who lives in Charlottesville, Virginia and goes by the online handle of "Xaprb," which is his first name typed in QWERTY on a Dvorak keyboard. When he's not busy solving a fun programming challenge, he relaxes with his wife Lynn and dog Carbon. He blogs about software engineering at http://www.xaprb.com/blog/. A former manager of the High Performace Group at MySQL AB, Peter Zaitsev now runs the mysqlperformanceblog.com site. He specializes in helping administrators fix issues with Web sites handling millions of visitors a day, dealing with terabytes of data using hundreds of servers. He is used to making changes and upgrades both to hardware to software (such as query optimization) in order to find solutions. He also speaks frequently at conferences. Vadim Tkachenko was a Performance Engineer in at MySQL AB. As an expert in multithreaded programming and synchronization, his primary tasks were benchmarks, profiling, and finding bottlenecks. He also worked on a number of features for performance monitoring and tuning, and getting MySQL to scale well on multiple CPUs.