s9s_backup argument list too long

Comments

5 comments

  • Avatar
    Johan

    Hi Paolo,

    Just to confirm the backup finished ok, right?
    If you go to "Backup" --> "Reports" you can see the status. 

    About the argument list too long problem, i need to look at it.

    Then you can do:

    git clone https://github.com/severalnines/s9s-admin
    cd s9s-admin/cluster
    cp s9s* /usr/bin/

    The above fixes the ulimit problem (you should copy the s9s* files to all nodes).

    Best regards and thanks for the feedback!

    Johan

    0
    Comment actions Permalink
  • Avatar
    Paolo Coniglio

    i think the backup finished because i see the tar inside /root/backups/full/

    327M Jun 26 08:18 backup-full-2013-06-26-08-14-34.tar.gz

    and it reports "completed" on the report.

    also, what is the procedure for restoring this backup? thanks.

    0
    Comment actions Permalink
  • Avatar
    Johan

    Hi,
    Is this a galera cluster, in that case:

    http://support.severalnines.com/entries/23523886-Restore-Xtrabackup-on-Galera-Cluster

    BR

    johan

    0
    Comment actions Permalink
  • Avatar
    Paolo Coniglio

    i see, yes im using galera cluster.

    one last question, is there any way to restore only one database or maybe tables? like with mysqldump.

    thanks!

    0
    Comment actions Permalink
  • Avatar
    Johan

    Hi,
    There is no easy way to do it. This is a limitation of Percona Xtrabackup itself, making this very hard.

    I would recommend you restore the full server, let the cluster sync up, and the drop the databases you want to get rid of. 

    Best regards
    Johan

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk