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 Pecona-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

XtraBackup Manual

How to obtain tool

How to build tool

How to build

How to use

Internals and plans

internals

Discussion

Maurizio, 2010/01/03 22:32

Hello

thanks for your work on xtrabackup!

I'd like to use it on a win7 64-bit pc with 8gb ram and the biggest part of it assigned to mysql. When I try to do a backup I get the error “xtrabackup: innobase_buffer_pool_size can't be over 4GB on 32-bit systems”.

I cannot find any win64 binaries. Are you going to offer a win64 download?

Thanks again Maurizio

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