agent 的mmm-debug日志如下。
[2009-09-29 12:04:08]: 2832: Listener: Waiting for connection...
[2009-09-29 12:04:11]: 2832: Listener: Waiting for connection...
[2009-09-29 12:04:14]: 2832: Listener: Waiting for connection...
[2009-09-29 12:04:15]: 2832: Listener: Connect!
[2009-09-29 12:04:15]: 2832: GetStatusCommand - result: db9:-1:UNKNOWN::
[2009-09-29 12:04:15]: 2832: Daemon: Answer = 'OK: Returning status!|db9:-1:UNKNOWN::'
[2009-09-29 12:04:15]: 2832: Listener: Disconnect!
[2009-09-29 12:04:15]: 2832: Listener: Waiting for connection...
[2009-09-29 12:04:18]: 2832: Listener: Waiting for connection...
[2009-09-29 12:04:20]: 2832: Listener: Connect!
[2009-09-29 12:04:20]: 2832: GetStatusCommand - result: db9:-1:UNKNOWN::
[2009-09-29 12:04:20]: 2832: Daemon: Answer = 'OK: Returning status!|db9:-1:UNKNOWN::'
[2009-09-29 12:04:20]: 2832: Listener: Disconnect!
[2009-09-29 12:04:20]: 2832: Listener: Waiting for connection...
[2009-09-29 12:04:20]: 2832: Listener: Connect!
[2009-09-29 12:04:20]: 2832: SET_STATUS 0, AWAITING_RECOVERY, ,
[2009-09-29 12:04:20]: 2832: Old roles: $VAR1 = [];[2009-09-29 12:04:20]: 2832: New roles: $VAR1 = [];
求高手解答下,等待,还有个问题,mmm_common.cnf配置文件中的host 字段后面填的的是所要监控的数据库名还是数据库所在的主机名?????求解?
[2009-09-29 12:04:08]: 2832: Listener: Waiting for connection...
[2009-09-29 12:04:11]: 2832: Listener: Waiting for connection...
[2009-09-29 12:04:14]: 2832: Listener: Waiting for connection...
[2009-09-29 12:04:15]: 2832: Listener: Connect!
[2009-09-29 12:04:15]: 2832: GetStatusCommand - result: db9:-1:UNKNOWN::
[2009-09-29 12:04:15]: 2832: Daemon: Answer = 'OK: Returning status!|db9:-1:UNKNOWN::'
[2009-09-29 12:04:15]: 2832: Listener: Disconnect!
[2009-09-29 12:04:15]: 2832: Listener: Waiting for connection...
[2009-09-29 12:04:18]: 2832: Listener: Waiting for connection...
[2009-09-29 12:04:20]: 2832: Listener: Connect!
[2009-09-29 12:04:20]: 2832: GetStatusCommand - result: db9:-1:UNKNOWN::
[2009-09-29 12:04:20]: 2832: Daemon: Answer = 'OK: Returning status!|db9:-1:UNKNOWN::'
[2009-09-29 12:04:20]: 2832: Listener: Disconnect!
[2009-09-29 12:04:20]: 2832: Listener: Waiting for connection...
[2009-09-29 12:04:20]: 2832: Listener: Connect!
[2009-09-29 12:04:20]: 2832: SET_STATUS 0, AWAITING_RECOVERY, ,
[2009-09-29 12:04:20]: 2832: Old roles: $VAR1 = [];[2009-09-29 12:04:20]: 2832: New roles: $VAR1 = [];
求高手解答下,等待,还有个问题,mmm_common.cnf配置文件中的host 字段后面填的的是所要监控的数据库名还是数据库所在的主机名?????求解?
http://kovyrin.net/2007/04/23/master-master-replication-example-using-mmm/
看下上面这个地址;
#200的配置文件内容先编辑mmm_common.conf该文件:active_master_role writer
<host default>
cluster_interface eth1 因为我们使用内网IP,所以选择eth1
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 mmm_agent 更改只读密码
</host>
<host db1> 主库的主机名为db1
ip 192.168.1.200 为主库的IP地址
mode master 工作模式为主
peer db2
</host>
<host db2> 互备主库的主机名为db2
ip 192.168.1.201 互备主库的IP地址
mode master 工作模式为主
peer db1
</host>
<host db3> 从库的主机名为db3
ip 192.168.1.202 从库的IP地址
mode slave 工作模式为从
</host>
<host db4> 从库的主机名为db4
ip 192.168.1.203 从库的IP地址
mode slave 工作模式为从
</host>
<role writer> 写入角色
hosts db1, db2 主库和备从主库
ips 192.168.1.210 虚拟VIP地址
mode exclusive 模式为唯一的即200和201两个互为主从的库只能用到一个IP地址:192.168.0.210
</role>
<role reader> 角色为只读
hosts db3, db4 从库
ips 192.168.0.212, 192.168.1.213 虚拟的只读VIP地址
mode balanced 工作模式为均衡的
</role>