High Performance MySQL
Optimization, Backups, Replication, Load Balancing & More
Publisher: O'Reilly Media
Final Release Date: April 2004
Pages: 304

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
Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyHigh Performance MySQL
 
4.3

(based on 6 reviews)

Ratings Distribution

  • 5 Stars

     

    (2)

  • 4 Stars

     

    (4)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 6 customers

Sort by

Displaying reviews 1-6

Back to top

 
4.0

Good book for mysql dba's.

By ashwin

from Chennai, India

About Me Sys Admin

Verified Reviewer

Pros

  • Easy to understand
  • Helpful examples
  • Well-written

Cons

  • Not comprehensive enough

Best Uses

  • Intermediate
  • Novice
  • Student

Comments about oreilly High Performance MySQL:

I have read this book completely and i think it is a awesome book. It presents even complex topic in simple and easy to understand manner. I have no dba expreince before reading this book. I have been doing some mysql querying but not much. Now i know a lot to manage mysql server, set up relication, troubleshoot performance issues, etc. But i think that they could have gone to some more depth rather than presenting in somewhat high level.

(1 of 1 customers found this review helpful)

 
4.0

A lot of useful stuff

By JAnton

from Sweden

About Me Developer

Pros

  • Easy to understand
  • Helpful examples
  • Well-written

Cons

    Best Uses

    • Expert

    Comments about oreilly High Performance MySQL:

    Realy useful book, let understand DB structure in deep details and create high perfomance, reliable Data Bases. Will be usefull for both developers and DBA. Detailed description of such important topics like indexing and caching make it a perfect handbook for those who want to wring out the maximum perfomance.
    The book requires good understanding of MySQL in whole and intended for expirienced users. But some chapters may be helpfull for beginers as well. Written in a good style the book abounds in tips and workarounds. Information presented based on huge expirience of the writers.

    (0 of 1 customers found this review helpful)

     
    5.0

    Fantastic!

    By vippi-va-voom

    from Undisclosed

    Comments about oreilly High Performance MySQL:

    This is not a How To book.

    This is the book you get once you understand basic MySQL and your boss starts talking about disaster recovery, replication, hot spares, backup snapshots and performance.

    Amazing coverage of advanced MySQL use. I've already worn out the spine on it and it's dog-eared 8)

    I saw only 3 reviews on this. It really needs to be in every bookshelf owned by people in charge of operational support of this DB.

    It's a "can't live without it" title for me, right there with DNS/BIND, CVS and the various unix and programming titles I own.

    Great job Jeremy and Derek!

    -v

    (1 of 1 customers found this review helpful)

     
    4.0

    MySQL on Steroids

    By Dave Walz-Burkett

    from Undisclosed

    Comments about oreilly High Performance MySQL:

    High Performance MySQL opens with a quick chapter describing various MySQL installation options including binary packages and compiling from source code. The next chapter describes the different storage engines available in MySQL and why you would want to choose one over another. This is the book's first hint of what you can do to improve database performance: picking the right table type.

    Skilled software developers use benchmarking to gain insight into how their software is performing and database benchmarking should be part of that strategy. A brief chapter introduces some database benchmarking strategies and tools.

    Chapters on indexing and query performance follow, describing some of the most important skills to master. Following that, replication and load balancing are discussed. Backup and recovery options are covered, as is the topic of security.

    A somewhat thin trio of goodies rounds off the book in the appendices: the SHOW STATUS / SHOW INNODB STATUS commands, the mytop tool, and the phpMyAdmin user interface.

    Overall, I found many possible areas for performance improvement that I had not thought of before. At 278 pages, a lot of material is crammed into this book. It's a quick read and if you're a MySQL admin or a developer using MySQL, you're bound to find something useful here!

    (1 of 1 customers found this review helpful)

     
    5.0

    A must for those that use MySQL on a regular basis

    By ADR

    from Undisclosed

    Comments about oreilly High Performance MySQL:

    If you interact with MySQL on a regular basis, High Performance MySQL should be the next book that you read. High Performance MySQL does a great job at covering techniques on benchmarking your current configuration and how to increase performance at 3 major levels: 1) database architecture, 2) server tuning, and 3) scaling horizontally (with multiple servers).

    Database architecture is where it really begins. Zawodny and Balling did a great job explaining the different storage engines along with their advantages and disadvantages, working with transactions, how to get the most of your database through indexing and how to optimize query performance.

    Zawodny and Balling also did an excellent job on covering server tuning. It just wasn't a turtorial on ‘this is how you should modify your configuration files.' The authors whent into great detail in explaining different hardware configurations, what to look for in RAID configurations and different filesystems, and how to solve various bottlenecks.

    For the most part, the authors reserved a complete 60 pages of the book for Replicaiton and Load Balancing configurations. The authors provided several scenarios to choose from along with the advantages and disadvantages of each.

    (1 of 1 customers found this review helpful)

     
    4.0

    Enterprise-level MySQL

    By Dan

    from Undisclosed

    Comments about oreilly High Performance MySQL:

    High Performance MySQL is a good look at the issues faced by DBAs in high performance environments..

    MySQL books to date have tended to be reviews of basic installation and configuration. This books assumes you have covered that ground already, a welcome departure.

    The book takes an intermedite-level approach to topics such as indexing, replication, backup, and tuning.

    On the positive side, the book is engaging and very readable. Although the material is, by nature, theoretical, the authors have taken effort to attach real-world examples to the concepts they are covering.

    On the negative side, there were a few typos and grammatical errors in the book, such as a diagram referring to the 'NBD' storage engine (should read BDB). Perhaps one more trip through the editing desk would have been helpful. However, the material itself is comprehensive and accurate, and is not affected by these minor slips.

    Overall, the books is recommended for DBAs who do non-trivial work with MySQL.

    Displaying reviews 1-6

    Back to top

     
    Buy 2 Get 1 Free Free Shipping Guarantee
    Buying Options
    Immediate Access - Go Digital what's this?
    Ebook: $27.99
    Formats:  DAISY, ePub, Mobi, PDF