Having Issues Creating Cluster

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

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: [url]http://pastebin.com/f0Sht6j1[/url]

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.