Chapter 5. High Availability with MySQL Replication
In this chapter, we will cover:
- Designing a replication setup
- Configuring a replication master
- Configuring a replication slave without synchronizing data
- Configuring a replication slave and migrating data with a simple SQL dump
- Using LVM to reduce downtime on master when bringing a slave online
- Replication safety tricks
- Multi Master Replication Manager (MMM)
- Initial installation
- Installing the MySQL nodes
- Installing the monitoring node
- Managing and using Multi Master Replication Manager (MMM)
Introduction
MySQL Replication is a feature of the MySQL server that allows you to replicate data from one MySQL database server (called the master) to one or more MySQL database servers (slaves). Replication is asynchronous, ...
Get High Availability MySQL Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
