SQL, Database Administration & Management, SQL (Programming Language), Databases - General & Miscellaneous
High Performance MySQL: Optimization, Backups, Replication, Load Balancing & More
Jeremy D. Zawodny, Derek J. Balling
Available on Bookshop
Write a review
Books.org participates in affiliate programs including Bookshop.org and the Amazon Services LLC Associates Program. We may earn a commission from qualifying purchases made through links on this page, at no additional cost to you.
Log in to track your reading progress.
Overview
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 options
Storage engines and table types
Benchmarking
Indexes
Query Optimization
Application Design
Server Performance
Replication
Load-balancing
Backup and Recovery
Security
Book Details
Published
December 17, 2008
Publisher
O'Reilly Media, Incorporated
Pages
304
ISBN
9780596555160