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

Checking if super_read_only is defined and turned on..DBD::mysql::st execute failed: Unknown system variable 'super_read_only' at /usr/local/share/perl5/MHA/SlaveUtil.pm line 245. #142

Open illmatik12 opened 3 years ago

illmatik12 commented 3 years ago

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
Server version:         10.3.22-MariaDB-log MariaDB Server
Protocol version:       10

Problem

Checking if super_read_only is defined and turned on..DBD::mysql::st execute failed: Unknown system variable 'super_read_only' at /usr/local/share/perl5/MHA/SlaveUtil.pm line 245.

simple workaround

 my $sth = $dbh->prepare("SELECT \@\@global.super_read_only as Value");
 =>  my $sth = $dbh->prepare("SELECT 0 as Value");