Announcement

Announcement Module
Collapse
No announcement yet.

Netcat data directory to Xtrabackup?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Netcat data directory to Xtrabackup?

    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?
    Last edited by jmusbach; 07-10-2013, 03:21 PM.

  • #2
    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-x...obackupex.html

    Comment


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

      Comment

      Working...
      X