mysql-mmm叢集（多例項）薦

navyaijm2012發表於2013-06-29

一、需求說明

最近一直在學習mysql-mmm，想以後這個架構也能用在我們公司的業務上，我們公司的業務是單機多例項部署，所以也想把mysql-mmm部署成這樣，功夫不負有心人，我成功了，和大家分享一下：

二、環境說明

叢集	角色	主機名	IP	Mysql Port	Server ID	VIP Writer	VIP READER
navy2	Agent	db1	172.28.26.101	3307	11	172.28.26.107
navy3	Agent	db2	172.28.26.102	3308	1		172.28.26.110
navy2	Agent	db1	172.28.26.101	3307	22		172.28.26.108
navy3	Agent	db2	172.28.26.102	3308	2	172.28.26.109
navy2/navy3	Monitor	Monitor	172.28.26.103

PS：db1和db2上分別有兩個庫navy2和navy3，互為主主，172.28.26.107是navy2的寫入虛擬IP，172.28.26.108是navy2的讀虛擬IP，172.28.26.109是navy2的寫入虛擬IP，172.28.26.110是navy3的讀虛擬IP。

三、部署

1、mysql和mysql-mmm的安裝及mysql的主從配置請檢視前面的博文：http://navyaijm.blog.51cto.com/4647068/1230674，這裡只介紹mmm多例項配置。

2、db1上：

vi /etc/mysql-mmm/mmm_common_navy2.conf（navy2的配置檔案）

vi /etc/mysql-mmm/mmm_common_navy2.conf
active_master_role      writer
<host default>
cluster_interface       eth1
agent_port              9912
mysql_port              3307
pid_path                /var/run/mysql-mmm/mmm_agentd_navy2.pid
bin_path                /usr/libexec/mysql-mmm/
replication_user        slave
replication_password    123456
agent_user              mmm_agent
agent_password          123456
</host>
<host db1>
ip      172.28.26.101
mysql_port              3307
mode    master
peer    db2
</host>
<host db2>
ip      172.28.26.102
mysql_port              3307
mode    master
peer    db1
</host>
<role writer>
hosts   db1, db2
ips     172.28.26.107
mode    exclusive
</role>
<role reader>
hosts   db1, db2
ips     172.28.26.108
mode    balanced
</role>

vi /etc/mysql-mmm/mmm_common_navy3.conf（navy3的配置檔案）

active_master_role      writer
<host default>
cluster_interface       eth1
agent_port              9913
mysql_port              3308
pid_path                /var/run/mysql-mmm/mmm_agentd_navy3.pid
bin_path                /usr/libexec/mysql-mmm/
replication_user        slave
replication_password    123456
agent_user              mmm_agent
agent_password          123456
</host>
<host db1>
ip      172.28.26.101
mysql_port              3308
mode    master
peer    db2
</host>
<host db2>
ip      172.28.26.102
mysql_port              3308
mode    master
peer    db1
</host>
<role writer>
hosts   db1, db2
ips     172.28.26.109
mode    exclusive
</role>
<role reader>
hosts   db1, db2
ips     172.28.26.110
mode    balanced
</role>

vi /etc/mysql-mmm/mmm_agent_navy2.conf（navy2的agent配置檔案）

include mmm_common_navy2.conf
this db1

vi /etc/mysql-mmm/mmm_agent_navy3.conf（navy3的agent配置檔案）

