{"guid":"d665f87f-1b13-5ec5-a951-0163df6c2523","title":"MySQL Multi-Master Replication Failover - A step-by-step explanation","subtitle":"How to setup a MySQL cluster with Automatic failover for HA","slug":"HS5_-_MySQL_Multi-Master_Replication_Failover_-_A_step-by-step_explanation_-_357","link":"https://c3voc.de","description":"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.\n\nOverview of topics handled in the presentation:\n\n- What is MMM (and what is it not)?\n  -advantages/drawbacks\n\n- The architecture that will be setup\n  -6 servers: 1 web, 1 monitoring, 2 databas masters, 2 database slaves\n- Overview of what is needed for this setup\n  -network security: ports and interfaces\n  -software: MMM, OurDelta MySQL build\n  -OS: Linux\n- OS configuration\n  -iptables\n  -logrotate\n- MySQL Replication setup\n- Install MMM\n- Configure MMM\n  - custom checker threads\n  - angel daemons\n- general operation of MMM\n  - monitoring\n- pitfalls\n\n- Conclusion\n- Questions","original_language":"eng","persons":["Walter Heck"],"tags":["froscon2009","357","2009","Databases"],"view_count":133,"promoted":false,"date":"2009-08-22T16:30:00.000+02:00","release_date":"2020-01-04T01:00:00.000+01:00","updated_at":"2026-03-25T11:30:11.112+01:00","length":2940,"duration":2940,"thumb_url":"https://static.media.ccc.de/media/events/froscon/2009/357-sd.jpg","poster_url":"https://static.media.ccc.de/media/events/froscon/2009/357-sd_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/froscon/2009/357-sd.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/froscon/2009/357-sd.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/HS5_-_MySQL_Multi-Master_Replication_Failover_-_A_step-by-step_explanation_-_357","url":"https://api.media.ccc.de/public/events/d665f87f-1b13-5ec5-a951-0163df6c2523","conference_title":"FrOSCon 2009","conference_url":"https://api.media.ccc.de/public/conferences/froscon2009","related":[],"recordings":[{"size":131,"length":2940,"mime_type":"video/mp4","language":"eng","filename":"froscon2009-357-eng-MySQL_Multi-Master_Replication_Failover_-_A_step-by-step_explanation_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2020-01-04T23:34:58.837+01:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2009/h264-sd/froscon2009-357-eng-MySQL_Multi-Master_Replication_Failover_-_A_step-by-step_explanation_sd.mp4","url":"https://api.media.ccc.de/public/recordings/44749","event_url":"https://api.media.ccc.de/public/events/d665f87f-1b13-5ec5-a951-0163df6c2523","conference_url":"https://api.media.ccc.de/public/conferences/froscon2009"}]}