masterha_check_repl 异常总结
- User rpl does not exist or does not have REPLICATION SLAVE privilege! Other slaves can not start replication from this host
- 这个问题解决方案
- 配置文件里面的复制账户错误,或者你的复制账户,没有复制权限
- 异常(不明白为什么会出现这个问题。)
- Can't exec "mysqlbinlog": No such file or directory at /usr/local/share/perl5/MHA/BinlogManager.pm line 106.
- mysqlbinlog version command failed with rc 1:0, please verify PATH, LD_LIBRARY_PATH, and client options
- 解决
- ln -s /usr/local/mysql/bin/mysqlbinlog /usr/bin/mysqlbinlog
- 问题(不明白为什么会出现这个问题。)
- Checking slave recovery environment settings..
Relay log found at /mysql/data, up to relay.000002
Temporary relay log file is /mysql/data/relay.000002
Testing mysql connection and privileges..sh: mysql: command not found
mysql command failed with rc 127:0! - 解决
- ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
- mha启动异常
- 问题 (配置在 aap.cnf文件里面的服务,其中有没有启动的,或者 没有)
- Multi-master configuration is detected, but two or more masters are either writable (read-only is not set) or dead! Check configurations for details. Master configurations are as below:
- 原因
- 配置在 aap.cnf文件里面的服务,其中有没有启动的,或者 没有配置主从复制关系
- 解决
- 启动服务,配置复制关系。就行了。