Enjoy fast, free delivery, exclusive deals, and award-winning movies & TV shows with Prime
Try Prime and start saving today with fast, free delivery

Kindle
$48.00

Available instantly

Paperback
$7.74 - $53.99

List Price: $60.00 Details

Save: $6.01 (10%)

FREE Returns

FREE delivery Monday, March 25

Select delivery location

Only 2 left in stock (more on the way).

$$53.99 () Includes selected options. Includes initial monthly payment and selected options. Details

Ships from

Amazon.com

Ships from

Amazon.com

Sold by

Amazon.com

Sold by

Amazon.com

Returns

Eligible for Return, Refund or Replacement within 30 days of receipt

Returns

Eligible for Return, Refund or Replacement within 30 days of receipt

This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.

Read full return policy

Payment

Secure transaction

Payment

Secure transaction

We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more

Support

Product support included

Support

Product support included

In the event your product doesn't work as expected or you need help using it, Amazon offers free product support options such as live phone/chat with an Amazon associate, manufacturer contact information, step-by-step troubleshooting guides, and help videos. By solving product issues, we help the planet by extending the life of products. Availability of support options differ by product and country. Learn more

Details

Add a gift receipt for easy returns

FREE delivery March 26 - 28. Details

Or fastest delivery March 20 - 22. Details

Select delivery location

Used: Very Good | Details

Sold by ThriftBooks-Seattle

Access codes and supplements are not guaranteed with used items.

Follow the author

Sheeri Cabral

Follow

MySQL Administrator's Bible 1st Edition

by Sheeri K. Cabral (Author), Keith Murphy (Author)

4.2 34 ratings

See all formats and editions

