Having Issues Creating Cluster

  • Filter
  • Time
  • Show
Clear All
new posts

  • Having Issues Creating Cluster

    I am currently trying to set up a Percona cluster, but I'm having some issues. I have no problem getting the first node up and running correctly (verified via the 'show status like wsrep%'). The problem I have is when I try to join the second database node. I'm using Ubuntu 12.04 and the Percona 5.5 packages.

    I have included a lot of log output and configuration files via Pastebin and can be found here: http://pastebin.com/f0Sht6j1

    I am at a loss on this one and any help would be greatly appreciated!!

  • #2
    Ok, I think I've had this.

    This is your culprit:
    innobackupex: Suspend file '/tmp/xtrabackup_suspended_2'
    Remove/move said file on DB01 and try again joining again.


    • #3
      I thought that was the problem too, but the funny thing is I have nothing in /tmp while it's running or before.


      • #4
        Not sure if this provides any insight, but when joining the --suspend-at-end flag is set for xtrabackup_55 binary. When this flag is set the /tmp/xtrabackup_suspended_2 file is set while this is going. While the backup is being streamed, I'm guessing that something is supposed to delete that file to tell xtrabackup_55 to stop streaming. Not sure what is supposed to do this.

        The weird thing is that it looks like when this command is run:

        xtrabackup_55  --defaults-file="/etc/mysql/my.cnf"  --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/tmp --tmpdir=/tmp --stream=xbstream
        No file gets put into the /tmp directory, not sure if this is a bug or not. Just to make sure it's not put somewhere else by accident I ran:

        find / -type f -iname '*xtrabackup_suspended*'
        while the backup was being streamed with no luck.