FATAL Failed to change master to 'db1': ERROR: Invalid master host in show slave status

64 views
Skip to first unread message

au...@naver.com

unread,
Jan 3, 2014, 2:31:45 AM1/3/14
to mmm-...@googlegroups.com
Hi,
I have a question. My Slave node prints this message continually.
How can I Solve it????
 
-------------------------------
2014/01/03 15:06:38  INFO Changing active master to 'db1'
2014/01/03 15:06:39 FATAL Failed to change master to 'db1': ERROR: Invalid master host in show slave status
2014/01/03 15:06:41  INFO Changing active master to 'db1'
2014/01/03 15:06:42 FATAL Failed to change master to 'db1': ERROR: Invalid master host in show slave status
....
....
--------------------------------
 
[root@MMM1 ~]# 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        repl
    replication_password    !replgod77
 agent_user    mmm_agent
 agent_password   !agentgod77
</host>
<host db1>
 ip      192.168.10.201
 mode     master
 peer     db2
</host>
<host db2>
 ip      192.168.10.202
 mode     master
 peer     db1
</host>
<host db3>
 ip      192.168.10.244
 mode     slave
</host>

<role writer>
 hosts     db1, db2 
 ips      192.168.10.250
 mode     exclusive
</role>
<role reader>
 hosts     db1, db2, db3 
 ips      192.168.10.251, 192.168.10.252, 192.168.10.253
 mode     balanced
</role>
Reply all
Reply to author
Forward
0 new messages