- 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: 19 customer reviews
- Amazon Best Sellers Rank: #922,801 in Books (See Top 100 in Books)
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.
To get the free app, enter your mobile phone number.
MySQL Administrator's Bible 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
Frequently bought together
Customers who bought this item also bought
Customers who viewed this item also viewed
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 responsiblethese include:
MySQL Server tuning
Query optimization and index tuning
Managing storage engines
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.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
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.
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. 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.
- 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?"
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.
Most recent customer reviews
If you work in MYSQL try this one.