MySQL High Availability and over 1.5 million other books are available for Amazon Kindle . Learn more


or
Sign in to turn on 1-Click ordering.
Trade in Yours
For a £2.65 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Share your own customer images
Search inside this book
Start reading MySQL High Availability on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

MySQL High Availability: Tools for Building Robust Data Centers [Paperback]

Charles Bell (Author), Mats Kindahl (Author), Lars Thalmann (Author)
5.0 out of 5 stars  See all reviews (1 customer review)
RRP: £38.50
Price: £24.64 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £13.86 (36%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 2 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want delivery by Tuesday, 28 May? Choose Express delivery at checkout. See Details

Formats

 Amazon Price New from Used from
Kindle Edition £20.94   -- --
Paperback £24.64   -- --
Books Trade-In
Amazon.co.uk Trade-In Store
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Books Trade-In Store for more details. Learn more.
There is a newer edition of this item:
MySQL High Availability: Tools for Building Robust Data Centers MySQL High Availability: Tools for Building Robust Data Centers
£38.50
Available for pre-order

Book Description

Publication Date: 23 July 2010 | ISBN-10: 0596807309 | ISBN-13: 978-0596807306 | Edition: 1

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
"MySQL replication is widely deployed but has never been adequately explained. This book changes that." -- Mark Callaghan, MySQL contributor and leader of MySQL engineering efforts at a few of the world's largest Internet companies

Frequently Bought Together

MySQL High Availability: Tools for Building Robust Data Centers + High Performance MySQL: Optimization, Backups, and Replication + MySQL Administrator's Bible (Bible (Wiley))
Price For All Three: £71.03

Buy the selected items together

Product details

  • Paperback: 624 pages
  • Publisher: O'Reilly Media; 1 edition (23 July 2010)
  • Language: English
  • ISBN-10: 0596807309
  • ISBN-13: 978-0596807306
  • Product Dimensions: 17.8 x 3.1 x 23.3 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 152,180 in Books (See Top 100 in Books)

    •  Would you like to update product info or give feedback on images?

  • See Complete Table of Contents

More About the Author

› Visit Amazon's Charles A. Bell Page
Charles A. Bell
Discover books, learn about writers, and more.

Product Description

Book Description

Tools for Building Robust Data Centers

About the Author

Dr. Charles A Bell is a Senior Software Engineer at Oracle. He is currently the lead developer for backup and a member of the MySQL Backup and Replication team. He lives in a small town in rural Virginia with his loving wife. He received his Doctor of Philosophy in Engineering from Virginia Commonwealth University in 2005. His research interests include database systems, versioning systems, semantic web, and agile software development.

Dr. Mats Kindahl is a senior software developer working on the MySQL server. He is the main architect and implementor of MySQL's row-based replication and is responsible for strategic development of replication, reengineering, and the plugin architecture. 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 many years developing C/C++ compilers and knows more programming languages than he has fingers.

Dr. Lars Thalmann is the development manager for MySQL replication and backup. He is responsible for the strategy and development of these features and leads the corresponding engineering teams. Thalmann has worked with MySQL development since 2001, when he was a software developer working on MySQL Cluster. More recently, he has driven the creation and development of the MySQL backup feature, has guided the evolution of MySQL replication since 2004, and has been a key player in the development of MySQL Cluster replication. Thalmann holds a doctorate in Computer Science from Uppsala University, Sweden.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

› Explore similar items

Customer Reviews

5 star
1
4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
1 review
5.0 out of 5 stars
Most Helpful Customer Reviews
5.0 out of 5 stars MySQL for today's web demands 3 May 2012
By Andy Spanswick
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 :)
Comment | 
Was this review helpful to you?
Yes
No
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.0 out of 5 stars  3 reviews
17 of 17 people found the following review helpful
5.0 out of 5 stars Really Great MySQL Resource 1 Dec 2010
By Jim McGaw - Published on Amazon.com
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.
3 of 3 people found the following review helpful
5.0 out of 5 stars A book for MySQL Professionals 5 Oct 2011
By Ionel Condor - Published on Amazon.com
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.
1 of 1 people found the following review helpful
2.0 out of 5 stars Well below expectations 18 Feb 2013
By ak - Published on Amazon.com
Format:Paperback
This book was a disappointment. It should be called "MySQL Replication for System Administrator beginners":

- 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.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

There's a problem loading this menu at the moment.

Learn more about Amazon Prime.

    Your Shopping Basket is empty.

    Give it purpose -- fill it with books, DVDs, clothes, electronics and more.

    If you already have an account, sign in.

    There's a problem previewing your shopping basket at the moment.

    Check your Internet connection and go to your cart, or try again.

    View Shopping Basket (0 items)

      Customer Discussions

      This product's forum
      Discussion Replies Latest Post
      No discussions yet

      Ask questions, Share opinions, Gain insight
      Start a new discussion
      Topic:
      First post:
      Prompts for sign-in
       

      Search Customer Discussions
      Search all Amazon discussions
         

      Listmania!

      Create a Listmania! list

      Look for similar items by category

      Feedback


      Amazon.co.uk Privacy Statement Amazon.co.uk Delivery Information Amazon.co.uk Returns & Exchanges