High Performance MySQL: Optimization, Backups, Replication & Load Balancing

by Jeremy D. Zawodny, Derek J. Balling

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

Genres: Programming, Computer Science, Technology, Nonfiction, Software, Technical, Reference

304 pages, Paperback

First published January 1, 2004

About the author

As of October 2012, Jeremy Zawodny is an employee of Craigslist, having previously worked in Yahoo!'s platform engineering group, where he was described as "Yahoo!'s MySQL guru".

He maintains a popular weblog focused on Yahoo! initiatives, which is listed in CNET News.com's index of the 100 best technology-related blogs. According to CNET, Zawodny has "helped put MySQL and other open-source technologies to use".

Reviews

[Will Semin]

Seriously! Why nobody talked about this book during my college years? A graet book I regret not reading it sooner! Lots and lots of things to comprehend!

[Otis Chandler]

A *great* book for anyone who wants to understan mysql better and how to tune it. I particularly liked it because it started at the basics with a conceptual overview, then dived into details. There are probably even more details it didn't go into, so I'll start looking for the next book. But this one was invaluable.

[Aditya Sharma]

Recommended for everyone starting with MySQL. This books gives great insights

[Ishita Singh]

In-depth explanation of MySQL with pragmatic examples.
Would recommend reading the latest release as there are parts that have changed with newer MySQL versions - at the time I read it 4th Edition of the book was the latest.

For me as a developer some of the chapters had information that I could not apply - but I would still recommend to read the parts that you do use like query optimisations, indexing, data types etc.

The first read will give you a good understanding of the behind the scenes but it's one of those books you would like to keep on your side and refer back.

[Adrian]

This a decent book for admins -- well written and easy to read, much more so than the manual. However, it is dated and only covers versions of MySQL up to 4.1 -- too bad as everyone should be using 5.0 nowadays. A good starting point for replication, backups, and optimization. [Read cover-to-cover]

[Clint]

For anyone building a solution based on MySQL.. whether its getting the most out of a hosted database, or building a multi-tier master slave replication fan-out, this book will offer great insight from people who've probably already done what you're trying to do. I tend to keep it within reach so that I can flip through the index of the book before googling for the answer to a question.

[Pete Aven]

This book is a must read for those working with MySql and concerned with performance. It's not a large book, but it's dense with practical information and if you work with large datasets or complex schemas/queries, it's an invaluable reference.

[AHolly]

Just started it but so far it is very informative (if you haven't already taken advanced mysql database courses)

[Timon Karnezos]

This book is gold. Everything you wanted to know about MySQL that you can't easily Google, organized in a useful way.

[Budi Susanto]

This book likes wiki for me. Derek has good talent to write in technical description. I love this book. Derek give me many new things about MySQL.

[Giorgi Lekveishvili]

It's must to read book

[Doug]

A real page turner...

[MJ]

i want to read this book

[Jagatheesan Jag]

The ultimate book to learn the in and outs of advance MySQL, beyond just writing queries. Made me more eager to learn about database.

[Jack]

Read binlog related chapters.

[Justin]

A useful reference for the quotidian MySQL user of any level of expertise

[Eng Ayman Elarian]

Perfect Book , Learned to much , it help me to mange my applications databases Performance ,

[Mohamed]

The best techinical book, I ever read.