Hello World, this is a test. ×

Dear Customer, If you wish to purchase more than 5 copies or in bulk, please contact our bulk purchase department at [email protected]



Please enter your login details


Forgot Password?

It happens, just reset it in a minute

Sorry, incorrect details. ×
Welcome back pal! ×



Please enter your User Name, email ID
and a password to register

No CVV Stored

Our website will not store CVV of your card.

Safe & Secure

Our website is secured by 256 bit SSL encryption issued by Verisign Inc, making your shopping at Sapnaonline as secure as possible.

International Shipping

at best shipping prices!

If you need any of your orders' to be delivered outside of India, please reach out to us via our contact us page with the product details and delivery location for us to quote you the best possible shipping price. You can also drop in a mail at [email protected]

Notify Me

We will send an email as soon as we get it in stock.

Write a Testimonial

Few good words, go a long way, thanks!


Personalize Gift card

We will send an email to receiver for gift card.


Track Order

Enter Order ID & Email Address to track your Order.

Check Your Sapna Gift Card Balance

(Card can be redeemed only at Sapna Retail Outlets)

Reminder: Free shipping if your order is above `199
Notification Alert
We offer free shipping for all orders above `199. To avail this offer, add another item of `0 or more from our wide range of quality books available at SapnaOnline.com

Reset Pincode

Submit a Review

Sorry, incorrect details. ×
High Availability Mysql Cookbook
Review Rating

(Click on below image to change)

High Availability Mysql Cookbook

(Click on image to Zoom)

High Availability Mysql Cookbook

Alex Davies

Published by Shroff | Language - English | Binding - Paper Back

Average Rating (99 Customers)

` 799

+ The price is inclusive of GST.
+ Free Shipping (for orders above `199).


Over 60 simple but incredibly effective recipes focusing on different methods of achieving high availability for MySQL database

  • 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

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

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

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 written 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.

About the Author
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.

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


Book: High Availability Mysql Cookbook
ISBN-13: 9789350231722
Product Code 9789350231722
Binding: Paper Back
Publishing Date: 2012-11
Publisher: Shroff
Number of Pages: 284
Language: English

Customer Reviews

Loading reviews. Please wait...
Check Delivery Status
Dispatched in 2-4 working days.
Check Delivery Status
Available options for this porduct
Availability In Stock
Hurry up!!! Start Shopping. Before stock lasts.
Guaranteed service
Assured best in class service and support.
International Shipping available
If you need any of your orders' to be delivered outside of India, please reach out to us via our contact us page with the product details and delivery location for us to quote you the best possible shipping price. You can also drop in a mail at [email protected]