2.XtraBackup备份工具
问题
1)安装XtraBackup软件包。
2)使用XtraBackup执行完整备份、增量备份。
3)准备数据恢复目录。
步骤
实现此案例需要按照如下步骤进行。
步骤一:安装XtraBackup软件包
1)了解软件包描述信息
[root@dbsvr1 pub]# rpm -qpi percona-xtrabackup-2.1.6-702.rhel6.x86_64.rpm
Name : percona-xtrabackup Relocations: (not relocatable)
Version : 2.1.6 Vendor: (none)
Release : 702.rhel6 Build Date: 2013年11月20日 星期三 21时20分45秒
Install Date: (not installed) Build Host: jhc-new-2-centos6-64.novalocal
Group : Server/Databases Source RPM: percona-xtrabackup-2.1.6-702.rhel6.src.rpm
Size : 25077849 License: GPLv2
Signature : (none)
Packager : Percona Development Team mysql-dev@percona.com
URL : http://www.percona.com/software/percona-xtrabackup/
Summary : XtraBackup online backup for MySQL / InnoDB
Description :
Percona XtraBackup is OpenSource online (non-blockable) backup solution for InnoDB and XtraDB engines.
2)安装依赖包perl-DBD-MySQL
使用RHEL 6自带的即可,yum方式安装:
[root@dbsvr1 pub]# yum -y install perl-DBD-MySQL
… …
Running Transaction
Warning: RPMDB altered outside of yum.
Installing : perl-DBD-MySQL-4.013-3.el6.x86_64 1/1
Verifying : perl-DBD-MySQL-4.013-3.el6.x86_64 1/1
Installed:
perl-DBD-MySQL.x86_64 0:4.013-3.el6
Complete!
如果未安装此依赖包,则直接安装percona-xtrabackup时会报错:
[root@dbsvr1 pub]# rpm -ivh percona-xtrabackup-2.1.6-702.rhel6.x86_64.rpm
error: Failed dependencies:
perl(DBD::mysql) is needed by percona-xtrabackup-2.1.6-702.rhel6.x86_64
3)安装perl-DBD-MySQL
[root@dbsvr1 pub]# rpm -ivh percona-xtrabackup-2.1.6-702.rhel6.x86_64.rpm
Preparing… ########################################### [100%]
1:percona-xtrabackup ########################################### [100%]
4)确认安装的主要程序/脚本
[root@dbsvr1 pub]# rpm -ql percona-xtrabackup
/usr/bin/innobackupex
/usr/bin/innobackupex-1.5.1
/usr/bin/xbcrypt
/usr/bin/xbstream
/usr/bin/xtrabackup
/usr/bin/xtrabackup_55 //适用 MySQL 5.5版本
/usr/bin/xtrabackup_56 //适用 MySQL 5.6版本
/usr/share/doc/percona-xtrabackup-2.1.6
/usr/share/doc/percona-xtrabackup-2.1.6/COPYING
步骤二:使用XtraBackup执行数据库备份
1)做一个完整备份
创建存放备份的文件夹:
[root@dbsvr1 ~]# mkdir -p /backup/mysql
将所有库完整备份到 /backup/mysql/文件夹下,选项 --backup表示备份,–datadir指定MySQL的数据库存放目录,–target-dir指定目标文件夹:
[root@dbsvr1 ~]# xtrabackup_56 –backup
–datadir=/var/lib/mysql/
–target-dir=/backup/mysql/
xtrabackup_56 version 2.1.6 for MySQL server 5.6.11 Linux (x86_64) (revision id: 702)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql/
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 50331648
log scanned up to (1787687)
InnoDB: Allocated tablespace 1, old maximum was 0
[01] Copying ./ibdata1 to /backup/mysql/ibdata1
[01] …done
[01] Copying ./mysql/innodb_table_s