ubuntu利用xtrabackup备份mysql数据库

安装

root@zhang:~/xfull# apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
root@zhang:~/xfull# wget https://repo.percona.com/apt/percona-release_0.1-4.$(lsb_release -sc)_all.deb
root@zhang:~/xfull# dpkg -i percona-release_0.1-4.$(lsb_release -sc)_all.deb
root@zhang:~/xfull# apt-get update
root@zhang:~/xfull# apt-get install percona-xtrabackup-24
root@zhang:~/xfull# innobackupex -v
xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --tmpdir=/tmp 
innobackupex version 2.4.14 Linux (x86_64) (revision id: ef675d4)

全备份。备份160G数据大概在70分钟左右

root@zhang:~/xfull# nohup innobackupex  --user=root --password='l#F(y+*Hz3-M' --no-timestamp /zabbixback/zabbix_mysql_back/xfull &> /zabbixback/zabbix_mysql_back/file.txt &

增量备份

root@zhang:~/xfull# innobackupex --user=root --password='l#F(y+*Hz3-M'  --incremental --no-timestamp --incremental-basedir=/root/xfull/  /root/xinz1