下载并安装软件
下载地址:https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.10/binary/redhat/7/x86_64/percona-xtrabackup-24-2.4.10-1.el7.x86_64.rpm 或者http://www.percona.com/downloads/XtraBackup/
执行安装脚本
# yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL libev-devel perl-Digest-MD5
# rpm -ivh percona-xtrabackup-24-2.4.10-1.el7.x86_64.rpm
全量备份
创建备份用户
create user 'backup'@'%' identified by 'backup';
grant reload,lock tables,replication client,create tablespace,super on *.* to 'backup'@'%';
创建备份目录
# mkdir /root/backup/full
全量备份脚本
$ innobackupex --defaults-file=/etc/my.cnf --user=root --password=root --socket=/usr/local/mysql/socket/mysql.sock /root/backup/full
编写shell脚本
# touch backup.sh
# chmod 777 backup.sh
// backup.sh 文件内容如下:
#!/bin/sh
innobackupex --defaults-file=/etc/my.cnf --user=root --password=root --socket=/usr/local/mysql/socket/mysql.sock /root/backup/full
crond定时器常用命令
service crond start //启动服务
service crond stop //关闭服务
service crond restart //重新启动服务
service crond reload //又一次加载配置
crontab -e // 编辑任务
crontab -l // 查看定时任务
crontab -r // 删除定时任务
向定时器加入定时执行(每天12:00和19:30执行定时任务)
00 19 * * * sh /root/backup/backup.sh
00 12 * * * sh /root/backup/backup.sh