Programming Books C Java PHP Python Learn more Browse Programming Books
MySQL Administrator's Bible and over one million other books are available for Amazon Kindle. Learn more
Buy New
$36.55
Qty:1
  • List Price: $55.00
  • Save: $18.45 (34%)
Only 9 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $9.62
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

MySQL Administrator's Bible Paperback – May 11, 2009

ISBN-13: 978-0470416914 ISBN-10: 0470416912 Edition: 1st

Buy New
Price: $36.55
30 New from $30.99 23 Used from $23.09
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$36.55
$30.99 $23.09

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student




Frequently Bought Together

MySQL Administrator's Bible + High Performance MySQL: Optimization, Backups, and Replication
Price for both: $67.97

Buy the selected items together

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

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

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.


More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.4 out of 5 stars
5 star
10
4 star
1
3 star
2
2 star
0
1 star
1
See all 14 customer reviews
My hat off to the authors for a job well done.
Van Pham
This book, as the title suggests, is that reference for a new MySQL DBA that I would highly recommend.
Ronald Bradford
The second most important job of a DBA is monitoring performance of your MySQL server.
Marke Schoonover

Most Helpful Customer Reviews

14 of 14 people found the following review helpful By rdubbs on June 12, 2009
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:
http://www.amazon.com/MySQL-Administrators-Guide-Language-Reference/dp/0672328704/ref=sr_1_4?ie=UTF8&s=books&qid=1244855803&sr=8-4

and a more general book on Database Administration:
http://www.amazon.com/Database-Administration-Complete-Practices-Procedures/dp/0201741296/ref=sr_1_1?ie=UTF8&s=books&qid=1244855921&sr=8-1

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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 8 people found the following review helpful By Marke Schoonover on July 12, 2009
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 5 people found the following review helpful By B3n S6z on June 30, 2009
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Most Recent Customer Reviews

Search

What Other Items Do Customers Buy After Viewing This Item?