Linux Today: Linux News On Internet Time.

Installing and Managing Multi Master Replication Manager (MMM) for MySQL High Ava

May 07, 2010, 12:13 (0 Talkback[s])
(Other stories by Alex Davies)

[ Thanks to Ramsai for this link. ]

"In a group of MMM-managed machines, each node has a node IP, which is the normal server IP address. In addition, each node has a "read" IP and a "write" IP. Read and write IPs are moved around depending on the status of each node as detected and decided by mmmd_mon, which migrates these IP address around to ensure that the write IP address is always on an active and working master, and that all read IPs are connected to another master that is in sync (which does not have out-of-date data).

"mmmd_mon should not run on the same server as any of the databases to ensure good availability. Thus, the best practice would be to keep a minimum number of three nodes.

"In the examples of this article, we will configure two MySQL servers, node 5 and node 6 ( and 6) with a virtual writable IP of and two read-only IPs of and, using a monitoring node node 4 ( We will use RedHat / CentOS provided software where possible."

Complete Story

Related Stories: