Shulou(Shulou.com)06/01 Report--

MHA (Master High Availability) is currently a relatively mature solution for MySQL high availability. It was developed by youshimaton, a Japanese DeNA company (now working for Facebook). It is a set of excellent high availability software for failover and master-slave upgrade in MySQL high availability environment.

Advantages:

Open source tools developed by the per language

Can support GTID-based replication mode

When the master DB is not available, a new master DB is elected from multiple slave servers

Master-slave handover and failover functions are provided, so it is not easy to lose data during online failover.

Multiple clusters can be monitored by the same monitoring node

Disadvantages:

Need to write scripts or use third-party tools to implement the configuration of VIP

After MHA starts, it only monitors the availability of the master server, not the slave server.

Need to be based on SSH authentication-free login configuration, there are some security risks

There is no read load balancing function from the server.

A brief description of the master-slave switching process:

The application saves binary logs from the original master DB server

Promote the alternate primary DB server to the new primary DB server

Migrate the other slave DB in the cluster as the slave server of the new master DB

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.