MySQL高可用性介绍.pdfVIP

MySQL High Availability MMM MHA in DP 卢钧轶 Agenda ● 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 Why We Need A Failover Solution 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 Difficu