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

Galera Cluster starting backup can't find innobackupex in the path

I am trying to get a Galera cluster running. I have the first node up and ready for connections. My second node, however, when trying to run wsrep_sst_xtrabackup gets the error "Can't find innobackupex in the path". As soon as I start the mysql service on the second node, I briefly see it as an incoming address on the first node, but then it goes away.

Not sure what would be necessary to help me with this, so here's my whole wsrep specific section of my my.cnf:

binlog_format=ROW                                                                                     
default_storage_engine=innodb                                                                         
innodb_autoinc_lock_mode=2                                                                            
innodb_locks_unsafe_for_binlog=1                                                                      
innodb_doublewrite=1                                                                                  
wsrep_provider=/usr/lib/galera/libgalera_smm.so                                                       
wsrep_provider_options="gcache.size=256M; gcache.page_size=128M"
wsrep_cluster_address=gcomm://firstnode                                                          
wsrep_cluster_name="Cluster"
wsrep_node_address="thisnode"
wsrep_node_name="thisnode"
wsrep_sst_method=xtrabackup                                                                           
wsrep_sst_auth="root:password"
wsrep_node_incoming_address=this node's IP
wsrep_sst_receive_address=this node's IP                                                             
wsrep_slave_threads=16

Am I missing a parameter or something for xtrabackup?

Answer Answered by Ben Stillman in this comment.

See if this helps you out: https://mariadb.com/kb/en/xtrabackup-sync-method/

"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.