一、需求说明最近一直在学习mysql-mmm，想以后这个架构也能用在我们公司的业务上，我们公司的业务是单机多实例部署，所以也想把mysql-mmm部署成这样，功夫不负有
三、部署
1、mysql和mysql-mmm的安装及mysql的主从配置请查看前面的博文：，美国空间，网站空间，这里只介绍mmm多实例配置。
2、db1上：
vi /etc/mysql-mmm/mmm_common_navy2.conf（navy2的配置文件）
vi /etc/mysql-mmm/mmm_common_navy2.confactive_master_rolewritercluster_interfaceeth1agent_port9912mysql_port3307pid_path/var/run/mysql-mmm/mmm_agentd_navy2.pidbin_path/usr/libexec/mysql-mmm/replication_userslavereplication_password 123456agent_usermmm_agentagent_password123456ip172.28.26.101mysql_port3307mode masterpeer db2ip172.28.26.102mysql_port3307mode masterpeer db1hosts db1, db2ips172.28.26.107mode exclusivehosts db1, db2ips172.28.26.108mode balanced
vi /etc/mysql-mmm/mmm_common_navy3.conf（navy3的配置文件）
active_master_rolewritercluster_interfaceeth1agent_port9913mysql_port3308pid_path/var/run/mysql-mmm/mmm_agentd_navy3.pidbin_path/usr/libexec/mysql-mmm/replication_userslavereplication_password 123456agent_usermmm_agentagent_password123456ip172.28.26.101mysql_port3308mode masterpeer db2ip172.28.26.102mysql_port3308mode masterpeer db1hosts db1, db2ips172.28.26.109mode exclusivehosts db1, db2ips172.28.26.110mode balanced
vi /etc/mysql-mmm/mmm_agent_navy2.conf（navy2的agent配置文件）
include mmm_common_navy2.confthis db1
vi /etc/mysql-mmm/mmm_agent_navy3.conf（navy3的agent配置文件）
include mmm_common_navy3.confthis db1
vi /etc/init.d/mysql-mmm-agent-navy2（navy2的agent启动脚本）
#!/bin/sh# chkconfig: – 64 36# description: MMM Agent.# processname: mmm_agentd# config: /etc/mysql-mmm/mmm_agent.conf# pidfile: /var/run/mysql-mmm/mmm_agentd.pid# Source function library and defaults file.. /etc/rc.d/init.d/functions. /etc/default/mysql-mmm-agent# Cluster name (it can be empty for default cases)CLUSTER=’navy2’LOCKFILE=’/var/lock/subsys/mysql-mmm-agent_navy2’prog=’MMM Agent Daemon’#———————————————————————–# Pathsif [ “$CLUSTER” != “” ]; thenMMMD_AGENT_BIN=”/usr/sbin/mmm_agentd @$CLUSTER”MMMD_AGENT_PIDFILE=”/var/run/mysql-mmm/mmm_agentd_$CLUSTER.pid”elseMMMD_AGENT_BIN=”/usr/sbin/mmm_agentd”MMMD_AGENT_PIDFILE=”/var/run/mysql-mmm/mmm_agentd.pid”fistart() {if [ “${ENABLED}” != “1” ]; thenecho “$prog is disabled!”exit 1fiecho -n “Starting $prog: “if [ -s $MMMD_AGENT_PIDFILE ] && kill -0 `cat $MMMD_AGENT_PIDFILE` 2> /dev/null; thenecho ” already running.”exit 0fidaemon $MMMD_AGENT_BINRETVAL=$?echo[ $RETVAL = 0 ] && touch $LOCKFILEreturn $RETVAL}stop() {# Stop daemon.echo -n “Stopping $prog: “killproc -p $MMMD_AGENT_PIDFILE $MMMD_AGENT_BINRETVAL=$?echo[ $RETVAL = 0 ] && rm -f $LOCKFILEreturn $RETVAL}case “$1” instart)start;;stop)stop;;status)status -p $MMMD_AGENT_PIDFILE $MMMD_AGENT_BINRETVAL=$?;;restart|reload)stopstart;;condrestart)if [ -f $LOCKFILE ]; thenstopstartfi;;*)echo “Usage: $0 {start|stop|restart|condrestart|status}”;;esacexit $RETVAL
赋予执行权限：
chmod +x /etc/init.d/mysql-mmm-agent-navy2
vi /etc/init.d/mysql-mmm-agent-navy3（navy3的agent启动脚本）
#!/bin/sh# chkconfig: – 64 36# description: MMM Agent.# processname: mmm_agentd# config: /etc/mysql-mmm/mmm_agent.conf# pidfile: /var/run/mysql-mmm/mmm_agentd.pid# Source function library and defaults file.. /etc/rc.d/init.d/functions. /etc/default/mysql-mmm-agent## Paths#MMMD_AGENT_BIN=”/usr/sbin/mmm_agentd”#MMMD_AGENT_PIDFILE=”/var/run/mysql-mmm/mmm_agentd.pid”#LOCKFILE=’/var/lock/subsys/mysql-mmm-agent’#prog=’MMM Agent Daemon’# Cluster name (it can be empty for default cases)CLUSTER=’navy3’LOCKFILE=’/var/lock/subsys/mysql-mmm-agent_navy3’prog=’MMM Agent Daemon’#———————————————————————–# Pathsif [ “$CLUSTER” != “” ]; thenMMMD_AGENT_BIN=”/usr/sbin/mmm_agentd @$CLUSTER”MMMD_AGENT_PIDFILE=”/var/run/mysql-mmm/mmm_agentd_$CLUSTER.pid”elseMMMD_AGENT_BIN=”/usr/sbin/mmm_agentd”MMMD_AGENT_PIDFILE=”/var/run/mysql-mmm/mmm_agentd.pid”fistart() {if [ “${ENABLED}” != “1” ]; thenecho “$prog is disabled!”exit 1fiecho -n “Starting $prog: “if [ -s $MMMD_AGENT_PIDFILE ] && kill -0 `cat $MMMD_AGENT_PIDFILE` 2> /dev/null; thenecho ” already running.”exit 0fidaemon $MMMD_AGENT_BINRETVAL=$?echo[ $RETVAL = 0 ] && touch $LOCKFILEreturn $RETVAL}stop() {# Stop daemon.echo -n “Stopping $prog: “killproc -p $MMMD_AGENT_PIDFILE $MMMD_AGENT_BINRETVAL=$?echo[ $RETVAL = 0 ] && rm -f $LOCKFILEreturn $RETVAL}case “$1” instart)start;;stop)stop;;status)status -p $MMMD_AGENT_PIDFILE $MMMD_AGENT_BINRETVAL=$?;;restart|reload)stopstart;;condrestart)if [ -f $LOCKFILE ]; thenstopstartfi;;*)echo “Usage: $0 {start|stop|restart|condrestart|status}”;;esacexit $RETVAL
赋予可执行权限：
chmod +x /etc/init.d/mysql-mmm-agent-navy3
启动服务：
/etc/init.d/mysql-mmm-agent-navy2 start/etc/init.d/mysql-mmm-agent-navy3 start
3、db2上：
复制db1上的文件到相应的目录下：
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至253000106@qq.com举报，一经查实，本站将立刻删除。
发布者：PHP中文网，转转请注明出处：https://www.chuangxiangniao.com/p/1854381.html
