June 19, 2013

Post: Finding your MySQL High-Availability solution – The questions

… MySQL replication no Master-Master with MMM manager no Heartbeat/SAN (depends on SAN) yes Heartbeat/DRBD yes NDB Cluster yes 3. Does your… MySQL replication Fair Master-Master with MMM manager Fair Heartbeat/SAN (depends on SAN) Excellent Heartbeat/DRBD Good NDB Cluster Excellent 5. For what…

Comment: Finding your MySQL High-Availability solution – The questions

… given. Certainly, having shared disk becomes an issue, so the Heartbeat/SAN method becomes problematic. Simple MySQL replication should still work, though…

Comment: Finding your MySQL High-Availability solution – The questions

… cause of downtime for most sites. Solutions like DRBD or SAN that implement shared disk semantics don’t support it especially… a factor of your database, your admin procedures (e.g., heartbeat w/ VIP for failover vs. manual procedure with application reconfiguration…, your data are inaccessible with no easy fall-back solution. SANs fail in some strange and scary ways. They are also…