High Availability MySQL Cookbook Table Of Contents

Table of Contents

Preface
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
Index

• Preface

• 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 6: High Availability with MySQL and Shared Storage
  • Introduction
  • 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

• Chapter 7: High Availability with Block Level Replication
  • Introduction
  • Installing DRBD on two Linux servers
  • Manually moving services within a DRBD cluster
  • Using heartbeat for automatic failover

• 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

• Appendix A: Base Installation

• Appendix B: LVM and MySQL

• Appendix C: Highly Available Architectures
  • Single-site architectures
  • Multi-site architectures
  • Summary of options

• Index