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

The source of the mmm architecture is well known. MySQL itself provides master-slave replication, and then you can easily implement two-way master-master replication, while building a Slave library for one of the Master nodes. This implements the foundation of the MySQL-MMM architecture: bidirectional replication between master1 and master2, and master-slave replication between Master1 and Slave1. In this way, there are two Master in the whole system, and under normal circumstances, only one master provides writing services. If the master providing services goes down unexpectedly, the MySQL itself does not have the ability to switch between failover. Although there is still a normal master node in the cluster, the application is still not available. Mysql-mmm was born to solve this problem. The principle of mmm architecture MySQL-MMM is the abbreviation of Master-Master Replication Manager for MySQL (mysql Master Master replication Manager), which is an open source project of Google (Perl script). It is mainly used to monitor mysql master replication and fail over. The principle is to map the IP (RIP) of real database nodes to virtual IP (VIP) sets. In this virtual IP set, there is an IP dedicated to write and multiple IP for read. This VIP for Write maps the real IP (RIP) of the two master in the database cluster to switch between Failover, and the VIP of other read can be used to balance. Advantages and disadvantages of mmm organization using Perl scripting language development and completely open source to provide read-write VIP (virtual IP) Make the role change of the server transparent to the front-end application MMM provides delayed monitoring of the slave server MMM provides the resynchronization function of the slave server to the new master after the master database failover it is easy to resynchronize the failed master database the release time is relatively early does not support MySQL new replication function (GTID-based replication) no read load balancing function during master-slave switchover Easy to cause data loss MMM monitoring service has a single point of failure mmm architecture schematic 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.