- Amazon Student members save an additional 10% on Textbooks with promo code TEXTBOOK10. Enter code TEXTBOOK10 at checkout. Here's how (restrictions apply)
MySQL High Availability: Tools for Building Robust Data Centers Paperback – Jul 26 2010
There is a newer edition of this item:
Special Offers and Product Promotions
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
To get the free app, enter your e-mail address or mobile phone number.
Tools for Building Robust Data Centers
About the Author
Dr. Charles A Bell is a Senior Software Engineer at Oracle. He iscurrently the lead developer for backup and a member of the MySQLBackup and Replication team. He lives in a small town in ruralVirginia with his loving wife. He received his Doctor of Philosophy inEngineering from Virginia Commonwealth University in 2005. Hisresearch interests include database systems, versioning systems,semantic web, and agile software development.
Dr. Mats Kindahl is principal senior software developer in the MySQL team at Oracle. He is the main architect and implementor of MySQL’s row-based replication and several other replication features and is currently architect and project lead for the MySQL High-Availability team that develop MySQL Fabric. Before starting at MySQL, he did research in formal methods, program analysis, and distributed systems, the area where he earned his doctoral degree in computer science. He has also spent several years developing C/C++ compilers.
Dr. Lars Thalmann is the development manager for MySQL replication andbackup. He is responsible for the strategy and development of thesefeatures and leads the corresponding engineering teams. Thalmann hasworked with MySQL development since 2001, when he was a softwaredeveloper working on MySQL Cluster. More recently, he has driven thecreation and development of the MySQL backup feature, has guided theevolution of MySQL replication since 2004, and has been a key playerin the development of MySQL Cluster replication. Thalmann holds adoctorate in Computer Science from Uppsala University, Sweden.
Inside This Book(Learn More)
Most Helpful Customer Reviews on Amazon.com (beta)
This is a brilliant and powerful book. I picked this up in the bookstore and couldn't stop reading it. It's not the only resource available on MySQL replication, monitoring, and clustering, and another title, High Performance MySQL: Optimization, Backups, Replication, and More, has a few chapters that overlap with the topics in this book.
That being said, I liked the tone and pace of this book, and it goes more in-depth than many other similar titles that cover the same material. It made concepts stick to my brain like no other MySQL book I've read so far. The authors make the material very accessible, even though it's not easy subject matter. For me, it shed a lot of light on some mysterious MySQL topics.
It's not a beginner's book, but if you've been working comfortably with a MySQL shell at a startup for a while, are interested in digging deeper, and you're looking for an excuse to buy another computer book, this one is definitely worth it.
- It shows in great length how to use netstat, a disk usage analyzer, or the Mac OS X Activity Monitor.
- There is a pointless story about some Joel guy (and how he becomes friends with a girl called Amy) throughout the book which just increases page count.
- A whole chapter deals with the very basics of database performance (read MySQL High Performance, if you want to know about that).
- Several pages cover two python scripts that essentially call an external command with a filename including a date. This can be done with a single line of bash by anyone seriously in the business.
- It explains how file globbing can lead to a wrong sequence in filenames,
- Bad editing shows in several repeated paragraphs.
The authors just don't seem to have a feeling about how to treat their audience by going to such low levels at times that it is close to insulting.
There are some nice parts of the book, though. The appendix with Replication Tips and Tricks finally shows that some author had indeed to deal with problems that happen in daily life.
I would have expected the book to delve into real world problems such as:
- schema changes with no or little outage
- table repairing best practises (i.e. quick recovery, decision making on whether to go to a backup, etc.) and going into reasons on why tables can get corrupted and how to avoid it
- high availability without replication. Sometimes it is not feasible to have multiple servers for certain tasks. How can you decrease downtimes in case something does go wrong?
Too bad, it could have been an interesting book, but it misses out on that chance.
I am not a MySQL professional, so my comments bellow shall be taken as a suggestion from a Sr Software Developer, not from a DBA. I used to work many years with Oracle but my experience in MySQL is definitely not as good as in Oracle.
I think that readers of this book shall have a good background in general RDBMS systems, already understand the principles of high availability, being at least medium skilled on how to administer MySQL and eventually they have already deal with issues like monitoring or backup/recovery.
The book is excellent structured and easy to read if you understand the concepts. If you are already skilled with Oracle some of the stuff here will look ancient and so primitive, but keep in mind that is not always easy to sponsor a project that is going to use Oracle.
My favorite chapters are the one about HA environments, a good intro (the first I ever see) about techniques for using MySQL in a cloud environment like Amazon's AWS.
Another argument to convince you to read this book: is full of examples. many books talks about these concepts without giving examples. You will find here sql scripts, PHP code, Python code, screen captures, very practical examples for how to start and stop slave threads, running replication over a PKI infrastructure, monitor the storage engine and many others.
If all these are not enough (believe me, it's a big comprehensive reference, it was not my case to fully use it anyway), so if all these are not enough you will find an appendix really useful: tips and tricks for running and diagnosing (yes, diagnosing) MySQl replication. Here are some tips: what to do when slave stopped, only replicate some rows to slave or how to allow a slave to periodically challenge the master.
Look for similar items by category
- Books > Computers & Technology > Databases > Specific Databases > MySQL & mSQL
- Books > Computers & Technology > Web Development > Programming > SQL
- Books > Textbooks > Computer Science & Information Systems > Database Storage & Design
- Books > Textbooks > Computer Science & Information Systems > Programming Languages