pengmingde / mysql-master-ha

Automatically exported from code.google.com/p/mysql-master-ha
0 stars 0 forks source link

Error with MariaDB #70

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?

root@lapt:~# /usr/bin/masterha_check_repl --conf=/etc/MHA.cnf --check_only 
--debug
Tue Oct 29 15:10:01 2013 - [warning] Global configuration file 
/etc/masterha_default.cnf not found. Skipping.
Tue Oct 29 15:10:01 2013 - [info] Reading application default configurations 
from /etc/MHA.cnf..
Tue Oct 29 15:10:01 2013 - [info] Reading server configurations from 
/etc/MHA.cnf..
Tue Oct 29 15:10:01 2013 - [info] MHA::MasterMonitor version 0.55.
Tue Oct 29 15:10:01 2013 - [debug] Connecting to servers..
Tue Oct 29 15:10:01 2013 - [debug]  Connected to: 
debian7-01(192.168.4.131:3306), user=root
Tue Oct 29 15:10:01 2013 - [error][/usr/share/perl5/MHA/MasterMonitor.pm, 
ln386] Error happend on checking configurations. Use of uninitialized value in 
string eq at /usr/share/perl5/MHA/Server.pm line 235.
Tue Oct 29 15:10:01 2013 - [error][/usr/share/perl5/MHA/MasterMonitor.pm, 
ln482] Error happened on monitoring servers.
Tue Oct 29 15:10:01 2013 - [info] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

What version of the product are you using? On what operating system?

Manager (Ubuntu 12.04.3 LTS): Using manager 0.55-0, node 0.54-0 
Nodes (Debian 7.2): Using node 0.54-0, mysql 10.0.4-MariaDB-1~wheezy-log

Please provide any additional information below.

On both nodes I am using MariaDB:

root@debian7-01:~# dpkg -l | grep mysql-common
ii  mysql-common                       10.0.4+maria-1~wheezy         all        
  MariaDB database common files (e.g. /etc/mysql/my.cnf)

The .cnf being used:

[server default]
log_level=debug
manager_log=/var/log/masterha/app.log
manager_workdir=/var/log/masterha/
password=***
ping_interval=3
remote_workdir=/var/log/masterha/
ssh_user=root

[server1]
hostname=debian7-01

[server2]
hostname=debian7-02

Original issue reported on code.google.com by ce...@pk2.org on 29 Oct 2013 at 2:21

GoogleCodeExporter commented 9 years ago
Currently MHA does not support MariaDB.

Original comment by Yoshinor...@gmail.com on 29 Oct 2013 at 5:23

GoogleCodeExporter commented 9 years ago
you should modify the file SlaveUtil.pm  . following
.../lib/MHA/SlaveUtil.pm
     -    if ( !MHA::NodeUtil::mysql_version_ge( $mysql_version, "5.6.0" ) ) {
     +    if ( !MHA::NodeUtil::mysql_version_ge( $mysql_version, "11.0.0" ) ) {
then execute 
/usr/bin/masterha_check_repl --conf=/etc/MHA.cnf --check_only --debug
it will be ok ,please try by your self good luck!

Original comment by lidan395...@gmail.com on 2 Jan 2014 at 6:58

GoogleCodeExporter commented 9 years ago
Hi ..
I am facing same issue and I tried configuration suggested by lidan but no luck,
i did changes in if ( !$self->version_ge("11.0.0") ) {
am i correct or doing something wrong.

I am using Ubuntu 12.04 and mariadb 10.0.17-MariaDB-1~precise-log mariadb.org 
binary distribution

if any one find solution please guide me  .

Original comment by rajnish4...@gmail.com on 14 Apr 2015 at 12:00