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

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 this issue Sep 10, 2020 · 0 comments

Comments

@illmatik12
Copy link

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");
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

1 participant