Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

Thanks

share|improve this question
add comment

1 Answer

up vote 3 down vote accepted

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:

  1. change the home folder of mysql user:

    usermod -m -d /home/mysql mysql
    
  2. put the following into /home/mysql/.my.cnf:

    [mysql]
    user        = root
    password    = PA$$W0RD
    

https://bugs.launchpad.net/percona-xtradb-cluster/+bug/982003

You can also provide the login credential by using wsrep_sst_auth option (on the donor):

wsrep_sst_auth=root:PA$$W0RD
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.