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

Edit | Attach | Watch | Print version | History: r13 | r4 < r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r1 - 2013-08-12 - GeorgeBrown
 
  • Edit
  • Attach
This site is powered by the TWiki collaboration platform Powered by Perl This site is powered by the TWiki collaboration platformCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback