MySQL: backup tools

Percona 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, 5.5 and 5.6 servers. This tool 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.

ZRM for MySQL Community Edition is a freely downloadable version of ZRM for MySQL. This tool works with any storage engine on MySQL 4.1.x and MySQL 5.x. Backups are done via mysqldump, various snapshots, mysqlhotcopy or MySQL replication. ZRM provides hot backup via snapshots.

Leave a Reply