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 字段后面填的的是所要监控的数据库名还是数据库所在的主机名?????求解?
解决方案 »
- mysql 与 server sql 2000的差距有多大呢?我想将一个sql2000的迁移到mysql
- 如何调用两个表的信息
- 建立外键时,如果参照表在不同数据库中,这样可不可以实现?
- mysql使用的sql语句叫什么
- mysql 3306端口不能连接的问题
- linux下用c连接postgreSQL,给个例子咯。需要哪些库,头文件?
- 关于数据库维护的新问题.....在线等.
- 怎么控制mysql每天零点自动执行一条插入语句
- mysql存储过程和触发器的问题,来挑战一下吧~
- 谁有mysql 5.5.39驱动jar包 啊 急需
- PostgreSQL在执行update、insert、delete时是操作写磁盘的操作?
- mysql如何导入frm文件?
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>