MySQL High Availability
and over one million other books are available for Amazon Kindle .
Learn more
| |||||||||||||||
 Trade In this Item for up to £12.30
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in MySQL High Availability: Tools for Building Robust Data Centers for an Amazon.co.uk gift card of up to £12.30, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Book Description
Tools for Building Robust Data Centers
Product Description
Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. MySQL has several features that can help you protect your system from outages, whether it's running on hardware, virtual machines, or in the cloud. MySQL High Availability explains how to use these replication, cluster, and monitoring features in a wide range of real-life situations.
Written by engineers who designed many of the tools covered inside, this book reveals undocumented or hard-to-find aspects of MySQL reliability and high availability -- knowledge that’s essential for any organization using this database system.
- Explore the binary log, a file for replication that helps in disaster recovery and troubleshooting
- Get techniques for improving response time and handling large data sets
- Monitor database activity and performance, as well as major operating system parameters
- Keep track of what masters and slaves are doing, and deal with failures and restarts, corruption, and other incidents
- Automate key tasks with code from an open source library written by the authors
- Learn techniques for using MySQL in virtualized environments, such as Amazon Web Services
- Use MySQL Cluster to achieve high availability
Inside This Book
(Learn More)
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
Format:Paperback|Amazon Verified Purchase
This book has led me from intermediate tutorial follower to finally understanding the real tricks of making this work on large data sets with replication and scaled out servers. Finally all my little questions are answered in this book. Without a doubt this is THE book I needed, if only I had bought this one before!
This book is not for a noobie, you will need to understand the basics and know scripting basics (Python/Perl) and server terminology. However, if you have dabbled in Linux/Doze servers and you know about the command line then you are pretty much set to go.
This book is a must for anyone looking to handle datasets. Be it a small site with replication to a globally deployed on demand scaled web site with fault tolerances.
Good luck without it :)
This book is not for a noobie, you will need to understand the basics and know scripting basics (Python/Perl) and server terminology. However, if you have dabbled in Linux/Doze servers and you know about the command line then you are pretty much set to go.
This book is a must for anyone looking to handle datasets. Be it a small site with replication to a globally deployed on demand scaled web site with fault tolerances.
Good luck without it :)
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
2 reviews
16 of 16 people found the following review helpful
Really Great MySQL Resource
1 Dec 2010
Format:Paperback
I'm not a DBA, just a lowly web applications developer who happens to use MySQL as a backend most of the time. I've been developing with a lot of nagging questions in my brain: "How do you set up a master-slave replication?" "How do you roll back the database to a past point in time?" (The kinds of nagging questions that, as a Django or Rails developer, tend to be "someone else's problem.")
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.
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.
2 of 2 people found the following review helpful
A book for MySQL Professionals
5 Oct 2011
Format:Paperback
Well,
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.
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.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