include mmm_common_navy3.conf
this 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`
#-----------------------------------------------------------------------
# Paths
if [ "$CLUSTER" != "" ]; then
MMMD_AGENT_BIN="/usr/sbin/mmm_agentd @$CLUSTER"
MMMD_AGENT_PIDFILE="/var/run/mysql-mmm/mmm_agentd_$CLUSTER.pid"
else
MMMD_AGENT_BIN="/usr/sbin/mmm_agentd"
MMMD_AGENT_PIDFILE="/var/run/mysql-mmm/mmm_agentd.pid"
fi
start() {
if [ "${ENABLED}" != "1" ]; then
echo "$prog is disabled!"
exit 1
fi
echo -n "Starting $prog: "
if [ -s $MMMD_AGENT_PIDFILE ] && kill -0 `cat $MMMD_AGENT_PIDFILE` 2> /dev/null; then
echo " already running."
exit 0
fi
daemon $MMMD_AGENT_BIN
RETVAL=$?
echo
[ $RETVAL = 0 ] && touch $LOCKFILE
return $RETVAL
}
stop() {
# Stop daemon.
echo -n "Stopping $prog: "
killproc -p $MMMD_AGENT_PIDFILE $MMMD_AGENT_BIN
RETVAL=$?
echo
[ $RETVAL = 0 ] && rm -f $LOCKFILE
return $RETVAL
}
case "$1" in
start)
start
;;
stop)
stop
;;
status)
status -p $MMMD_AGENT_PIDFILE $MMMD_AGENT_BIN
RETVAL=$?
;;
restart|reload)
stop
start
;;
condrestart)
if [ -f $LOCKFILE ]; then
stop
start
fi
;;
*)
echo "Usage: $0 {start|stop|restart|condrestart|status}"
;;
esac
exit $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`
#-----------------------------------------------------------------------
# Paths
if [ "$CLUSTER" != "" ]; then
MMMD_AGENT_BIN="/usr/sbin/mmm_agentd @$CLUSTER"
MMMD_AGENT_PIDFILE="/var/run/mysql-mmm/mmm_agentd_$CLUSTER.pid"
else
MMMD_AGENT_BIN="/usr/sbin/mmm_agentd"
MMMD_AGENT_PIDFILE="/var/run/mysql-mmm/mmm_agentd.pid"
fi
start() {
if [ "${ENABLED}" != "1" ]; then
echo "$prog is disabled!"
exit 1
fi
echo -n "Starting $prog: "
if [ -s $MMMD_AGENT_PIDFILE ] && kill -0 `cat $MMMD_AGENT_PIDFILE` 2> /dev/null; then
echo " already running."
exit 0
fi
daemon $MMMD_AGENT_BIN
RETVAL=$?
echo
[ $RETVAL = 0 ] && touch $LOCKFILE
return $RETVAL
}
stop() {
# Stop daemon.
echo -n "Stopping $prog: "
killproc -p $MMMD_AGENT_PIDFILE $MMMD_AGENT_BIN
RETVAL=$?
echo
[ $RETVAL = 0 ] && rm -f $LOCKFILE
return $RETVAL
}
case "$1" in
start)
start
;;
stop)
stop
;;
status)
status -p $MMMD_AGENT_PIDFILE $MMMD_AGENT_BIN
RETVAL=$?
;;
restart|reload)
stop
start
;;
condrestart)
if [ -f $LOCKFILE ]; then
stop
start
fi
;;
*)
echo "Usage: $0 {start|stop|restart|condrestart|status}"
;;
esac
exit $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上的檔案到相應的目錄下：

scp /etc/mysql-mmm/mmm_common_navy2.conf 172.28.26.102:/etc/mysql-mmm/
scp /etc/mysql-mmm/mmm_common_navy3.conf 172.28.26.102:/etc/mysql-mmm/
scp /etc/mysql-mmm/mmm_agent_navy2.conf 172.28.26.102:/etc/mysql-mmm/
scp /etc/mysql-mmm/mmm_agent_navy3.conf 172.28.26.102:/etc/mysql-mmm/
scp /etc/init.d/mysql-mmm-agent-navy2 172.28.26.102:/etc/init.d/
scp /etc/init.d/mysql-mmm-agent-navy3 172.28.26.102:/etc/init.d/

修改agent配置檔案：

sed -i `s/this db1/this db2/` /etc/mysql-mmm/mmm_agent_navy2.conf
sed -i `s/this db1/this db2/` /etc/mysql-mmm/mmm_agent_navy3.conf

賦予可執行許可權：

chmod +x /etc/init.d/mysql-mmm-agent-navy2
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

4、monitor上

複製db1上的配置檔案：

scp /etc/mysql-mmm/mmm_common_navy2.conf 172.28.26.103:/etc/mysql-mmm/
scp /etc/mysql-mmm/mmm_common_navy3.conf 172.28.26.103:/etc/mysql-mmm/

vi /etc/mysql-mmm/mmm_mon_navy2.conf

