from http://bbs.chinaunix.net/thread-3769165-1-1.html
Recently took some time to study the high availability of MySQL, summed up as a document, hoping to beginner this helps. Lvs+keepalived+MySQL single-point write Master Sync High-availability scenario http://blog.chinaunix.net/uid-20639775-id-3337448.htmlLvs+keepalived+MySQL Single-point write read load balancer primary master synchronization High-availability scenario http://blog.chinaunix.net/uid-20639775-id-3337471.htmlHeartbeat high-availability MySQL Master synchronization scheme http://blog.chinaunix.net/uid-20639775-id-3337481.htmlHeartbeat+drbd+MySQL High-availability scenario http://blog.chinaunix.net/uid-20639775-id-3337484.htmlmmm high availability MySQL solution http://blog.chinaunix.net/uid-20639775-id-3337488.htmlfor everyone's learning, I've compiled the document into PDF format, which you can download in the following link: http://blog.chinaunix.net/space.php?uid=20639775&do=blog&id=3337509
Cond...
Explore MySQL high-availability scenarios