The Percona XtraBackup Tool

Percona XtraBackup is OpenSource online (non-blockable) backup solution for InnoDB and XtraDB engines. It works with MySQL 5.0 and 5.1 versions (InnoDB Plugin and Barracuda format is supported as of release 0.9.5rc) and also can handle MyISAM tables. XtraBackup is distributed under GPL v2 license.

Introduction

There two main tools:

xtrabackup - binary, which allows to copy only InnoDB/XtraDB tablespaces
innobackupex - script, based on innobackup Perl script, distributed by Oracle/InnoDB under GPL license. Script was modified to work with xtrabackup binary and accept new parameters. Script provides functionality to backup whole MySQL database instance with MyISAM, InnoDB, XtraDB tables.

Backup can be run against standard MySQL version 5.0 and 5.1 and any version of InnoDB (5.0, 5.1, 1.0-plugin) or XtraDB. You do not need to have patched MySQL to use backup utility. Patching MySQL is only needed to prepare xtrabackup binary from source code.

The source code lives on Launchpad : https://launchpad.net/percona-xtrabackup and you can report bug to Launchpad bug system.

For general questions use Percona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona

Main features

Online non-blocking backup for InnoDB and XtraDB tables; read-only for MyISAM tables
Stream compressed backup to tape or remote box

Documentation

Release Notes

XtraBackup 1.3

How to obtain tool

How to build tool

How to build

How to use

Internals and plans

internals

Please note that this is NOT a place to ask questions or report bugs. This comment system is only intended for users to share tips and documentation additions concerning particular document.
Please report bugs to https://bugs.launchpad.net/percona-project/+filebug and ask general questions in maillist Percona-discussions

Discussion

Vadim Tkachenko, 2010/01/04 13:08

Maurizio,

Right, our current windows binaries are 32bit. We are looking how we can setup 64bits. Meantime as workaround you can use separate my.ini for xtrabackup with innodb_buffer_pool<4GB

Timothy, 2010/01/06 01:32

Hello

I have some confusion about xtrabackup.

It will be so kind of you to give me some suggestions.

Firstly,can xtrabackup be installed on Windows 2000?

Secondly,can xtracbackup be doing increment backup?

Thirdly,If I have database A, B and C, can I restore database A alone without having an influence on database B and C?

Best Regards,

Timothy.

ranjan, 2010/01/14 17:33

I have installed the xtrabackup in linux CentOS 5 - 32-BIT. But I am getting this error when I run backup command. Any one let me know xtrabackup not supporting 32-BIT CentOS 5

Ben Wiseley, 2010/04/08 17:38

I was wondering about how to reduce the size of backups? We have a production DB (which is around 3GB gz'd) and a test DB which is 5MB. On test I've loaded the production DB now and then but, even after dropping the production DB (so only the test db is left) and doing a 'mysqladmin flush-logs' the uncompressed backups of the test db are 14GB. Any ideas what would be causing this?

-ben