{"desktop_buybox_group_1":[{"displayPrice":"$53.99","priceAmount":53.99,"currencySymbol":"$","integerValue":"53","decimalSeparator":".","fractionalValue":"99","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"%2Ft38OwLSiiROveHRvQ0HxKGu3xZ9A2Sh2llcJS2MlbWW0tXHIl7ejHKXLX3E8YEVRsPGmAlcVPieqXdJHvEHlaDkbZQt0tc9gIa%2BF03JUKDRg07RtWgHq1oFddkaoKQLmn2n8lpzDYc%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$7.74","priceAmount":7.74,"currencySymbol":"$","integerValue":"7","decimalSeparator":".","fractionalValue":"74","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"%2Ft38OwLSiiROveHRvQ0HxKGu3xZ9A2ShW060RDodbcQkNV99juwJcpOIxmQrYK41SLg80T85EgWecfm62Z9yEdAmLln4rewj47Q2mOnB9K7fkqBf5%2B0ZWeJIqQ1mugf5OwmrC6TBLAwTRdi%2F7%2F2G%2BvznEHb09SP6HAmvUcfMxwJnxCwa7LbtAw%3D%3D","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management―including MySQL’s unique approach to basic database features and functions―as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.

ISBN-10

0470416912
ISBN-13

978-0470416914
Edition

1st
Publisher

Wiley
Publication date

May 11, 2009
Language

English
Dimensions

7.4 x 1.96 x 9.28 inches
Print length

896 pages
See all details

Frequently bought together

$53.99

Get it as soon as Monday, Mar 25

Only 2 left in stock (more on the way).

Ships from and sold by Amazon.com.

+

$43.99

Get it as soon as Tuesday, Mar 26

In Stock

Ships from and sold by Amazon.com.

Total price:

To see our price, add these items to your cart.

Try again!

Details

Added to Cart

One of these items ships sooner than the other.

Show details Hide details

Choose items to buy together.

Chintan Mehta
25
Paperback
12 offers from $39.99
EMC Education Services
212
Hardcover
47 offers from $19.95

Editorial Reviews

From the Inside Flap

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.

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.

Product details

Publisher ‏ : ‎ Wiley; 1st edition (May 11, 2009)
Language ‏ : ‎ English
Paperback ‏ : ‎ 896 pages
ISBN-10 ‏ : ‎ 0470416912
ISBN-13 ‏ : ‎ 978-0470416914
Item Weight ‏ : ‎ 2.82 pounds
Dimensions ‏ : ‎ 7.4 x 1.96 x 9.28 inches

Best Sellers Rank: #1,843,681 in Books (See Top 100 in Books)
- #150 in MySQL Guides
- #369 in SQL
- #6,014 in Programming Languages (Books)

Customer Reviews:
4.2 34 ratings

Brief content visible, double tap to read full content.

Full content visible, double tap to read brief content.

Videos

Help others learn more about this product by uploading a video!

Upload your video

Important information

To report an issue with this product or seller, click here.

About the author

Follow authors to get new release updates, plus improved recommendations.

Sheeri Cabral

Brief content visible, double tap to read full content.

Full content visible, double tap to read brief content.

Discover more of the author’s books, see similar authors, read author blogs and more

Customer reviews

4.2 out of 5

34 global ratings

How customer reviews and ratings work

Sort reviews by

Top reviews from the United States

There was a problem filtering reviews right now. Please try again later.

rdubbs

The best guide I've found to setting up and administering MySQL databases

Reviewed in the United States on June 13, 2009

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. Instead of glossing over complex topics like MySQL Cluster, memcached, DRBD, Linux HA (see, I wasn't kidding about its coverage), it points you to external resources that are actually helpful.

I haven't yet read all of it but, to my knowledge, there is nothing comparable out there. If you have a good idea of the basics behind database administration and need a practical guide to how to actually administer a MySQL database, including the tools available to you, I'd seriously recommend that you take a look at this book.

LIMITATIONS:
- I was a bit concerned about the book's information on early-stage tools like MySQL Proxy and MySQL 6.0. They haven't been released for general use and are not certified as stable, but the book just lists them with other tools as if you could just drop them in. Be careful.
- As another reader pointed out, it's not the easiest read. But then, if you've never used SQL, never mind MySQL before, then trying to understand concepts like the difference between READ COMMITTED and SERIALIZABLE isolation levels will surely result in pain and death. This book is much better if you have a question like "How do I backup a MySQL database?", "How do I make a trigger", or "How do I set up replication?"

18 people found this helpful

Helpful

R. Stone

I really like this book

Reviewed in the United States on February 22, 2014

Verified Purchase

Even though this book is almost five years old it still does a great job providing the information necessary for an individual to become a world class Administrator! I would highly recommend this book to anyone: current administrators, new administrators, and casual administrators. You may have to look at the documentation for your specific MySQL version for some syntax correction, but for the most part this book is spot on.

Helpful

Ronald Bradford

A great reference guide for the new MySQL DBA

Reviewed in the United States on December 5, 2013

Verified Purchase

To fully grasp the scope of any technology you need a reference bible. This book, as the title suggests, is that reference for a new MySQL DBA that I would highly recommend.

When becoming proficient in any technology you need to grasp the full scope of the product. This book covers 22 chapters from your first exposure in MySQL, to necessary administration tasks, to key advanced features including optimization, security and scalability. If you are an experienced DBA in a different technology, knowing how to use the MySQL specific syntax, and knowing all the options is an important step in becoming MySQL savvy. This book gets you there.

While I may be an experienced MySQL DBA, and am familiar with the content, I have still reviewed various sections of this book and used this as a reference for specific syntax. I also recommend this book regularly to resources that ask questions where a solid grasp of the scope of the MySQL product is needed.

I have this on my bookshelf as a valuable MySQL reference.

Reviewed in the United States on January 16, 2013

Verified Purchase

The content of the book is excellent and very complete, not the best printing quality but its ok acording to the price

One person found this helpful

Helpful

David Childers

Don't DBA Without It

Reviewed in the United States on November 3, 2016

Verified Purchase

Not only is this book well written, it contains all of the issues that I have encountered since becoming a Certified MySQL DBA.
Each of the topics is covered accurately and sufficiently so that MySQL DBAs can do their jobs.
An excellent index along with Appendix B provide shortcuts to the core issues you will encounter.
This book will make your life as a MySQL DBA a more pleasant experience.

One person found this helpful

Helpful

Kevin

Everything you need to know about MySQL... ...

Reviewed in the United States on September 26, 2014

Verified Purchase

Everything you need to know about MySQL... This is an extremely handy reference book, thick, detailed, whatever you need to know is in here. A must for the professional reference library.

Helpful

Anthony E. Rutledge

You need this historical reasons and mastery.

Reviewed in the United States on January 16, 2017

Verified Purchase

A must have for MySQL administrators. Trust me. The MySQL manual can only take you so far.

Helpful

scg

Not for the novice despite claim to be so

Reviewed in the United States on May 31, 2009

Verified Purchase

I purchased this book to learn MySQL and get back up to speed since I have been out of the computer world for a few years. I found on page 54 that the author finally tells you that the SAKILA sample DB is used thoughout the book. Well I don't know why because on the MySQL website in the developer forums you will find all the way back to September of 2006 the fact that the SAKILA DB fails to install for many reasons and there are even questions if it is even maintained or supported any longer. Many of the posters to the forum strike me as very experienced. So I am not alone in my frustrations and that thus far there is no answer to the problem. I believe the author should have used a different sample DB for the book or included a know working version of SAKILA on a CD in the book.

Secondly on page 68 you see the graphic of SQLyog Enterprise Trail Version that is being used but nowhere is there a mention that for non-commerical use, that is, your own personal use it will cost you $79. Gee so if I what to get past the 30 day trial while studying from the authors book I will have to invest another $79 beyound the cost of this book? Why is this little tid bit ignored and buried on page 68?

I could go on but the back cover of this book doesn't tell the truth about the target audience. If you are trying to learn SQL on your own or trying to refresh yourself this is not the book. If you have an intermediate understanding or better then this book will do you some good.

8 people found this helpful

Helpful

Top reviews from other countries

MannyC

Five Stars

Reviewed in Canada on July 6, 2018

Verified Purchase

Good source of information for intermediate level and lower.

Mr. Ejimofor Kenneth Nwoye

Classic MySQL Reference

Reviewed in the United Kingdom on December 28, 2012

Verified Purchase

Classic MySQL reference in detail terms. However it's shortcomings is in it's failure to cover recent developments, since SUN's acquisition by Oracle

One person found this helpful

See more reviews

Return this item for free

Image Unavailable

Follow the author