MySQL / MariaDB Books
Books by employees
MySQL / MariaDB Book Reviews
We'll review here those texts which are, or claim to be, about MySQL or MariaDB or InnoDB.
We try to be current, but we do not always go out and buy the latest
edition of every book, especially if we disliked the last edition.
We try to be fair, but disclaim responsibility for any errors or omissions.
THE TOP MYSQL BOOKS
We power searched the amazon.com database for MySQL etc., deliberately
excluding any publication date more than 2 years ago. The list is in
order by rating and publication date.
MySQL (5th Edition)
Paul DuBois. Addison-Wesley, April 2013. 5 stars.
Mr DuBois has worked for the MySQL Documentation group for about a decade. The book is thick and has
examples that are not in the online manual. Over the years, I believe, this has been the best seller
in the MySQL book category by far -- it even gets on the shelves of my neighbourhood mall book store.
Read Open Source DBA's (i.e. Stokes's) review.
Read Hull's review.
MySQL Workbench: Data Modeling & Development
Michael McLaughlin. Oracle Press, April 2013. 5 stars.
Not a general book about the MySQL server, just about a front end.
Read OpenSource DBA's review.
Effective MySQL Replication Techniques in Depth
Ronald Bradford and Chris Schneider. McGraw-Hill, September 2012. 5 stars.
This is part of a series of "Effective MySQL" books; the others are about optimizing statements and backup/recovery.
Read Open Source DBA's review.
Joel Murach. Mike Murach and Associates, May 2012. 5 stars.
Mr Murach has written books about Java, C#, Oracle,
SQL Server, .NET, Visual Basic, and WordPerfect -- which makes me think he's an expert writer
rather than an expert MySQLer, and that is a good thing for a beginner book, but I just cannot
believe he would be as good for arcane details as (say) Mr DuBois or Ms Smirnova.
Read Murach's collection of testimonials.
Read Dr.Dobb's review of an earlier Murach book.
MySQL Troubleshooting: What To Do When Queries Don't Work
Sveta Smirnova. O'Reilly, February 2012. 5 stars.
This is for experienced people by an experienced person -- Ms Smirnova wrote this while she was a principal support engineer for MySQL.
As she puts it in the preface: "Hundreds of great books, blog posts, and web pages describe different parts of the
MySQL server in detail. But here's where I see the difficulty: this information is organized in such a way as to explain how the MySQL server normally works, leaving out
methods that can identify failures and ill-posed behavior." In other words, the other books are about how it's supposed to work;
pick this book up when it doesn't work.
Expert MySQL (2nd edition)
Charles Bell. Apress, December 2012. 4.5 stars.
Listen to a podcast.
Read an excerpt.
High Performance MySQL: Optimization, Backups, and Replication (3rd edition)
Baron Schwartz, Peter Zaitsev and Vadim Tkachenko. O'Reilly, March 2012. 4.5 stars.
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.
An earlier edition of this book won a Jolt Award in the technical/productivity category.
Read the table of contents.
Read kuznetsov's review.
Effective MySQL Optimizing SQL Statements
Ronald Bradford. Oracle Press, September 2011. 4.5 stars.
Read Bradford's blog.
Read Hull's review.
MariaDB Crash Course
Ben Forta. Addison-Wesley, September 2011. 4 stars.
This is a variation of Mr Forta's earlier work, MySQL Crash Course.
Read Bartholomew's review.
Matthew Reid. Packt Publishing, February 2013. 3.5 stars.
Read Pattishall's review.
Read Maxia's review.
Read Cave's review.
Read the author's blurb.
Read a preview.
MySQL 5.1 for Professionals
Ivan Bayross and Cynthia Bayross. Shroff, November 2011. No rating.
Read phillipnb's review of an earlier book.
MySQL Admin Cookbook LITE: Replication and Indexing
Daniel Schneller and Udo Schwedt. Packt Publishing, May 2011. No rating.
Read an excerpt.
Read Stokes's review.
SECONDARY MYSQL BOOKS
If the title contains the words "PHP and MySQL" or "Apache and MySQL" etc.
-- i.e. MySQL isn't mentioned first -- then we consider it a PHP/etc. book
first, and secondarily a MySQL book.
PHP & MySQL: Novice to Ninja
Kevin Yank. SitePoint, May 2012. 4.5 stars.
Ask for a sample chapter.
Watch the author describe the book.
Read AppSumo's review.
Read a press release.
PHP and MySQL in Easy Steps
Mike McGrath. Easy Steps Limited, December 2012. 4 stars.
Mike McGrath has done about fifteen "easy steps" books on various computer topics.
PHP & MySQL: The Missing Manual
Brett McLaughlin. O'Reilly, November 2012. 4 stars.
Read a sample.
Robin Nixon. O'Reilly, September 2012. 4 stars.
The three chapters about MySQL are certainly too little go to on, but that is what
one has to expect in a book that tries to cover many topics.
Steve Suehring, Janet Valade. For Dummies, April 2013. 3 stars.
I read a sample chapter of an earlier Valade book and had to admit it was clear and correct,
which is not what I expect in books from the For Dummies series.
Read an excerpt.
PHP and MySQL Phrasebook
Christian Wenz. Addison-Wesley, November 2012. 3 stars.
Sams Teach Yourself PHP, MySQL and Apache All in One (5th Edition)
Julie Meloni. Sams, June 2012. 2.5 stars.
Expert PHP and MySQL: Application Design and Development
Marc Rochkind. Apress, August 2013. No rating.
NOT YET AVAILABLE
Books which will appear within the next year include:
MySQL High Availability: Tools for Building Robust Data Centers
Charles Bell, Mats Kindahl, Lars Thalmann. O'Reilly, January 2014.
The authors are current MySQL employees.
Learning the MySQL Database
Russell Dyer. O'Reilly, December 2013.
The author is a former MySQL employee.
PHP and MySQL Web Development (5th Edition)
Luke Welling and Laura Thomson. Addison-Wesley, December 2013.
The earlier editions seem to have sold well.
MySQL's own documentation is downloadable from
the MySQL site.
You can order a museum-piece printed edition of the 2002 mysql.com documentation
See also our related pages:
Database Book Reviews,
ADO Book Reviews,
Java and SQL Book Reviews.
Please place your amazon book order from here ...
Did we help you? Then please, when you buy your book from amazon,
come via this site and click on one of the featured titles above,
or on the search box below. You see, we get a 5% commission if you
place your amazon order this way. You, we, and amazon will all be happy.
Copyright (c) 2000-2013 by Ocelot Computer Services Inc. All rights reserved.
Return to Ocelot home page
Send enquiries or suggestions to