High Availability MySQL Cookbook

Chapter 6. High Availability with MySQL and Shared Storage

In this chapter, we will cover:

• Preparing a Linux server for shared storage
• Configuring two servers for shared storage MySQL
• Configuring MySQL on shared storage with Conga
• Fencing for high availability
• Configuring MySQL with GFS

Introduction

In this chapter, we will look at high-availability techniques for MySQL that rely on shared storage. The techniques covered elsewhere in this book have produced highly-available systems while maintaining the independence of each machine involved. Each machine had its own disk drive and the data in the database is synced at application level between the servers using replication or MySQL clustering. With shared storage, the actual database data is not stored ...