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

" summary

Shows how to build a high-availability MySQL cluster using MMM (Master-Master active-passive failover) on Linux, with a six-server architecture: 1 web, 1 monitoring, 2 database masters and 2 database slaves. Covers required software (MMM, OurDelta MySQL), OS/network configuration (iptables, logrotate, ports/interfaces), MySQL replication setup, MMM installation and configuration (custom checker threads and angel daemons), operation/monitoring and common pitfalls.

AI-written summary · about

" related talks

• 14mThe State of the Art of MySQL ReplicationRicky Setyawan · FOSSASIA Summit 2017
• 43mMySQL Failover for Asynchronous replication with Orchestrator, ProxySQL and ConsulYunus Shaikh · Percona Live 2022
• 54mThe Evolution of a MySQL Database, From a Single Instance to HA With Disaster RecoveryFrederic Descamps · Percona Live 2022
• 35mMySQL HA, Recovery and Load BalancingDavey Shafik · SunshinePHP 2014
• 52mBest Practices for MySQL High Availability in 2022Colin Charles · Percona Live 2022
• 41mAutopsy of a MySQL Automation DisasterJean-François Gagné · SREcon19 Europe/Middle East/Africa
• 49mMySQL Replication — Advanced FeaturesPetr Zaytsev · HighLoad++ 2017
• 46mDatabase Reliability Engineering for MySQLMatthias Crauwels · Percona Community Live 2022