High Performance MySQL: Optimization, Backups, Replication, and More

by Baron Schwartz

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.

Genres: Programming, Technical, Reference, Technology, Software, Nonfiction, Computers

Paperback

First published February 15, 2009

About the author

Baron Schwartz is a software engineer who lives in Charlottesville, Virginia and goes by the online handle of "Xaprb," which is his first name typed in QWERTY on a Dvorak keyboard. When he's not busy solving a fun programming challenge, he relaxes with his wife Lynn and dog Carbon. He's the consulting team lead at Percona.

Baron is a prominent MySQL performance expert, community leader, speaker, author, and software engineer. After earning a degree in Computer Science and spending several years as a software engineer, Baron grew and led Percona's consulting team and practice to international prominence, then founded VividCortex to give developers and operations teams deep visibility into the behavior and performance of production database systems. Although he is most recognized for his MySQL expertise, Baron understands and appreciates many types of databases, and participates actively in several database communities as a speaker and advocate, as evidenced by his Oracle ACE award among others.

Reviews

[André R]

Very in-depth coverage but maybe somewhat outdated in 2023...

[François Beausoleil]

This was a great book. If you need to deploy and/or maintain MySQL, this is one of the books you need.

[Andrewh]

Great useful book so far. Seems like a must-have if you do production work with mysql.

[Alex]

A highly educational, if challengingly dry at times, read. I'm only a chapter in, but I can already tell it's going to improve my understanding of MySQL and how to use it.

[Johan]

Thorough and informational; highly recommended.