MySQL Multi-Master Replication Failover - A step-by-step explanation (froscon2009)
How to setup a MySQL cluster with Automatic failover for HA
Chaos Computer Club - archive feed · Walter Heck
August 22, 200949m 0s
Audio is streamed directly from the publisher (cdn.media.ccc.de) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
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
about this event: https://c3voc.de
Topics
froscon20093572009Databases