/database-backup

mysql和mongodb定时备份并上传到阿里云OSS

Primary LanguageShell

安装压缩工具

yum -y install bzip2

安装percona-xtrabackup

xtrabackup8 适用于 mysql8

sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm

sudo percona-release enable-only tools

sudo yum install percona-xtrabackup-80

安装ossutil工具

# 下载并安装
curl -L http://gosspublic.alicdn.com/ossutil/1.6.9/ossutil64 -o /usr/local/bin/ossutil64

# 添加执行权限
chmod +x /usr/local/bin/ossutil64

#查看版本
ossutil64 -v

配置ossutil文件

在配置文件conf/backup.conf中添加ossutil信息

### oss-config
# 阿里云OSS Bucket
oss_bucket = test-data-backup
# 自定义一个命名空间
oos_namespaces = test
# 阿里云OSS Endpoint
oss_endpoint = oss-cn-shenzhen-internal.aliyuncs.com
# 阿里云OSS AccessKeyId
oss_accesskeyid = LTAI3Fm7GEQca5BTBK8Bhqea
# 阿里云OSS AccessKeySecret
oss_accesskeysecret = jCPQ2cgJz3ZfBoc3btdCn2uHgPDdcl
# 阿里云ossutil命令路径
ossutil_bin = /usr/local/bin/ossutil64

ossutil具体使用方法可查看官方文档

使用方法

克隆脚本到本地

git clone https://github.com/jayknoxqu/database-backup.git /usr/local/database-backup

赋予脚本执行权限

chmod +x $(find /usr/local/database-backup -name '*.sh')

使用crontab -e编辑定时任务

# 每天凌晨3点15分执行备份mongodb
15 3 * * * /usr/local/database-backup/mongo/bin/backup.sh >/dev/null 2>&1

# 每天凌晨4点15分执行备份mysql
15 4 * * * /usr/local/database-backup/mysql/bin/backup.sh >/dev/null 2>&1