This covers the basic installation of the xtrabackup package on CentOS. This is necessary in order to take hot backups of a database using the InnoDB storage engine. By default, Mysql has no options to take a full hot backup of a live InnoDB database.
For more information, please see Percona’s website located here: http://www.percona.com/doc/percona-xtrabackup/
0. Login as root
(check your server version before installing, there are specific RPM’s for 32-bit and 64-bit)
see here for rpm list: http://www.percona.com/downloads/percona-release/
2. Install rpm (32-bit on this test machine)
Rpm –Uvh percona-release-0.0-1.i386.rpm
3. Check repo for package
yum list | grep percona
yum install xtrabackup –nogpgcheck
I still have testing to do on actual usage, so I’ll create a new post on tests of backups and restoring databases.