InstallMysqlMHAOnRedhat6.3 - 数据库编程

mpleted. Wed Feb 11 02:16:53 2015 - [info] Wed Feb 11 02:16:53 2015 - [info] * Phase 4: Slaves Recovery Phase.. Wed Feb 11 02:16:53 2015 - [info] Wed Feb 11 02:16:53 2015 - [info] * Phase 4.1: Starting Parallel Slave Diff Log Generation Phase.. Wed Feb 11 02:16:53 2015 - [info] Wed Feb 11 02:16:53 2015 - [info] Generating relay diff files from the latest slave succeeded. Wed Feb 11 02:16:53 2015 - [info] Wed Feb 11 02:16:53 2015 - [info] * Phase 4.2: Starting Parallel Slave Log Apply Phase.. Wed Feb 11 02:16:53 2015 - [info] Wed Feb 11 02:16:53 2015 - [info] All new slave servers recovered successfully. Wed Feb 11 02:16:53 2015 - [info] Wed Feb 11 02:16:53 2015 - [info] * Phase 5: New master cleanup phase.. Wed Feb 11 02:16:53 2015 - [info] Wed Feb 11 02:16:53 2015 - [info] Resetting slave info on the new master.. Wed Feb 11 02:16:53 2015 - [info] 192.168.56.162: Resetting slave info succeeded. Wed Feb 11 02:16:53 2015 - [info] Master failover to 192.168.56.162(192.168.56.162:3306) completed successfully. Wed Feb 11 02:16:53 2015 - [info] ----- Failover Report ----- app1: MySQL Master failover 192.168.56.161(192.168.56.161:3306) to 192.168.56.162(192.168.56.162:3306) succeeded Master 192.168.56.161(192.168.56.161:3306) is down! Check MHA Manager logs at zbdba1:/masterha/app1/manager.log for details. Started automated(non-interactive) failover. The latest slave 192.168.56.162(192.168.56.162:3306) has all relay logs for recovery. Selected 192.168.56.162(192.168.56.162:3306) as a new master. 192.168.56.162(192.168.56.162:3306): OK: Applying all logs succeeded. Generating relay diff files from the latest slave succeeded. 192.168.56.162(192.168.56.162:3306): Resetting slave info succeeded. Master failover to 192.168.56.162(192.168.56.162:3306) completed successfully.
发现已经切换了。

这里只是简单演示了MHA的基本用法，可结合其他技术发挥它更大的优势。例如可以配合keepalived VIP使用，从而对应用透明。

InstallMysqlMHAOnRedhat6.3(三)