High Performance MySQL Optimization, Backups, and Replication

High Performance MySQL Optimization, Backups, and Replication
Publisher: O'Reilly Media; Second Edition edition (June 18, 2008) | Language: English |

ASIN: 0596101716 | EPUB | 712 pages | 4.1 mb

High Performance MySQL is the definitive guide to building fast, reliable systems with

MySQL. Written by noted experts with years of real-world experience building very large

systems, this book covers every aspect of MySQL performance in detail, and focuses on

robustness, security, and data integrity. High Performance MySQL teaches you advanced

techniques in depth so you can bring out MySQL's full power. Learn how to design schemas,

indexes, queries and advanced MySQL features for maximum performance, and get detailed

guidance for tuning your MySQL server, operating system, and hardware to their fullest

potential. You'll also learn practical, safe, high-performance ways to scale your

applications with replication, load balancing, high availability, and failover. This

second edition is completely revised and greatly expanded, with deeper coverage in all

areas. Major additions include:

-Emphasis throughout on both performance and reliability

-Thorough coverage of storage engines, including in-depth tuning and optimizations for

the InnoDB storage engine

-Effects of new features in MySQL 5.0 and 5.1, including stored procedures, partitioned

databases, triggers, and views

-A detailed discussion on how to build very large, highly scalable systems with MySQL

-New options for backups and replication

-Optimization of advanced querying features, such as full-text searches

-Four new appendices

The book also includes chapters on benchmarking, profiling, backups, security, and tools

and techniques to help you measure, monitor, and manage your MySQL installations.