Comparison and application of mmm And MHA (PPT sharing)

Sharing topic: MySQL high-availability architecture --- MMM & MHA application and improvement in public comments

Introduction: This speech focuses on the following aspects:

1. How does MMM use the spot evaluation network?

2. How to fill in the pitfalls on MMM

3. Selection between MMM And MHA

PPT download link: Http://pan.baidu.com/s/1mg3G2MW

Conference link: Http://meeting.zhdba.com/2014dtcc

 

 

Here are some outlines:

• Why we need a HA solution

• MMM in DP

• MHA in DP

When We Need to Switch Server

 

• Master Server down

• Master Server maintenance

• Logical: DDL on big table

• Physical: memory replacement

Failover without tool:

• Notify DBA for MySQL Failure

• Kill old Master

• Find the latest Slave as Master Candidate

• Execute change Master to on each Slave

• Direct APP to new Master IP & restart