- 论坛徽章:
- 0
|
本帖最后由 liang3391 于 2010-11-01 09:49 编辑
mysql mmm架构 3个vip 只有一个vip可以通 另外两个都不通。
M:192.168.1.250
M:192.168.1.251
192.168.1.245 192.168.1.246 192.168.1.247
monitor安装在 M:192.168.1.250 上。
M:192.168.1.250 配置如下：
[root@localhost ~]# cat /etc/mysql-mmm/mmm_common.conf
active_master_role writer
<host default>
cluster_interface eth0
pid_path /var/run/mmm_agentd.pid
bin_path /usr/lib/mysql-mmm/
replication_user replication
replication_password slave
agent_user mmm_agent
agent_password RepAgent
</host>
<host db1>
ip 192.168.1.250
mode master
peer db2
</host>
<host db2>
ip 192.168.1.251
mode master
peer db1
</host>
#<host db3>
# ip 192.168.0.33
# mode slave
#</host>
<role writer>
hosts db1, db2
ips 192.168.1.245
mode exclusive
</role>
<role reader>
hosts db1, db2
ips 192.168.1.246, 192.168.1.247
mode balanced
</role>
[root@localhost ~]#
[root@localhost ~]# cat /etc/mysql-mmm/mmm_mon.conf
include mmm_common.conf
<monitor>
ip 127.0.0.1
pid_path /var/run/mmm_mond.pid
bin_path /usr/lib/mysql-mmm/
status_path /var/lib/misc/mmm_mond.status
ping_ips 192.168.1.250, 192.168.1.251
auto_set_online 6
</monitor>
<host default>
monitor_user mmm_monitor
monitor_password RepMonitor
</host>
debug 0
[root@localhost ~]# cat /etc/mysql-mmm/mmm_agent.conf
include mmm_common.conf
this db1
M:192.168.1.251配置如下：
[root@localhost ~]# cat /etc/mysql-mmm/mmm_agent.conf
include mmm_common.conf
this db2
[root@localhost ~]# cat /etc/mysql-mmm/mmm_common.conf
active_master_role writer
<host default>
cluster_interface eth0
pid_path /var/run/mmm_agentd.pid
bin_path /usr/lib/mysql-mmm/
replication_user replication
replication_password slave
agent_user mmm_agent
agent_password RepAgent
</host>
<host db1>
ip 192.168.1.250
mode master
peer db2
</host>
<host db2>
ip 192.168.1.251
mode master
peer db1
</host>
#<host db3>
# ip 192.168.0.33
# mode slave
#</host>
<role writer>
hosts db1, db2
ips 192.168.1.245
mode exclusive
</role>
<role reader>
hosts db1, db2
ips 192.168.1,246, 192.168.1.247
mode balanced
</role>
[root@localhost ~]#
[root@localhost ~]# cat /etc/mysql-mmm/mmm_mon.conf
include mmm_common.conf
<monitor>
ip 127.0.0.1
pid_path /var/run/mmm_mond.pid
bin_path /usr/lib/mysql-mmm/
status_path /var/lib/misc/mmm_mond.status
ping_ips 192.168.1.250, 192.168.1.251
</monitor>
<host default>
monitor_user mmm_monitor
monitor_password RepMonitor
</host>
debug 0
[root@localhost ~]# mmm_control show
db1(192.168.1.250) master/ONLINE. Roles: reader(192.168.1.247)
db2(192.168.1.251) master/ONLINE. Roles: reader(192.168.1.246), writer(192.168.1.245)
[root@localhost ~]# ip add show
1: lo: <LOOPBACK,UP> mtu 16436 qdisc noqueue
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 brd 127.255.255.255 scope host lo
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP> mtu 1500 qdisc pfifo_fast qlen 1000
link/ether 00:0c:29:ee:3c:f9 brd ff:ff:ff:ff:ff:ff
inet 192.168.1.250/24 brd 192.168.1.255 scope global eth0
inet 192.168.1.247/32 scope global eth0
inet6 fe80::20c:29ff:feee:3cf9/64 scope link
valid_lft forever preferred_lft forever
3: eth1: <BROADCAST,MULTICAST,UP> mtu 1500 qdisc pfifo_fast qlen 1000
link/ether 00:0c:29:ee:3c:03 brd ff:ff:ff:ff:ff:ff
inet6 fe80::20c:29ff:feee:3c03/64 scope link
valid_lft forever preferred_lft forever
4: sit0: <NOARP> mtu 1480 qdisc noop
link/sit 0.0.0.0 brd 0.0.0.0
192.168.1.251 add show只能看到192.168.1.245和246这个vip 另外两个vip不能看到。 |
|
免费注册
发表于 2010-11-01 09:23
发表于 2010-11-03 12:59
