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

How to build a MySQL highly available MMM architecture? I believe that most people have not yet learned this skill, in order to let you learn, to give you a summary of the following content, do not say much, let's move on.

MMM High availability Architecture

MMM (Master-Master replication manager for MySQL) is a set of scripts that support dual-master failover and dual-master daily management. MMM is developed in the Perl language and is mainly used to monitor and manage MySQL Master-Master (dual master) replication, which can be said to be the mysql master replication manager. Although it is called dual-master replication, only one master is allowed to write at the same time in the business, and the other alternative master provides partial read service to speed up the warm-up of the alternative master at the time of master switching. It can be said that MMM script program on the one hand realizes the function of failover, on the other hand, its internal additional tool scripts can also achieve read load balancing of multiple slave. A scalable suite of scripts for monitoring, failover, and management of mysql master replication configurations (only one node can be written at any time). This suite can also load balance any number of slave servers that reside in the standard master-slave configuration, so you can use it to launch virtual ip on a group of servers that reside in replication It also has scripts that implement data backup and resynchronization between nodes.

MMM provides both automatic and manual ways to remove the virtual ip of servers with high replication latency in a group of servers. At the same time, it can also back up data and achieve data synchronization between the two nodes. Because MMM cannot completely guarantee data consistency, MMM is suitable for scenarios where data consistency is not very high, but you want to maximize business availability. MySQL itself does not provide a replication failover solution, through the MMM scheme to achieve server failover, so as to achieve the high availability of mysql. For those businesses that require high data consistency, a highly available architecture such as MMM is not recommended. MMM architecture diagram:

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.