include mmm_common_navy2.conf
<monitor>
ip                  127.0.0.1
port                9992
pid_path            /var/run/mysql-mmm/mmm_mond_navy2.pid
bin_path            /usr/libexec/mysql-mmm
status_path         /var/lib/mysql-mmm/mmm_mond_navy2.status
ping_ips            172.28.26.101,172.28.26.102
auto_set_online     10
# wait_for_other_master 2
# The kill_host_bin does not exist by default, though the monitor will
# throw a warning about it missing.  See the section 5.10 "Kill Host
# Functionality" in the PDF documentation.
#
# kill_host_bin     /usr/libexec/mysql-mmm/monitor/kill_host
#
</monitor>
<host default>
monitor_user        mmm_monitor
monitor_password    123456
</host>
debug 0

vi /etc/mysql-mmm/mmm_mon_navy3.conf

include mmm_common_navy3.conf
<monitor>
ip                  127.0.0.1
port                9993
pid_path            /var/run/mysql-mmm/mmm_mond_navy3.pid
bin_path            /usr/libexec/mysql-mmm
status_path         /var/lib/mysql-mmm/mmm_mond_navy3.status
ping_ips            172.28.26.101,172.28.26.102
auto_set_online     10
# wait_for_other_master 2
# The kill_host_bin does not exist by default, though the monitor will
# throw a warning about it missing.  See the section 5.10 "Kill Host
# Functionality" in the PDF documentation.
#
# kill_host_bin     /usr/libexec/mysql-mmm/monitor/kill_host
#
</monitor>
<host default>
monitor_user        mmm_monitor
monitor_password    123456
</host>
debug 0

vi /etc/mysql-mmm/mmm_mon_log_navy2.conf

#log4perl.logger = FATAL, MMMLog, MailFatal
log4perl.logger = FATAL, MMMLog
log4perl.appender.MMMLog = Log::Log4perl::Appender::File
log4perl.appender.MMMLog.Threshold = INFO
log4perl.appender.MMMLog.filename = /var/log/mysql-mmm/mmm_mond_navy2.log
log4perl.appender.MMMLog.recreate = 1
log4perl.appender.MMMLog.layout = PatternLayout
log4perl.appender.MMMLog.layout.ConversionPattern = %d %5p %m%n
#log4perl.appender.MailFatal = Log::Dispatch::Email::MailSender
#log4perl.appender.MailFatal.Threshold = FATAL
#log4perl.appender.MailFatal.from = mmm@example.com
#log4perl.appender.MailFatal.to = root
#log4perl.appender.MailFatal.buffered = 0
#log4perl.appender.MailFatal.subject = FATAL error in mysql-mmm-monitor
#log4perl.appender.MailFatal.layout = PatternLayout
#log4perl.appender.MailFatal.layout.ConversionPattern = %d %m%n

vi /etc/mysql-mmm/mmm_mon_log_navy3.conf

#log4perl.logger = FATAL, MMMLog, MailFatal
log4perl.logger = FATAL, MMMLog
log4perl.appender.MMMLog = Log::Log4perl::Appender::File
log4perl.appender.MMMLog.Threshold = INFO
log4perl.appender.MMMLog.filename = /var/log/mysql-mmm/mmm_mond_navy3.log
log4perl.appender.MMMLog.recreate = 1
log4perl.appender.MMMLog.layout = PatternLayout
log4perl.appender.MMMLog.layout.ConversionPattern = %d %5p %m%n
#log4perl.appender.MailFatal = Log::Dispatch::Email::MailSender
#log4perl.appender.MailFatal.Threshold = FATAL
#log4perl.appender.MailFatal.from = mmm@example.com
#log4perl.appender.MailFatal.to = root
#log4perl.appender.MailFatal.buffered = 0
#log4perl.appender.MailFatal.subject = FATAL error in mysql-mmm-monitor
#log4perl.appender.MailFatal.layout = PatternLayout
#log4perl.appender.MailFatal.layout.ConversionPattern = %d %m%n

vi /etc/init.d/mysql-mmm-monitor-navy2

