Announcement

Announcement Module
Collapse
No announcement yet.

XtraBackup for SST

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

  • XtraBackup for SST

    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

    Comment


    • #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

      Comment


      • #4
        I resolve it, you must put in my.cnf file in [MYSQLD] section :
        datadir=/var/lib/mysql
        tmpdir=/tmp
        user=mysql

        Be carrefull, you can probably obtain a start/stop failed, so you must update password for mysql user debian-syst-main.
        This password is written in debian.cnf file

        Comment

        Working...
        X