High Availability MySQL Cookbook

High Availability MySQL Cookbook
eBook: $26.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $71.98    Print cover: $44.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • Analyze and learn different high availability options, including clustering and replication solutions within MySQL
  • Improve uptime of your MySQL databases with simple recipes showing powerful high availability techniques for MySQL
  • Tune your MySQL database for optimal performance.
  • The only complete, practical, book of MySQL high availability techniques and tools on the market
  • Part of Packt's Cookbook series: Each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible

Book Details

Language : English
Paperback : 264 pages [ 235mm x 191mm ]
Release Date : April 2010
ISBN : 1847199941
ISBN 13 : 9781847199942
Author(s) : Alex Davies
Topics and Technologies : All Books, Big Data and Business Intelligence, Data, Cookbooks, MySQL, Open Source

Table of Contents

Chapter 1: High Availability with MySQL Cluster
Chapter 2: MySQL Cluster Backup and Recovery
Chapter 3: MySQL Cluster Management
Chapter 4: MySQL Cluster Troubleshooting
Chapter 5: High Availability with MySQL Replication
Chapter 6: High Availability with MySQL and Shared Storage
Chapter 7: High Availability with Block Level Replication
Chapter 8: Performance Tuning
Appendix A: Base Installation
Appendix B: LVM and MySQL
Appendix C: Highly Available Architectures
  • Chapter 1: High Availability with MySQL Cluster
    • Introduction
    • Designing a MySQL Cluster
    • Creating an initial cluster configuration file—config.ini
    • Installing a management node
    • Starting a management node
    • Installing and starting storage nodes
    • Installing and starting SQL nodes
    • Creating a MySQL Cluster table
    • Restarting a MySQL Cluster without downtime
    • Recovering from a cluster shutdown
  • Chapter 2: MySQL Cluster Backup and Recovery
    • Introduction
    • Importing SQL files to a MySQL server and converting them to MySQL Cluster
    • Taking an online backup of a MySQL Cluster
    • Restoring from a MySQL Cluster online backup
    • Restricting write access to a MySQL Cluster with single-user mode
    • Taking an offline backup with MySQL Cluster
  • Chapter 3: MySQL Cluster Management
    • Introduction
    • Configuring multiple management nodes
    • Obtaining usage information
    • Adding storage nodes online
    • Replicating between MySQL Clusters
    • Replication between clusters with a backup channel
    • User-defined partitioning
    • Disk-based tables
    • Calculating DataMemory and IndexMemory
  • Chapter 4: MySQL Cluster Troubleshooting
    • Introduction
    • Single storage node failure
    • Multiple storage node failures
    • Storage node partitioning and arbitration
    • Debugging MySQL Clusters
    • Seeking help
    • NIC teaming with MySQL Cluster
  • Chapter 5: High Availability with MySQL Replication
    • Introduction
    • Designing a replication setup
    • Configuring a replication master
    • Configuring a replication slave without syncing data
    • Configuring a replication slave, migrating data with a simple SQL dump
    • Using LVM to reduce downtime on a master when bringing a slave online
    • Replication safety tricks
    • Multi Master Replication Manager (MMM): initial installation
    • Multi Master Replication Manager (MMM): installing the MySQL nodes
    • Multi Master Replication Manager (MMM): installing monitoring node
    • Managing and using Multi Master Replication Manager (MMM)
  • Chapter 8: Performance Tuning
    • Introduction
    • Tuning the Linux kernel IO
    • Tuning MySQL Cluster storage nodes
    • Tuning MySQL Cluster SQL nodes
    • Tuning queries within a MySQL Cluster
    • Tuning GFS on shared storage
    • MySQL Replication tuning

Alex Davies

Alex Davies has a wealth of experience working with MySQL, becoming a founding member of the MySQL Guilds before the age of 18. Author of the first book on MySQL Clustering, published in 2006, Alex has significant experience working on MySQL servers, often working on scalability and high availability problems.

Code Downloads

Download the code and support files for this book.

Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

High Availability MySQL Cookbook +    Clojure for Machine Learning =
50% Off
the second eBook
Price for both: $39.00

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • Configure a MySQL Cluster for scaling out MySQL
  • Learn the technique of taking online backups and recovery
  • Achieve high availability with MySQL Replication and various tools such as the open source Multi-Master Replication Manager (MMM) and Flipper projects
  • Configure a MySQL replication design to replicate data from one MySQL database server to one or more other MySQL database servers
  • Master the safety tricks of replication to prevent replication failure
  • Configure a MySQL service to work using a shared storage device to achieve high availability, with and without a clustered filesystem
  • Learn to use the open source Global File System (GFS) to have the same file system on more than one node
  • Achieve high availability using block level replication with Distributed Replicated Block Device (DRBD)
  • Improve your system's performance with the technique of performance tuning

In Detail

High Availability is something that all web sites hope to achieve, especially those that are linked to big companies.

MySQL, an open source relational database management system (RDBMS), can be made highly available to protect from corruption, hardware failure, software crashes, and user error. Running a MySQL setup is quite simple. Things start getting complex when you start thinking about the best way to provide redundancy. There are a large number of techniques available to add 'redundancy' and 'high availability' to MySQL, but most are both poorly understood and documented.

This book will provide you with recipes showing how to design, implement, and manage a MySQL Cluster and achieve high availability using MySQL replication, block level replication, shared storage, and the open source Global File System (GFS).

This book covers all the major techniques available for increasing availability of your MySQL databases. It demonstrates how to design, implement, troubleshoot and manage a highly available MySQL setup using any one of several techniques, which are shown in different recipes. It is based on MySQL Cluster 7.0, MySQL (for non clustered recipes) 5.0.77, and CentOS / RedHat Enterprise Linux 5.3.

The book starts by introducing MySQL Cluster as a technology and explaining how to set up a simple cluster. It will help you to master the options available for backing up and restoring a file in the MySQL Cluster. By following the practical examples in this book, you will learn how to manage the MySQL Cluster. Further, we will discuss some troubleshooting aspects of the MySQL Cluster.

We also have a look at achieving high availability for MySQL databases with the techniques of MySQL Replication, block level replication, shared storage (a SAN or NAS), and DRBD.

Finally, you will learn the principles of Performance tuning and tune MySQL database for optimal performance.

A cookbook containing recipes for all the common high availability techniques for database administrators to tackle real-world challenges to achieve high availability using MySQL


This book uses the approach of a cookbook. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. It is designed to present what often appear as extremely complicated techniques as a series of simple-to-follow recipes, allowing readers to achieve high uptimes on their MySQL servers.

Who this book is for

This book is targeted at system administrators or database administrators who have basic familiarity with Linux, the shell, and MySQL. The typical user will be able to get MySQL installed and working, but needs practical guidance to make it highly available.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software