mha4mysql-manager

mha4mysql-manager copied to clipboard

Got "MySQL server has gone away" error on checking slave status

4

Hi, my mha failover failed due to "MySQL server has gone away". my config: ``` [server default] # mysql user and password user=root password=root ssh_user=root # working directory on the...

cngddflzw

mha 0.58 does not work properly in my enviroment. i did some workaround and works fine. please considering support mariadb. ## ENV : Mariadb ``` MHA : 0.58 Server: MariaDB...

illmatik12

MHA mysql command failed with rc 1:0!

1

Mon Sep 7 22:17:00 2020 - [info] Connecting to [email protected](192.168.142.134:22).. Checking slave recovery environment settings.. Opening /home/mysql/data/relay-log.info ... ok. Relay log found at /home/mysql/data, up to mysql-relay-bin.000002 Temporary relay log...

shiyajing

[info] Executing SSH check script: exit 0 hanging

1

start manager command as follows ```bash masterha_manager --conf=/etc/app1.cnf > /var/log/mha/mha.log 2>&1 & ``` tail -f /var/log/masterha/app1/app1.log ``` Mon Aug 15 11:21:10 2022 - [info] MHA::MasterMonitor version 0.58. Mon Aug 15...

zishiguo

Simulate the main instance crash，hang ssh

3

1.ssh 检查ok [root@trsen184 masterha]# masterha_check_ssh --conf=/usr/local/masterha/masterha_mha1.cnf Tue Jul 30 11:57:32 2019 - [info] Reading default configuration from /etc/masterha_default.cnf.. Tue Jul 30 11:57:32 2019 - [info] Reading application default configuration from...

trsenzhang

Perl 5.24.1: Redundant argument in sprintf at /usr/local/share/perl/5.24.1/MHA/NodeUtil.pm line 195

5

With Perl 5.24.1 in NodeUtil.pl the following error occurs: ``` masterha_check_repl --conf=/etc/mha/app1.cnf Fri Nov 9 10:28:01 2018 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping. Fri Nov 9 10:28:01...

Cugar15

Maybe it is not recommend / typical usage. My simple environment: hostA (master) hostB (backup master) hostC (slave for backup) . Used as manager node. host A/B/C can ssh login...

leafgray

Hi When running masterha_check_ssh --conf=/masterha/conf/app1.cnf,got the following error. Use of uninitialized value in exit at /usr/bin/masterha_check_ssh line 44. perl version is This is perl 5, version 26, subversion 3 (v5.26.3)...

wavelet123

When I set'default-character-set=utf8mb4' on binlogserver, MHA failover will fail. MySQL: MySQL5.7 MHA: mha4mysql-node-0.56-0.el6.noarch.rpm Suggest: - can try to add the --no-defaults option to change this state.

askfiy

Hello. I want to set the number of health checks when an error is detected in the config file. However, the value is hard-coded in the source. [source is here.](https://github.com/yoshinorim/mha4mysql-manager/blob/abe11f9abb74bc5886012ff5cc9e209fb9b093c1/lib/MHA/HealthCheck.pm#L663-L670)...

kuroseets