High Performance MySQL

High Performance MySQL

Optimization, Backups, Replication and Load Balancing

Book - 2004
Rate this:
Baker & Taylor
A guide for MySQL administrators covers such topics as benchmarking, indexes, the stages of processing a query, hardware configuations, copying data to multiple servers, and preventing hardware failure.

Book News
Written for MySQL administrators who already use Unix system monitoring tools, this book explains the basics of benchmarking, the nuances of indexes, and the stages of processing a query. It then suggests hardware configurations that provide better performance for large-scale applications, covers procedures for automatically copying data to multiple servers, and presents strategies for minimizing downtime in the event of hardware failure. The authors have both worked for Yahoo. Annotation ©2004 Book News, Inc., Portland, OR (booknews.com)

Ingram Publishing Services

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

Publisher: Beijing ; Sebastopol, CA : O'Reilly, c2004
Edition: 1st edition
Description: xvi, 276 p. : ill. ; 23 cm
ISBN: 9780596003067
Branch Call Number: 005.7585 SQL
Additional Contributors: Balling, Derek J.


From the critics

Community Activity


Add a Comment

There are no comments for this title yet.

Age Suitability

Add Age Suitability

There are no age suitabilities for this title yet.


Add a Summary

There are no summaries for this title yet.


Add Notices

There are no notices for this title yet.


Add a Quote

There are no quotes for this title yet.

Explore Further

Browse by Call Number

Subject Headings


Find it at BPL

To Top