Introduction to the MMM high availability program for MySQL

MMM (master-master Replication Manager for MySQL) MySQL Master Replication Manager provides a scalable suite of scripts for monitoring, failover, and management of MySQL master replication configuration. In the MMM high-availability solution, the typical application is a dual-master multi-Slave architecture, through the MySQL replication technology can realize two server mutual primary from, and at any time only one node can write, avoid multi-point write data conflict. At the same time, when a writable master node fails, the MMM suite can be immediately monitored, then automatically switch the service to the other master node, continue to provide services, to achieve high availability of MySQL.

The MMM high-availability MySQL program is a well-developed MySQL high-availability cluster solution written in Perl, based on MySQL master-slave replication, consisting of a management side (monitor) and multiple agent-side (agents). Through MMM, we can monitor and manage the status of MySQL master replication and service, as well as monitor the replication and operation status of multiple slave nodes, and can realize the function of automatic switching when any node fails. The advent of the MMM cluster scheme provides a good platform for MySQL's application of Read and write separation architectures, because the MMM cluster scheme extracts the read IP (reader IP) and the write IP (write IP) from the database level, and can realize the read and write separation function by simply invoking the business system.

Although MMM is a MySQL master Replication Manager, only one master is writable at the same time throughout the cluster, in order to ensure the integrity and security of the data .

MMM cluster suite has good stability, high availability and scalability, when the active master server fails, the standby master server will take over immediately, while the other slave server can automatically switch to the standby master server to continue the synchronous replication, the whole process without human intervention.

Of course, the MMM Cluster suite also has a certain disadvantage: first, the MMM architecture needs multiple nodes, multiple IPs, the number of servers have requirements; Secondly, MMM scheme is not very stable in reading and writing very busy business system, it may appear replication delay, switching failure and so on. Therefore, MMM scheme is not very suitable for the data security requirements are high, and read, write frequently in the environment .

Introduction to the MMM high availability program for MySQL