High Performance MySQL: Optimization, Backups, Replication, Load-balancing, and

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：

Preface 

1. Back To Basics

      Binary Versus Compiled-From-Source Installations 

      Configuration Files 

      The SHOW Commands 

2. Storage Engines (Table Types)

      MySQL Architecture 

      Locking and Concurrency 

      Transactions 

      Selecting the Right Engine 

      The Storage Engines 

3. Benchmarking

      The Importance of Benchmarking 

      Benchmarking Strategies 

      Benchmarking Tools 

4. Indexes

      Indexing Basics 

      Index Structures 

      Indexes and Table Types 

      Index Maintenance 

5. Query Performance

      Query Processing Basics 

      Optimizer Features and Oddities 

      Identifying Slow Queries 

      Influencing MySQL with Hints 

      Stupid Query Tricks 

6. Server Performance Tuning

      Performance-Limiting Factors 

      RAID 

      Operating System 

      Techniques 

7. Replication

      Replication Overview 

      Configuring Replication 

      Under the Hood 

      Replication Architectures 

      Administration and Maintenance 

      Common Problems 

      The Future of Replication 

8. Load Balancing and High Availability

      Load Balancing Basics 

      Configuration Issues 

      Cluster Partitioning 

      High Availability 

9. Backup and Recovery

      Why Backups? 

      Considerations and Tradeoffs 

      Tools and Techniques 

      Rolling Your Own Backup Script 

10. Security

      Account Basics 

      The Grant Tables 

      Grant and Revoke 

      Operating System Security 

      Network Security 

      Data Encryption 

      MySQL in a chrooted Environment 

A. The SHOW STATUS and SHOW INNODB STATUS Commands

B. mytop

C. phpMyAdmin

Index