Buy Percona SupportEmergency? Get 24/7 Help Now!

Sending Backups to Remote Hosts with innobackupex

Besides using the --stream for sending the backup to another host via piping (see Streaming and Compressing Backups), innobackupex can do it directly with the --remote-host

$ innobackupex --remote-host=REMOTEUSER@REMOTEHOST /path/IN/REMOTE/HOST/to/backup/

innobackupex will test the connection to REMOTEHOST via ssh and create the backup directories needed as the REMOTEUSER you specified. The options for ssh can be specified with --sshopt

Warning

The path you provide for storing the backup will be created at REMOTEHOST, not at the local host.

Then all the log files will be written to a temporary file on a local system (you can choose where to store this file with the --tmpdir option) and will be copied via scp. The options for scp can be specified with --options-scp (-Cp -c arcfour by default), for example:

$ innobackupex --remote-host=REMOTEUSER@REMOTEHOST /path/IN/REMOTE/HOST/to/backup/ \
   --tmpdir=/tmp --scpopt="-Cp -c arcfour"

Note

SSH public key authentication should be set up to avoid the login prompt when doing the backup to the remote host.

Previous topic

Throttling backups with innobackupex

Next topic

Restoring Individual Tables

This documentation is developed in Launchpad as part of the Percona XtraBackup 2.0.
If you spotted inaccuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.


General Inquiries

For general inquiries, please send us your question and someone will contact you.