Full name: High Performance MySQL: Optimization, Backups, Replication, and Load Balancing

Authors: Jeremy D. Zawodny, Derek J. Balling Year: 2004 Rank: Rating: Original Rating: Pop Rating: Genres/categories: Computer Science, Programming, Non Fiction Purchase/reserch links: LibraryThing Goodreads Amazon ISBNs: 9780596003067 9781449314286 0596003064 1449314287

As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these little understood topics.Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of contacts with the MySQL AB team, and presents regularly at conferences. Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing some of their own tools in order to produce the information in this book.In "High Performance MySQL" you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs.Topics include: A review of configuration and setup optionsStorage engines and table typesBenchmarkingIndexesQuery OptimizationApplication DesignServer PerformanceReplicationLoad-balancingBackup and RecoverySecurity Similar books: MySQL by Paul DuBois MySQL in a Nutshell by Russell Dyer MySQL Pocket Reference by George Reese MySQL Cookbook by Paul DuBois Managing and Using MySQL by Tim King MySQL by Larry Ullman The Amazing Book is Not on Fire by Dan Howell The Adventurous Eaters Club by Misha Collins The C Programming Language by Brian W. Kernighan Code Complete by Steve McConnell Destiny of Souls by Michael Newton The Simple Path to Wealth by J. L. Collins Firefly by Joss Whedon Making Faces by Kevyn Aucoin The Way I Heard It by Mike Rowe Refactoring by Martin Fowler Effective Java by Joshua Bloch Dreyer's English by Benjamin Dreyer The End of Your Life Book Club by Will Schwalbe Shrinkage by Bryan Bishop