 |
High Performance MySQL: Optimization, Backups, Replication & Load Balancing
Customer Reviews: 3 Average Customer Rating:  Write a Review and tell the world about this title! People who purchase this book frequently purchase: - Tomcat: The Definitive Guide, 2nd Edition; Jason Brittain, et al, $24.95, 38% Off!
- Programming PHP, 2nd Edition; Kevin Tatroe, et al, $24.95, 38% Off!
- Web Database Applications with PHP and MySQL, 2nd Edition; Hugh E. Williams, et al, $28.50, 37% Off!
- Building Scalable Web Sites: Building, Scaling and Optimizing the Next Generation of Web Applications; Cal Henderson, $24.95, 38% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
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
ACID 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 chroot( ) Environment
A. The SHOW STATUS and SHOW INNODB STATUS Commands
B. mytop
C. phpMyAdmin
Index
Customer Reviews
Customer Reviews: 3 Average Customer Rating: Jul 8, 2005 Savki from New York
Great book, a must have!
As the authors said, the dragons have raised their heads, finally. We've spent countless time to tune up some third party and open source applications using mysql database for our customers in the past months. I wish I've found this book earlier! All mysql server administrators and/or application developers could benefit from this practical book.
BTW. bookpool has the best service as always! I got my books second day! great job!
Jan 4, 2005 A review from california
good succinct summary of a range of topics
Most of the book is very informative, with specific examples. I bought the book mainly to read up on high availability and clustering. The high availability chapter is pretty much conceptual (they mention solutions, 1 free, 2 commercial, no actual implementation included in the book), and not much except a blurb about clustering. Unfortunately, I guess at the time this book was written clustering was not "available" for mysql (it is now, although documentation is a bit grungy).
Jun 30, 2004 Hayk from Alexandria, VA
Excellent book on MySQL and databases in general
I have read many books on MySQL and found this one the best. The book is perfect for me, Systems Architect, Oracle DBA. I found answers for most of my questions on MySQL from the systems, high performance, replication and other advance areas. The book is not for novice users, you need to have some experience in RDBMS to appreciate it. I plan on launching enterprise web site using MySQL, High Performance MySQL answers most of my questions and cleared doubts that I have had on MySQL.
|
|
