Netcat data directory to Xtrabackup?

[jmusbach]

Hello, I was wondering…if I were to want to take a backup off a production server but its load is too high for xtrabackup to complete in a timely manner when run on the same server could I have xtrabackup run remotely on another server and read the mysql data directory over net cat? I’ve seen a lot of guides online for sending a streaming backup result over netcat, but not the reverse of sending the data directory to xtrabackup via netcat. Is this possible at all? We think this’d be more preferable then just having a NFS share lying open to the mysql data directory and I couldn’t find any documentation online regarding this which is the reason for the inquiry. Thanks.

EDIT: I see from #3 that the official recommendation is to run xtrabackup on the same machine as the mysql server instance. Does this mean that 1) my inquiry of it reading from net cat is not possible and 2) not even having it read the data dir over NFS would be feasible?

[przemek]

Hello,

Yes, you have to run innobackupex/xtrabackup tools from the same machine the MySQL is running at. You can stream the backup directly to a different server, or network mount, but you need to read the data from locally running MySQL instance.
http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/streaming_backups_innobackupex.html

[jmusbach]

Thanks for your help, I was afraid that was the case.