The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

xtrabackup sync method

Hello,

have installed Maria on Centos 6.4 x86_64:

MariaDB-common-5.5.31-1.x86_64
MariaDB-Galera-server-5.5.29-1.x86_64
MariaDB-compat-5.5.31-1.x86_64
MariaDB-client-5.5.31-1.x86_64

and the primary node is working fine with the configuration:

[mysqld]
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_name="MYCLUSTER"
wsrep_node_name=db1
wsrep_cluster_address="gcomm://"
wsrep_slave_threads=8
wsrep_sst_method=xtrabackup
wsrep_sst_auth=username:password
wsrep_node_address=172.30.10.13
datadir=/var/lib/mysql
innodb_autoinc_lock_mode=2

The problem is on the second node when it tries to replicate as receiving the error:

130629  8:55:17 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_xtrabackup --role 'joiner' --address '172.30.10.18' --auth 'username:password' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '7131'
        Read: 'Can't find innobackupex in the path'

yet innobackupex is indeed within the path. What could the issue be please ?

Answer Answered by Phil D in this comment.

Resolved. The answer was to run wsrep_sst_xtrabackup manually, view the error, then look at the code to see that 'which' needed to be installed! yum install which. Once that had been done the second node successfully ran xtrabackup and syncronized the cluster.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.