XtraBackup for SST

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hi,

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

2

Hi,

I have the same problem, so how to configure it ?

Thx

Best regards

3

Hi,

I upgrade Percona in 5.5.23 and I can’t restart node 2 and node 3, because I have some errors with SST method xtrabackup :

120516 14:33:23 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup ‘joiner’ ‘192.168.2.150’ ‘sst:******’ ‘/var/lib/mysql/’ ‘/etc/mysql/my.cnf’ ‘22972’ 2>sst.err: 32 (Broken pipe)
120516 14:33:23 [ERROR] WSREP: Failed to read uuid:seqno from joiner script.
120516 14:33:23 [ERROR] WSREP: SST failed: 32 (Broken pipe)
120516 14:33:23 [ERROR] Aborting
120516 14:41:44 [Warning] WSREP: 1 (percona-node1): State transfer to 0 (percona-node2) failed: -1 (Operation not permitted)
120516 14:41:44 [ERROR] WSREP: gcs/src/gcs_group.c:gcs_group_handle_join_msg():712: Will never receive state. Need to abort.

in the sst.err file, I have :

tar: Ceci ne ressemble pas à une archive de type « tar »
tar: Arrêt avec code d’échec à cause des erreurs précédentes
Error while getting st data from donor node

Thx for your help