High Performance MySQL: Optimization, Backups, Replication, and More [Paperback]

High Performance MySQL is the definitive (expressed) guide to building (antiquity) fast, reliable (sure) systems with MySQL. Written by noted experts with years (eld) of real-world experience (undergo) building (antiquity) very large (super) systems, this book (aggregation) covers every aspect (characteristic) of MySQL performance (action) in detail, and focuses on robustness, security, and data (accumulation) integrity. High Performance MySQL teaches you advanced (modern) techniques in depth so you can (crapper) bring out (discover) MySQL's full (flooded) power. Learn how to design (organisation) schemas, indexes, queries and advanced (modern) MySQL features for maximum (peak) performance, and get (intend) detailed guidance (counselling) for tuning your MySQL server, operating (operative) system, and hardware (element) to their fullest potential. You'll also learn (see) practical, safe, high-performance ways (structure) to scale (bit) your applications with replication, load (alluviation) balancing, high (broad) availability, and failover. This second (ordinal) edition is completely revised and greatly expanded, with deeper coverage (news) in all (every) areas. Major additions include:

Emphasis throughout on both performance (action) and reliability

Thorough coverage (news) of storage (hardware) engines, including in-depth tuning and optimizations for the InnoDB storage (hardware) engine

Effects of new (newborn) features in MySQL 5.0 and 5.1, including stored procedures, partitioned (divided) databases, triggers, and views

A detailed (careful) discussion on how to build (physique) very (rattling) large, highly scalable (ascendible) systems with MySQL

New options for backups and replication

Optimization of advanced (modern) querying features, such (much) as full-text searches

Four new (newborn) appendices

The book (aggregation) also includes chapters on benchmarking, profiling, backups, security, and tools and techniques to help (support) you measure, monitor, and manage (control) your MySQL installations.

Product Details:
Paperback: 712 pages
Publisher: O'Reilly Media; 2 edition (June 18, 2008)
Language: English
ISBN-10: 0596101716
ISBN-13: 978-0596101718
Product Dimensions: 9.1 x 7.1 x 1.5 inches
Shipping Weight: 2 pounds