flyinweb's blog

Xtrabackup是percona开发的产品，可以看做是InnoDB Hotbackup的免费替代品。

Percona XtraBackup is the world's only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB, XtraDB, and MyISAM databases⁰. It makes MySQL hot backups for all versions of Percona Server, MySQL, and MariaDB. It performs streaming, compressed, and incremental MySQL backups.

What are the features of Percona XtraBackup?

Here is a short list of XtraBackup features. See the documentation for more.

• Create hot InnoDB backups without pausing your database
• Make incremental backups of MySQL
• Stream compressed MySQL backups to another server
• Move tables between MySQL servers online
• Create new MySQL replication slaves easily
• Backup MySQL without adding load to the server

先看看如何安装Xtrabackup，下载最新的版本，最简单的安装方式无疑是使用RPM包，不过如果你想使用源代码方式安装的话，则会发现其安装方式有点古怪，这是因为它采用的在MySQL源代码上打补丁构建的方式。