GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

wsrep_sst_xtrabackup defaults-file error

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • wsrep_sst_xtrabackup defaults-file error

    Hello,
    I am trying to set up a 3-node cluster. On bootstrap I get this error message:
    140110 10:32:20 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_xtrabackup --role 'joiner' --address '10.120.150.44' --auth 'sstuser:S5tU53R' --datadir '/ccv/data/mysql/300/data/' --defaults-file '/etc/my.cnf' --parent '9475'
    Read: '(null)'
    140110 10:32:20 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup --role 'joiner' --address '10.120.150.44' --auth 'sstuser:S5tU53R' --datadir '/ccv/data/mysql/300/data/' --defaults-file '/etc/my.cnf' --parent '9475': 2 (No such file or directory)
    140110 10:32:20 [ERROR] WSREP: Failed to prepare for 'xtrabackup' SST. Unrecoverable.

    How can I specify that my defaults-file is "/etc/mysql/my.cnf" and not "/etc/my.cnf" ?

    Thanks in advance.

  • #2
    default percona will look into /etc/my.cnf(depending on the distros) , if you want you can copy /etc/mysql/my.cnf to /etc/my.cnf or while starting mysql use --config /path/to/file.

    Comment


    • #3
      This error will only manifest when bootstraping the cluster : when the wsrep_cluster_address is set with the nodes IP adresses. If "wsrep_cluster_address=gcomm://" then all 3 nodes will boot up without problem. But without replication of course.

      Comment


      • #4
        Replication is now working within 3 nodes with rsync. I still need to find out how to configure xtrabackup to recognize "defaults_file=/etc/mysql/my.cnf"

        Comment


        • #5
          Replication is now working with xtrabackup. After checking with http://www.percona.com/doc/percona-x...ackup_sst.html , I have changed "wsrep_sst_method =xtrabackup " to "wsrep_sst_method =xtrabackup-v2".

          Comment


          • #6
            good that you found solution u r self

            Comment

            Working...
            X