Quick note about one method to back up MySQL database to another host. There are lots of ways to do this but I use this one the most. Note: you should read and fully understand how to use Xtrabackup. Please read at Percona’s site.
Xtraback up can now use qpress, but I have just not had luck with qpress and so still use the ever trusty pigz. In addition to pigz you will need netcat ( nc).
On the destination hosts ( the host where you want to send the back up to) cd into your directory where you want to create the back up:
cd /mybackups/
and run:
nc host 1234 | gunzip | tar ixvf -
where host is the hostname or ipaddress of the server you want to back up.
On host you want to back up ( note: I would recommend this be a slave of the actual master but depending on engine type and size you could do this on master).
cd to data directory and run
innobackupex --user=user --password=password --stream=tar ./ | pigz | nc -l 1234
you should now see your back up running and sending its copy to remote host.
If you are not using Percona’s tools, or you need MySQL support I HIGHLY recommend Percona. They are fantastic.