MySQL replication
Usage
- slurm1 and slurm2 make use of master master semisynchronous replication
Requirements
Semisynchronous replication requires
MySQL 5.5 or newer. SL6 ships with
MySQL 5.1.x as such you will have do download the newer RPMs from the
MySQL website.
These RPMs have been copied to the Phoenix repo and are available through yum. Note you will have to first install
MySQL-shared-compat package as otherwise you will receive an error about conflicts.
Setup
- slurm1 and slurm2 are both masters
- Both can be written to can changes will be replicated to the other node.
- slurm1 and slurm2 are both semisynchronous masters and slaves
- When a transaction is performed on either node the change is replicated before returning (timeout for this is 10 seconds).
TBA: Visual diagram
Config
TBA
Testing
TBA
Monitoring
TBA
Further reading
--
GeorgeBrown - 2013-08-12