High Availability MySQL Cookbook
High Availability with MySQL Cluster
Creating an initial cluster configuration file—config.ini
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
MySQL Cluster Backup and Recovery
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
Configuring multiple management nodes
Replicating between MySQL Clusters
Replication between clusters with a backup channel
Calculating DataMemory and IndexMemory
Multiple storage node failures
Storage node partitioning and arbitration
NIC teaming with MySQL Cluster
High Availability with MySQL Replication
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
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)
High Availability with MySQL and Shared Storage
Preparing a Linux server for shared storage
Configuring two servers for shared storage MySQL
Configuring MySQL on shared storage with Conga
High Availability with Block Level Replication
Installing DRBD on two Linux servers
Manually moving services within a DRBD cluster
Using heartbeat for automatic failover
Tuning MySQL Cluster storage nodes
Tuning MySQL Cluster SQL nodes
Tuning queries within a MySQL Cluster
Highly Available Architectures
Highly Available Architectures