Download and Installing MySQL Percona XtraBackup

mysqldump is the common backup tool for MySQL but sometimes depending on you database this backup option is not going to do the job for you as performance will drop. So what are our option when looking for a better backup tool for our MySQL database ?

The most noticeable difference between this two is the fact that Xtrabackup is FREE. Percona XtraBackup is an open-source hot backup utility for MySQL - based servers that doesn't lock your database during the backup. Lets's list some of  Xtrabackup  capabilities
  • 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
So now let's go to work and see how can we download and install Percona's Xtrabackup.
  • Install the yum repository on your host.(this will resolve you requirements much better)
yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
  • Query the Percona Yum Repo for the Xtrabackup available
[root@dcg064 mybackup]# yum search Xtrabackup

================================================================= N/S Matched: Xtrabackup ==================================================================
percona-xtrabackup.x86_64 : XtraBackup online backup for MySQL / InnoDB
percona-xtrabackup-20.x86_64 : XtraBackup online backup for MySQL / InnoDB
percona-xtrabackup-20-debuginfo.x86_64 : Debug information for package percona-xtrabackup-20
percona-xtrabackup-20-test.x86_64 : Test suite for Percona Xtrabackup
percona-xtrabackup-21.x86_64 : XtraBackup online backup for MySQL / InnoDB
percona-xtrabackup-21-debuginfo.x86_64 : Debug information for package percona-xtrabackup-21
percona-xtrabackup-debuginfo.x86_64 : Debug information for package percona-xtrabackup
percona-xtrabackup-test.x86_64 : Test suite for Percona Xtrabackup
percona-xtrabackup-test-21.x86_64 : Test suite for Percona Xtrabackup
  •   Install the Xtrabackup for your type of Operational System arch
yum install percona-xtrabackup.x86_64 -y
  • Now with Percona Xtrabackup installed find where the was installed in the /usr/bin
[root@host]# find / -iname xtrabackup
/usr/bin/xtrabackup
  • Also see where the innobackupex was installed in the /usr/bin
[root@dcg064 mybackup]# find / -iname innobackupex
/usr/bin/innobackupex
Great now the Percona Xtrabackup tools was install successfully. In future articles we will see how we can create backups and recover using  Percona Xtrabackup tool.