#!/bin/sh
#
# mysql-mmm-monitor  This shell script takes care of starting and stopping
#                    the mmm monitoring daemon.
#
# chkconfig: - 64 36
# description:  MMM Monitor.
# processname: mmm_mond
# config: /etc/mysql-mmm/mmm_mon.conf
# pidfile: /var/run/mysql-mmm/mmm_mond.pid
# Source function library and defaults file.
. /etc/rc.d/init.d/functions
. /etc/default/mysql-mmm-monitor
# Cluster name (it can be empty for default cases)
CLUSTER=`navy2`
LOCKFILE=`/var/lock/subsys/mysql-mmm-monitor_navy2`
prog=`MMM Monitor Daemon`
if [ "$CLUSTER" != "" ]; then
MMMD_MON_BIN="/usr/sbin/mmm_mond @$CLUSTER"
MMMD_MON_PIDFILE="/var/run/mysql-mmm/mmm_mond-$CLUSTER.pid"
else
MMMD_MON_BIN="/usr/sbin/mmm_mond"
MMMD_MON_PIDFILE="/var/run/mysql-mmm/mmm_mond.pid"
fi
start() {
if [ "${ENABLED}" != "1" ]; then
echo "$prog is disabled!"
exit 1
fi
echo -n "Starting $prog: "
if [ -s $MMMD_MON_PIDFILE ] && kill -0 `cat $MMMD_MON_PIDFILE` 2> /dev/null; then
echo " already running."
exit 0
fi
daemon $MMMD_MON_BIN
RETVAL=$?
echo
[ $RETVAL = 0 ] && touch $LOCKFILE
return $RETVAL
}
stop() {
# Stop daemon.
echo -n "Stopping $prog: "
killproc -p $MMMD_MON_PIDFILE $MMMD_MON_BIN
RETVAL=$?
echo
[ $RETVAL = 0 ] && rm -f $LOCKFILE
return $RETVAL
}
case "$1" in
start)
start
;;
stop)
stop
;;
status)
status -p $MMMD_MON_PIDFILE $MMMD_MON_BIN
RETVAL=$?
;;
restart|reload)
stop
start
;;
condrestart)
if [ -f $LOCKFILE ]; then
stop
start
fi
;;
*)
echo "Usage: $0 {start|stop|restart|condrestart|status}"
;;
esac
exit $RETVAL

vi /etc/init.d/mysql-mmm-monitor-navy3

#!/bin/sh
#
# mysql-mmm-monitor  This shell script takes care of starting and stopping
#                    the mmm monitoring daemon.
#
# chkconfig: - 64 36
# description:  MMM Monitor.
# processname: mmm_mond
# config: /etc/mysql-mmm/mmm_mon.conf
# pidfile: /var/run/mysql-mmm/mmm_mond.pid
# Source function library and defaults file.
. /etc/rc.d/init.d/functions
. /etc/default/mysql-mmm-monitor
# Cluster name (it can be empty for default cases)
CLUSTER=`navy3`
LOCKFILE=`/var/lock/subsys/mysql-mmm-monitor_navy3`
prog=`MMM Monitor Daemon`
if [ "$CLUSTER" != "" ]; then
MMMD_MON_BIN="/usr/sbin/mmm_mond @$CLUSTER"
MMMD_MON_PIDFILE="/var/run/mysql-mmm/mmm_mond-$CLUSTER.pid"
else
MMMD_MON_BIN="/usr/sbin/mmm_mond"
MMMD_MON_PIDFILE="/var/run/mysql-mmm/mmm_mond.pid"
fi
start() {
if [ "${ENABLED}" != "1" ]; then
echo "$prog is disabled!"
exit 1
fi
echo -n "Starting $prog: "
if [ -s $MMMD_MON_PIDFILE ] && kill -0 `cat $MMMD_MON_PIDFILE` 2> /dev/null; then
echo " already running."
exit 0
fi
daemon $MMMD_MON_BIN
RETVAL=$?
echo
[ $RETVAL = 0 ] && touch $LOCKFILE
return $RETVAL
}
stop() {
# Stop daemon.
echo -n "Stopping $prog: "
killproc -p $MMMD_MON_PIDFILE $MMMD_MON_BIN
RETVAL=$?
echo
[ $RETVAL = 0 ] && rm -f $LOCKFILE
return $RETVAL
}
case "$1" in
start)
start
;;
stop)
stop
;;
status)
status -p $MMMD_MON_PIDFILE $MMMD_MON_BIN
RETVAL=$?
;;
restart|reload)
stop
start
;;
condrestart)
if [ -f $LOCKFILE ]; then
stop
start
fi
;;
*)
echo "Usage: $0 {start|stop|restart|condrestart|status}"
;;
esac
exit $RETVAL

