Microsoft Azure Deployment Mysql-mmm (3) configuration mysql-mmm

(3) installation configuration mysql-mmm

The Perl module (all servers) required to install MMM in DB1, DB2, DB3 executes the script, and then yum-y install mysql-mmm-agent to mount MMM:

# RPM-IVH http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

# yum-y Install Mysql-mmm-agent

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5D/18/wKiom1UhbYiBwOQeAARKMgACSs4736.jpg "/>

in the Monitor node installation mysql-mmm-monitor

# yum-y Install mysql-mmm-monitor*

# yum-y Install perl-time-hires*

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5D/18/wKiom1UhbYmgyhirAAmQoB6l6eM697.jpg "/>

compiling mmm_common.conf configuration Agent on DB1:

# sudo vim/etc/mysql-mmm/mmm_common.conf

Active_master_role writer

Cluster_interface eth0

Pid_path/var/run/mysql-mmm/mmm_agentd.pid

bin_path/usr/libexec/mysql-mmm/

Replication_user replication

Replication_password replication

Agent_user mmm_agent

Agent_password Agent

IP 10.0.0.4

Mode Master

Peer DB2

IP 10.0.0.5

Mode Master

Peer DB1

IP 10.0.0.7

mode slave

<role writer>

Hosts DB1, DB2

IPs 10.0.0.100

Mode Exclusive

</role>

<role reader>

Hosts DB2, DB3

IPs 10.0.0.80, 10.0.0.90

Mode Balanced

where Replication_user is used to check the replication user, agent_user is the agent user, mode indicates whether the primary or alternate master, or from the library. mode exclusive Master for exclusive mode, only one master at a time, <role write> hosts represents the current main library and the host IP of the alternate master or host name, IPs is the virtual machine IP address provided externally ,<role readr> hosts represent the real from the library IP and host name, IPs represents the virtual IP address from the library .

After the compilation is completed, it is replicated to the DB2, DB3, and monitor nodes via SCP:

# scp/etc/mysql-mmm/mmm_common.conf 10.0.0.5:/etc/mysql-mmm/

# scp/etc/mysql-mmm/mmm_common.conf 10.0.0.7:/etc/mysql-mmm/

# scp/etc/mysql-mmm/mmm_common.conf 10.0.0.6:/etc/mysql-mmm/

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5D/13/wKioL1Uhbs2iB2hNAAB45KIZ6og815.jpg "/>

/etc/mysql-mmm configuration mmm_agent.conf files in db1,DB2,DB3 and three hosts respectively , Each with a different character identification, note that this db1 three machine this piece to think, for example, in this environment,DB1 To configure this db1,DB2 to be configured as this DB2 , and db3 to be configured as this db3.

# sudo vim/etc/mysql-mmm/mmm_agent.conf

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5D/18/wKiom1UhbYnTVFLVAAEk57zBphU278.jpg "/>

Compile the monitor configuration file on the monitor node and add the contents of the Ping_ips

# sudo vim/etc/mysql-mmm/mmm_mon.conf

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5D/13/wKioL1Uhbs3RVtObAAM2nAMKlqs692.jpg "/>

Start Agent service in DB1, DB2, DB3

# service Mysql-mmm-agent Start

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5D/18/wKiom1UhbYmgLYlaAACEy9WTFGM822.jpg "/>

Start monitor Service in monitor

<span style= "Color:black; Font-size:10pt

This article is from "Li Xun Blog-Microsoft technology and Cloud" blog, make sure to keep this source http://lixun.blog.51cto.com/4198640/1629179

Microsoft Azure Deployment Mysql-mmm (3) configuration mysql-mmm