mysql

22
Jan

MySQL hot backup with XtraBackup on CentOS

Dwight SchruteIf you are in a need for hot backup solution for MySQL RDBMS, you should try out Percona's XtraBackup. Now, as you can read on the official website, XtraBackup is the world's only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. XtraBackup also supports MyISAM backups, although not without table locks.

XtraBackup consists of three tools - innobackupex, xtrabackup and tar4ibd.

Innobackupex is a wrapper script written in Perl that allows you to backup a complete MySQL instance with InnoDB, MyISAM and XtraDB tables. XtraBackup is a tool compiled in C which main job is to copy only InnoDB and XtraDB data. Of course, there is tar4ibd - a tool that safely stores InnoDB data in tar archive.