froscon2009 - 1.0

Free and Open Source Software Conference

Walter Heck
Day Day 1 (2009-08-22)
Room HS5
Start time 16:30
Duration 01:00
ID 357
Event type Lecture
Track Databases
Language used for presentation English

MySQL Multi-Master Replication Failover - A step-by-step explanation

How to setup a MySQL cluster with Automatic failover for HA

This talk will show you how to setup a cluster of MySQL servers that use the MMM software to create the ability to have Master-Master Active-Passive failover. An explanation of the software involved and the structure needed, as well as an in-dept overview of what is needed will be given.

Overview of topics handled in the presentation:

  • What is MMM (and what is it not)? -advantages/drawbacks

  • The architecture that will be setup -6 servers: 1 web, 1 monitoring, 2 databas masters, 2 database slaves

  • Overview of what is needed for this setup -network security: ports and interfaces -software: MMM, OurDelta MySQL build -OS: Linux
  • OS configuration -iptables -logrotate
  • MySQL Replication setup
  • Install MMM
  • Configure MMM
    • custom checker threads
    • angel daemons
  • general operation of MMM
    • monitoring
  • pitfalls

  • Conclusion

  • Questions