•  

Announcement

Announcement Module
Collapse
No announcement yet.

innobackupex with port forwarding

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

  • innobackupex with port forwarding

    #1
    I have setup a ssh port forwarded 3316.
    I try to use innobackupex --slave-info --user=xx --password=xxx --port=3316 /data/backups/
    it backs up the local instance of mysql (port 3306) not the forwarded instance on port 3316.

    Can I take a backup over a forwarded port?
    Tags: None
  • #2
    You should run XtraBackup local to the server you want to backup. XtraBackup copies files and if will not work properly over the network - you can stream to a remote server though from the backup source.

    http://www.percona.com/doc/percona-xtrabackup/innobackupex/c reating_a_backup_ibk.html
    http://www.percona.com/doc/percona-xtrabackup/innobackupex/h ow_innobackupex_works.html

    Comment

    • #3
      I would love to have everything on the same server. Unfortunately, I don't have enough space to keep full backups on production server. If I stream the backup, I can't zip or encrypt it until it is completely on the backup server. Also, it does not leave the files I need to start the incremental backup from. Bin-log location, etc.
      Is there a way to stream the backup and leave the bin-log pointer file to do an incremental backup from?

      Comment

      • #4
        @donkamesen

        The recipes page provides a number of options for streaming your backup from the production server to the destination - full or incremental. http://www.percona.com/doc/percona-xtrabackup/how-tos.html?i d=percona-xtrabackup:innobackupex:how_to_recipes

        You can stream via SSH if you are concerned about someone sniffing your backups over the network and encrypt/compress on the destination server at the same time.

        Comment

        • #5
          Or you can stream to a fifo (see "man mkfifo") and compress on the source server before sending it over the network.

          Comment

          Working...
          X