mha4mysql-manager icon indicating copy to clipboard operation
mha4mysql-manager copied to clipboard

use masterha_check_repl 0.58 work with mysql8.0.15 causes error

Open kud1 opened this issue 5 years ago • 6 comments

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

kud1 avatar Mar 07 '19 07:03 kud1

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.

Paul-Pech avatar Apr 05 '19 19:04 Paul-Pech

I meet the same error.

l3950809 avatar Apr 17 '19 07:04 l3950809

try this way: GRANT INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, REPLICATION SLAVE, REPLICATION CLIENT ON . TO 'repl'@'%'

haogghao avatar Apr 21 '19 15:04 haogghao

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`

LiZhengWeiLZW avatar Jul 27 '19 03:07 LiZhengWeiLZW

+1. it works when i use the mysql5.7.28 version.

xaxnow avatar Nov 08 '19 14:11 xaxnow

I have same issue at mysql8.0.19. Who could please give some help? Thanks you very much

tanshaolong avatar Mar 26 '20 06:03 tanshaolong