标签归档:hot backup utility

使用Xtrabackup进行MySQL备份

Percona Xtrabackup – Documentation

Percona XtraBackup is an open-source hot backup utility for MySQL – based servers that doesn’t lock your database during the backup.

It can back up data from InnoDB, XtraDB, and MyISAM tables on MySQL 5.1 [1], 5.5 and 5.6 servers, as well as Percona Server with XtraDB. For a high-level overview of many of its advanced features, including a feature comparison, please see About Percona Xtrabackup.

Whether it is a 24×7 highly loaded server or a low-transaction-volume environment, Percona XtraBackup is designed to make backups a seamless procedure without disrupting the performance of the server in a production environment. Commercial support contracts are available.

Percona XtraBackup is a combination of the xtrabackup C program, and the innobackupex Perl script. The xtrabackup program copies and manipulates InnoDB and XtraDB data files, and the Perl script enables enhanced functionality, such as interacting with a running MySQL server and backing up MyISAM tables. 继续阅读