High Availability MySQL Cookbook

There's more than one way to achieve high availability for MySQL and this Cookbook covers a range of techniques and tools in over 60 practical recipes. The only book of its kind, you'll be learning the natural, engaging way.

High Availability MySQL Cookbook

Alex Davies

There's more than one way to achieve high availability for MySQL and this Cookbook covers a range of techniques and tools in over 60 practical recipes. The only book of its kind, you'll be learning the natural, engaging way.
Mapt Subscription
FREE
$30.00/m after trial
eBook
$18.90
RRP $26.99
Save 29%
Print + eBook
$44.99
RRP $44.99
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$18.90
$44.99
$29.99 p/m after trial
RRP $26.99
RRP $44.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


High Availability MySQL Cookbook Book Cover
High Availability MySQL Cookbook
$ 26.99
$ 18.90
Creating your MySQL Database: Practical Design Tips and Techniques  Book Cover
Creating your MySQL Database: Practical Design Tips and Techniques
$ 11.99
$ 8.40
Buy 2 for $25.90
Save $13.08
Add to Cart

Book Details

ISBN 139781847199942
Paperback276 pages

Book Description

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.

Table of Contents

What You Will Learn

  • 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

Authors

Table of Contents

Book Details

ISBN 139781847199942
Paperback276 pages
Read More

Read More Reviews

Recommended for You

Creating your MySQL Database: Practical Design Tips and Techniques  Book Cover
Creating your MySQL Database: Practical Design Tips and Techniques
$ 11.99
$ 8.40
MySQL for Python Book Cover
MySQL for Python
$ 29.99
$ 21.00
Mastering phpMyAdmin 3.4 for Effective MySQL Management Book Cover
Mastering phpMyAdmin 3.4 for Effective MySQL Management
$ 23.99
$ 16.80
MySQL Admin Cookbook LITE: Configuration, Server Monitoring, Managing Users Book Cover
MySQL Admin Cookbook LITE: Configuration, Server Monitoring, Managing Users
$ 9.99
$ 7.00
Getting Started with NoSQL Book Cover
Getting Started with NoSQL
$ 14.99
$ 10.50
MySQL Admin Cookbook LITE: Replication and Indexing Book Cover
MySQL Admin Cookbook LITE: Replication and Indexing
$ 9.99
$ 7.00