安装
http://www.percona.com/downloads/XtraBackup/XtraBackup-2.1.6/binary/Linux/x86_64/

[root@goolen ~]# ls percona-xtrabackup-2.1.6-702-Linux-x86_64.tar.gz
percona-xtrabackup-2.1.6-702-Linux-x86_64.tar.gz

[root@goolen ~]# tar zxfv percona-xtrabackup-2.1.6-702-Linux-x86_64.tar.gz

[root@goolen ~]# ls percona-xtrabackup-2.1.6-Linux-x86_64/
bin share

[root@goolen ~]# cp percona-xtrabackup-2.1.6-Linux-x86_64 /usr/local/xtrabackup -r

[root@goolen ~]# vim .bash_profile
export PATH=$MYSQL_HOME/bin:/usr/local/xtrabackup/bin:$PATH

[root@goolen ~]# . .bash_profile

[root@goolen ~]# ls /usr/local/xtrabackup/bin/
innobackupex innobackupex-1.5.1 xbcrypt xbstream xtrabackup xtrabackup_55 xtrabackup_56

创建备份用户：
mysql> grant reload,lock tables,replication client,create tablespace,super on *.* to 'backup'@'%' identified by 'backup';
mysql> grant reload,lock tables,replication client,create tablespace,super on *.* to 'backup'@'localhost' identified by 'backup';

ITPub博客

xtrabackup-安装

最新文章