賦予可執行許可權：

chmod +x /etc/init.d/mysql-mmm-monitor-navy2
chmod +x /etc/init.d/mysql-mmm-monitor-navy3

啟動監控服務：

/etc/init.d/mysql-mmm-monitor-navy2 start
/etc/init.d/mysql-mmm-monitor-navy3 start

結果：

[root@monitor ~]# mmm_control  show
db1(172.28.26.101) master/ONLINE. Roles: writer(172.28.26.104)
db2(172.28.26.102) master/ONLINE. Roles:
db3(172.28.26.188) slave/ONLINE. Roles: reader(172.28.26.105)
db4(172.28.26.189) slave/ONLINE. Roles: reader(172.28.26.106)
[root@monitor ~]# mmm_control @navy2 show
db1(172.28.26.101) master/ONLINE. Roles: writer(172.28.26.107)
db2(172.28.26.102) master/ONLINE. Roles: reader(172.28.26.108)
[root@monitor ~]# mmm_control @navy3 show
db1(172.28.26.101) master/ONLINE. Roles: writer(172.28.26.109)
db2(172.28.26.102) master/ONLINE. Roles: reader(172.28.26.110)
[root@monitor ~]#

rabbitmq單機多例項叢集與負載均衡
2014-02-17
MQ負載
在oracle 叢集多例項中執行並行操作
2011-10-24
Oracle並行
redis多例項重啟指令碼薦
2014-01-14
Redis指令碼
#Tomcat學習(3)#Tomcat多例項配置和反向代理叢集配置
2020-10-22
Tomcat
Zookeeper叢集 + Kafka叢集 + KafkaOffsetMonitor 監控薦
2017-04-22
Kafka
mysql系列之多例項3—-基於mysqld_multi薦
2014-07-23
MySql
mysql多例項部署
2014-11-10
MySql
MySQL多例項配置
2024-03-26
MySql
flutter 多例項實戰
2019-02-21
Flutter
mysql多例項安裝
2019-07-31
MySql
MySQL5.7 多例項
2018-05-25
MySql
MySQL多例項環境部署
2018-04-22
MySql
mysql的多例項配置
2015-08-17
MySql
叢集的應用例項(zt)
2007-10-24
MySQL 多例項配置管理：
2020-03-10
MySql
mysql 5.7 多例項安裝
2017-03-03
MySql
MySQL單機多例項配置
2012-10-27
MySql
多例項資料庫刪除例項
2009-05-03
資料庫
Zookeeper叢集 + Kafka叢集
2024-07-18
Kafka
Android Flutter 多例項實踐
2021-07-23
AndroidFlutter
MySQL 多例項刪庫指令碼
2014-04-02
MySql指令碼
Mysql之多例項my.cnf
2016-02-15
MySql
spring整合quartz的叢集配置例項
2016-06-27
Springquartz
ceph 叢集報 mds cluster is degraded 故障排查薦
2017-05-08
“大資料”時代叢集NAS更給力薦
2011-04-25
大資料
搭建zookeeper叢集（偽叢集）
2020-11-22
web叢集與ejb叢集
2009-03-08
Web
MySQL 多例項資料庫還原指令碼-備份集與埠對應
2014-04-01
MySql資料庫指令碼
如何將獨立例項轉換成叢集例項EU
2022-03-21
canal同步mysql，監聽單例項，多例項配置
2024-08-21
MySql單例
MySQL入門--Mysqld_multi多例項
2017-01-21
MySql
oracle多例項start-stop指令碼
2013-11-14
Oracle指令碼
zookeeper叢集及kafka叢集搭建
2021-06-28
Kafka
CoroSync + Drbd + MySQL 實現MySQL的高可用叢集薦
2014-07-09
ROSMySql
叢集例項：配置ISCSI客戶端(LINUX)
2013-11-27
客戶端Linux
redis偽叢集配置Cluster叢集模式
2019-04-09
Redis模式
Redis系列：搭建Redis叢集(叢集模式)
2020-09-23
Redis模式
Redis叢集 - cluster叢集、資料分片
2017-04-25
Redis

mysql-mmm叢集（多例項）薦

相關文章