High Availability MySQL Cookbook

Managing and using Multi Master Replication Manager (MMM)

In this recipe, we will show how to take your configured MMM nodes into a working MMM cluster with monitoring and high availability, and also discuss some management tasks such as conducting planned maintenance.

This recipe assumes that the MMM agent is installed on all MySQL nodes, and that a MMM monitoring host has been installed as shown in the preceding recipe.

This recipe will make extensive use of the command mmm_control, which is used to control the hosts inside a MMM cluster.

How to do it…

Within mmm_control, a show command gives the current status of the cluster:

[root@node4 ~]# mmm_control show
  node5(10.0.0.5) master/ONLINE. Roles: reader(10.0.0.12)
 node6(10.0.0.6) master/ONLINE. ...