You're at: Home » Browse » Conferences » Froscon » 2010 » Keep your MySQL backend online no matter what

Keep your MySQL backend online no matter what

How to build a multilevel mysql backend to stay online at all the time with MySQL, LVS and MMM



I helped architect and build a system to get 4 nines (99.99) availability for the mysql backend behind a website. It used mysql replication to set up a multi-master environment, MMM to manage it and LVS for mysql backend loadbalancing. This architecture not only provided high availability, but also permitted us to change the schema, upgrade MySQL versions, or even replace hardware without any downtime. This presentation explains how this solution worked.

Persons:
  • Istvan Podor