Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
kud1 opened this issue Mar 7, 2019 · 6 comments
Open

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

kud1 opened this issue Mar 7, 2019 · 6 comments

Comments

@kud1
Copy link

kud1 commented Mar 7, 2019

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
Copy link

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
Copy link

I meet the same error.

@haogghao
Copy link

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

@LiZhengWeiLZW
Copy link

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
Copy link

xaxnow commented Nov 8, 2019

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

@tanshaolong
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

7 participants