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

Jeremy D. Zawodny, Derek J. Balling

  • 出版商: O'Reilly
  • 出版日期: 2004-04-18
  • 售價: $1,550
  • 貴賓價: 9.5$1,473
  • 語言: 英文
  • 頁數: 265
  • 裝訂: Paperback
  • ISBN: 0596003064
  • ISBN-13: 9780596003067
  • 相關分類: MySQLSQL
  • 已過版

買這商品的人也買了...

相關主題

商品描述

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