GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

I have some general question for Percona XtraBackup 2.1.4 product.

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

  • I have some general question for Percona XtraBackup 2.1.4 product.

    We are planning to have some robust solution for backup of our db in MySQL server.For this I have some general question for Percona XtraBackup 2.1.4 product.
    1)To take backup, do we need to install xtrabackup 2.1 on each server?
    2)Can it deliver backups as zip files to remote , to aws (amazon web services s3), and other ftp?
    3)Can it do incremental backup?
    4)How much time would it take for 8GB db?

  • #2
    1 - on each MySQL server where you would like to take backups from or to prepare your backups
    2 - you can make a very simple script that does archive the backup directory and then uses s3cmd, ftp or other tool to upload it wherever you wish. Note that uploading large files to S3 may be problematic, so it's better to split them into like 1-2GB parts before.
    3 - http://www.percona.com/doc/percona-x..._ibkx_inc.html
    4 - depends on your hardware capabilities and on how your database is busy during the backup. For most of the time it's just simple files copy, so disk array throughput matters.

    Comment

    Working...
    X