search

yoshinorim / mha4mysql-manager

Development tree of Master High Availability Manager and tools for MySQL (MHA), Manager part
http://code.google.com/p/mysql-master-ha/
GNU General Public License v2.0
1.46k stars 501 forks source link

use masterha_check_repl 0.58 work with mysql8.0.15 causes error #119

Open kud1 opened 5 years ago

kud1 commented 5 years ago

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

Paul-Pech commented 5 years ago

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.

l3950809 commented 5 years ago

I meet the same error.

haogghao commented 5 years ago

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

LiZhengWeiLZW commented 5 years ago

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`

xaxnow commented 4 years ago

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

tanshaolong commented 4 years ago

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