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 mysql5.6.35 causes error #111

Open nigel889 opened 6 years ago

nigel889 commented 6 years ago

Hi, we are running on CentOS6.5, DataBase is mysql5.6.35, when I run masterha_check_repl script, get error in follows: Checking slave recovery environment settings.. Relay log found at /database/percona/relaylog, up to relay-index.000755 Temporary relay log file is /database/percona/relaylog/relay-index.000755 Checking if super_read_only is defined and turned on..DBD::mysql::st execute failed: Unknown system variable 'super_read_only' at /usr/share/perl5/vendor_perl/MHA/SlaveUtil.pm line 245. Tue Jun 5 17:41:48 2018 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln208] Slaves settings check failed! Tue Jun 5 17:41:48 2018 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln416] Slave configuration failed. Tue Jun 5 17:41:48 2018 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations. at /usr/bin/masterha_check_repl line 48 Tue Jun 5 17:41:48 2018 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers.

peng19832 commented 6 years ago

only 5.7 have 'super_read_only'

nigel889 commented 6 years ago

@peng19832 percona5.6.32 have "'super_read_only"

martinamps commented 5 years ago

@nigel889 @peng19832 I attached a PR that should help