froscon2009 - 1.0
FrOSCon
Free and Open Source Software Conference
| Referenten | |
|---|---|
|
Walter Heck |
| Programm | |
|---|---|
| Tag | Day 1 (2009-08-22) |
| Raum | HS5 |
| Beginn | 16:30 |
| Dauer | 01:00 |
| Info | |
| ID | 357 |
| Veranstaltungstyp | Vortrag |
| Track | Databases |
| Sprache der Veranstaltung | englisch |
| Feedback | |
|---|---|
|
Haben Sie diese Veranstaltung besucht? Feedback abgeben |
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