I'm looking for some instructions/manual to set Percona Xtradb cluster with Xtrabackup for SST. Is there any configuration file where I need to provide login details for Xtrabackup script?
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
Is there any configuration file where I need to provide login details for Xtrabackup script?
If you have tried that, take a look at the
innobackup.backup.log on the donor, you will see something like this:
innobackupex: Error: mysql child process has died: ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using password: NO)
It means that
/usr/bin/wsrep_sst_xtrabackup is running as
mysql user without any auth setting. So, what I have done to make it work is:
change the home folder of
usermod -m -d /home/mysql mysql
put the following into
[mysql] user = root password = PA$$W0RD
You can also provide the login credential by using wsrep_sst_auth option (on the donor):