Announcement

Announcement Module
Collapse
No announcement yet.

Help with XtraBackup, I'm a new user

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

  • Help with XtraBackup, I'm a new user

    Hi everybody,

    I'm trying to migrate from mysqldump to an alternative that allows hot backups with non-blocking tables. I have studied about mydumper (I think that blocks tables during the process) and XtraBackup.

    With XtraBackup: I have executed this command
    innobackupex --user=root --password=root_password --databases="banksdb" /root
    banksdb it's a small database (110MB) and the process spend a lot of time ( I have seen that is copying ibdata1 file with 24GB!). Is it normal?
    After that, I'm going to execute
    innobackupex --user=root --password=root_password --databases="banksdb" --apply-log /root

    Is correct my process? Where is the mistake? Any ideas?

    I have read about XtraBackup and I don't clear if I should to use --databases or --include to make a fragmental backup.

    With mydumper: I have executed the command and I have not detect blocks in the activity (Only checked reads, without writers) ... Any ideas?

    Thanks in advance and my apologize if this post is some obvious.

    Regards,

    Antonio.
    Learning and learning and learning ...

  • #2
    Percona has great docs and guides for Xtrabackup, so I would check those out first:

    http://www.percona.com/doc/percona-xtrabackup/2.1/

    You will find detailed guides on taking and preparing full backups, incremental backups, and single tables. I believe that will answer most of your questions about.

    As for how long the backup takes, that is very dependent on your data size, disk speed, and database activity. In your case it is likely due to slow drive speeds, as it sounds like you are doing this on a personal computer.

    Comment


    • #3
      Thanks Scott for your answer.

      Yes, I executed the commands over my personal computer.
      For other hand, our database has continuos activity so it's very important that with a new backup technique, avoid blocks in the service.

      Thanks again for your attention.

      Regards,

      Antonio.
      Learning and learning and learning ...

      Comment

      Working...
      X