Mysql MHA 搭建报错：thhere are 2 non-slave servers! MHA manages at most one non-slave server

- 日理万妓 2022-06-17 06:43 115阅读 0赞

问题描述：

在搭建好mysql mha 后，测试mysql 的自动切换，切换之后检查报如下错误

Wed Apr 19 16:14:17 2017 - \[warning\] Global configuration file /etc/masterha\_default.cnf not found. Skipping.  
Wed Apr 19 16:14:17 2017 - \[info\] Reading application default configurations from /etc/masterha/app1.cnf..  
Wed Apr 19 16:14:17 2017 - \[info\] Reading server configurations from /etc/masterha/app1.cnf..  
Wed Apr 19 16:14:17 2017 - \[info\] MHA::MasterMonitor version 0.55.  
Wed Apr 19 16:14:18 2017 - \[error\]\[/usr/share/perl5/vendor\_perl/MHA/ServerManager.pm, ln604\] There are 2 non-slave servers! MHA manages at most one non-slave server. Check configurations.  
Wed Apr 19 16:14:18 2017 - \[error\]\[/usr/share/perl5/vendor\_perl/MHA/MasterMonitor.pm, ln386\] Error happend on checking configurations.  at /usr/share/perl5/vendor\_perl/MHA/MasterMonitor.pm line 300  
Wed Apr 19 16:14:18 2017 - \[error\]\[/usr/share/perl5/vendor\_perl/MHA/MasterMonitor.pm, ln482\] Error happened on monitoring servers.  
Wed Apr 19 16:14:18 2017 - \[info\] Got exit code 1 (Not master dead).  
  
  
MySQL Replication Health is NOT OK!

解决方法：

配置56节点mysql为新的slave，并启动同步进程

mysql> reset master;

mysql> change master to master\_host='192.168.180.57',master\_port=3306,master\_user='mysql',master\_password='mysql';  
Query OK, 0 rows affected, 2 warnings (0.08 sec)  
  
  
mysql> start slave;  
Query OK, 0 rows affected (0.00 sec)  
  
  
mysql> show slave status\\G;  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
               Slave\_IO\_State: Waiting for master to send event  
                  Master\_Host: 192.168.180.57  
                  Master\_User: mysql  
                  Master\_Port: 3306  
                Connect\_Retry: 60  
              Master\_Log\_File: mysql-bin.000002  
          Read\_Master\_Log\_Pos: 893  
               Relay\_Log\_File: master-relay-bin.000003  
                Relay\_Log\_Pos: 1106  
        Relay\_Master\_Log\_File: mysql-bin.000002  
             Slave\_IO\_Running: Yes  
            Slave\_SQL\_Running: Yes  
              Replicate\_Do\_DB:   
          Replicate\_Ignore\_DB:   
           Replicate\_Do\_Table:   
       Replicate\_Ignore\_Table:   
      Replicate\_Wild\_Do\_Table:   
  Replicate\_Wild\_Ignore\_Table:   
                   Last\_Errno: 0  
                   Last\_Error:   
                 Skip\_Counter: 0  
          Exec\_Master\_Log\_Pos: 893  
              Relay\_Log\_Space: 1527  
              Until\_Condition: None  
               Until\_Log\_File:   
                Until\_Log\_Pos: 0  
           Master\_SSL\_Allowed: No  
           Master\_SSL\_CA\_File:   
           Master\_SSL\_CA\_Path:   
              Master\_SSL\_Cert:   
            Master\_SSL\_Cipher:   
               Master\_SSL\_Key:   
        Seconds\_Behind\_Master: 0  
Master\_SSL\_Verify\_Server\_Cert: No  
                Last\_IO\_Errno: 0  
                Last\_IO\_Error:   
               Last\_SQL\_Errno: 0  
               Last\_SQL\_Error:   
  Replicate\_Ignore\_Server\_Ids:   
             Master\_Server\_Id: 2  
                  Master\_UUID: 5c7935a8-23dd-11e7-9dd5-0050568e377e  
             Master\_Info\_File: /data/mysql/master.info  
                    SQL\_Delay: 0  
          SQL\_Remaining\_Delay: NULL  
      Slave\_SQL\_Running\_State: Slave has read all relay log; waiting for more updates  
           Master\_Retry\_Count: 86400  
                  Master\_Bind:   
      Last\_IO\_Error\_Timestamp:   
     Last\_SQL\_Error\_Timestamp:   
               Master\_SSL\_Crl:   
           Master\_SSL\_Crlpath:   
           Retrieved\_Gtid\_Set:   
            Executed\_Gtid\_Set:   
                Auto\_Position: 0  
         Replicate\_Rewrite\_DB:   
                 Channel\_Name:   
           Master\_TLS\_Version:   
1 row in set (0.00 sec)  
  
  
ERROR:   
No query specified