Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

MySQL Administrator's Bible 1st Edition

4.3 out of 5 stars 17 customer reviews
ISBN-13: 978-0470416914
ISBN-10: 0470416912
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Rent On clicking this link, a new layer will be open
$16.28 On clicking this link, a new layer will be open
Buy used On clicking this link, a new layer will be open
$31.99 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$40.71 On clicking this link, a new layer will be open
More Buying Choices
31 New from $31.85 31 Used from $5.99
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

ITPro.TV Video Training
Take advantage of IT courses online anywhere, anytime with ITPro.TV. Learn more.
$40.71 FREE Shipping. Only 6 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Frequently Bought Together

  • MySQL Administrator's Bible
  • +
  • High Performance MySQL: Optimization, Backups, and Replication
  • +
  • MySQL Cookbook: Solutions for Database Developers and Administrators
Total price: $124.95
Buy the selected items together

Editorial Reviews

From the Back Cover

Whether you're a novice or experienced DBA, this book has all you need to learn MySQL

MySQL Administrator's Bible is designed to provide a solid framework for a beginning MySQL DBA or an experienced DBA transitioning from another database platform. The book starts with the fundamentals of MySQL database management, including MySQL's unique approach to SQL queries, data and index types, stored procedures and functions, triggers and views, and transactions. The authors continue with comprehensive coverage of major MySQL Server components and processes for which DBAs are responsible—these include:

  • MySQL Server tuning

  • Query optimization and index tuning

  • Managing storage engines

  • Caching

  • Authentication and managing users

  • Partitioning; Replication; Logging

  • Database and performance monitoring

  • Security; Backup and Recovery

  • Managing availability and scaling

  • Fully covers MySQL 5.1

Companion Web Site

The book's Companion Web Site includes a tutorial on foundational SQL programming that all MySQL DBAs need to understand, plus code examples, scripts, and data schemas used in the book. You'll also learn about the latest changes in MySQL and find helpful links. Visit the site at www.wiley.com/go/mysqladminbible.


The latest book club pick from Oprah
"The Underground Railroad" by Colson Whitehead is a magnificent novel chronicling a young slave's adventures as she makes a desperate bid for freedom in the antebellum South. See more

Product Details

  • Paperback: 888 pages
  • Publisher: Wiley; 1 edition (May 11, 2009)
  • Language: English
  • ISBN-10: 0470416912
  • ISBN-13: 978-0470416914
  • Product Dimensions: 7.4 x 2 x 9.3 inches
  • Shipping Weight: 2.8 pounds (View shipping rates and policies)
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (17 customer reviews)
  • Amazon Best Sellers Rank: #579,232 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

Format: Paperback Verified Purchase
Some background first: I've used MySQL for two decently-sized programming projects in the past, on the developer side. More recently I was hired to design, build and administer the back-end of a web application. MySQL seemed the natural choice. With background only in the developer's role, I had a huge amount to learn.

I started out by buying the MySQL Administrator's Guide and Reference:

and a more general book on Database Administration:

The former was pretty terrible, and it's all available online anyways so there's absolutely no reason to buy it. Why is it so bad? Despite being written by MySQL, it is completely impractical and totally bogged down with details. I defy you to figure out how to efficiently back up your database by using that guide. I couldn't.

The latter was very useful for introducing concepts like data normalization and, while a little out of date, gives a quick sense of the products that are out there. I highly recommend it as a first read. but it's not MySQL specific - so where to go then?

Finally, I found this book. It took me about 1 minute to find the tools I would need to back up a database and another 10 seconds to find a detailed discussion of what's going on when you back up a database.

It's also very recent (as of 2009/06) - it really reflects the state of the tools out there and I was pleasantly surprised to find that all of the developments I had been reading about in my online research were reflected in the book.
Read more ›
Comment 17 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
On the front cover of MySQL Administrator's Bible is a sentence that reads:

"The book you need to succeed!"

I must say, I do agree. Authored by two very experienced DBAs, Sheeri Cabral and Keith Murphy, they've combined their talents to cover what you really need to know to succeed. This book is very versatile. If you're new to MySQL, or experienced in another database and have to start administrating MySQL, you need this book. I can honestly say, even if you have years of MySQL experience, you will learn something new. I did. Divided into four parts, MySQL Administrator's Bible covers your First Steps with MySQL, Developing with MySQL, Core MySQL Administration and Extending Your Skills.

First Steps with MySQL starts with a gentle introduction to MySQL with company information, which seems to be changing annually, and most importantly, the MySQL community itself. What makes MySQL so fantastic is the community. After that, you'll be lead into installing and configuring MySQL on various platforms including Linux, Windows and Solaris while touching on post installation configuration too. Basic security is covered as well as some tips on troubleshooting and accessing your new MySQL installation using tools included with MySQL or using third party software.

Developing with MySQL covers the MySQL Language Structure and if you're coming from another RDBMS, it covers how MySQL deviates from the SQL standard by extending that standard to make MySQL the number one open source database used on the Internet. After that, this section covers the same type of topics covering just about any other mainstream databases such as using stored procedures, cursors, events, views and transactions.

The Core MySQL Administration is the heart of this book.
Read more ›
Comment 9 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
This is a comprehensive reference guide to MySQL that's accessible to beginning DBAs or DBAs familiar with another database. It has enough detail to be a useful companion throughout a DBA's career. It also covers many related technologies, such as memcached, at a moderate-but-useful level of detail. This isn't exactly a how-to book, and it isn't exactly a reference manual; it's more of a blend of the two.

The audience will depend on personal preferences. Some of the reference material is the type of thing I would look up with command-line --help options or the MySQL manual. But there are times when the reference aspect of the book is uniquely valuable. For example, the online documentation tends to list things alphabetically; the book might break them down into groups by function. An example is the sql_mode parameters, which it groups into categories like "Getting rid of silent failures, silent conversions, and silently allowing invalid data."

The book is divided into four parts: first steps, developing with MySQL, core administration, and a set of chapters and appendixes grouped under extending your skills. I think this organization works well.

Coverage is for MySQL 5.1 and 6.0. As far as I know, this book contains the most complete coverage of MySQL 5.1 in print.

By the way, I'm the lead author of High Performance MySQL: Optimization, Backups, Replication, and More and I think the two books are very complementary. If you're new to MySQL, then start with this book, and later you might consider reading mine as well.
Comment 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Set up an Amazon Giveaway

MySQL Administrator's Bible
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway
This item: MySQL Administrator's Bible