从零开始部署MHA以及相关MHA原始脚本定制

从零开始部署MHA以及相关MHA原始脚本定制

近期公司要做mysql数据库的高可用，通过前期调研了主从+heartbeat，MHA，PXC三个类型的方案，也结合了当前公司的技术能力和业务情况吗，最终是选择了MHA来作为高可用的方案。

MHA的介绍

直接借用MHA作者Yoshinori Matsunobu的github的介绍就不自己描述了，Yoshinori Matsunobu是个大神 现在在Facebook。

MHA performs automating master failover and slave promotion with minimal downtime, usually within 10-30 seconds. MHA prevents replication consistency problems and saves on expenses of having to acquire additional servers. All this with zero performance degradation, no complexity (easy-to-install) and requiring no change to existing deployments.

MHA also provides scheduled online master switching