mha4mysql-manager
mha4mysql-manager copied to clipboard
use masterha_check_repl 0.58 work with mysql8.0.15 causes error
Hi, We have a problem: Thu Mar 7 15:18:50 2019 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping. Thu Mar 7 15:18:50 2019 - [info] Reading application default configuration from app1.cnf.. Thu Mar 7 15:18:50 2019 - [info] Reading server configuration from app1.cnf.. Thu Mar 7 15:18:50 2019 - [info] MHA::MasterMonitor version 0.58. Thu Mar 7 15:18:51 2019 - [error][/usr/local/share/perl5/MHA/ServerManager.pm, ln188] There is no alive server. We can't do failover Thu Mar 7 15:18:51 2019 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations. at /usr/local/share/perl5/MHA/MasterMonitor.pm line 329. Thu Mar 7 15:18:51 2019 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers. Thu Mar 7 15:18:51 2019 - [info] Got exit code 1 (Not master dead).
Any one can tell me why? thanks
You have to have a working replication setup before starting MHA. MHA will not configure your servers, you will have to do that yourself.
Once you have a working replication setup, try starting MHA again. If it still fails, provide your configuration files, please.
I meet the same error.
try this way: GRANT INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, REPLICATION SLAVE, REPLICATION CLIENT ON . TO 'repl'@'%'
try this way: GRANT INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, REPLICATION SLAVE, REPLICATION CLIENT ON . TO 'repl'@'%'
It does not work. `cat app1.cnf [server default] manager_workdir=/var/log/masterha/app1 manager_log=/var/log/masterha/app1/manager.log master_ip_failover_script=/etc/masterha/master_ip_failover master_ip_failover_script=/etc/masterha/master_ip_online_change
ssh_user=root
repl_user=repluser repl_password=123qqq...A
user=root password=123qqq...A
[server1] hostname=192.168.2.11 port=3306 candidate_master=1
[server2] hostname=192.168.2.12 port=3306 candidate_master=1
[server3] hostname=192.168.2.13 port=3306 no_master=1
[server4] hostname=192.168.2.14 port=3306 no_master=1`
+1. it works when i use the mysql5.7.28 version.
I have same issue at mysql8.0.19. Who could please give some help? Thanks you very much