s9s_backup argument list too long

Follow

Paolo Coniglio

• June 26, 2013 12:45

i get this error when doing a backup:

root@galera3:~# s9s_backup --backup -i1 -tfull -b/root/backups
Starting a FULL backup
/usr/bin/s9s_backup: line 70: /usr//bin//mysql: Argument list too long
/usr/bin/s9s_backup: line 73: /usr//bin//mysql: Argument list too long
Backup finished - check Backups for status

i think this happens because i have too many tables files since i had to increase my system limit to ulimit -n 16384 so i could make the backup.

could you guys think of a fix for the s9s_backup script? i found this http://forums.mysql.com/read.php?35,136587,136592#msg-136592

 

0

• 

  Johan

  • June 26, 2013 13:59

  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
• 

  Paolo Coniglio

  • June 26, 2013 14:34

  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
• 

  Johan

  • June 26, 2013 14:50

  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
• 

  Paolo Coniglio

  • June 26, 2013 15:48

  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
• 

  Johan

  • June 26, 2013 16:11

  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.