xtrabackup全备增备以及恢复脚本.txt

chu

467

4页

27次

2024-05-31

5墨值下载

1.全量备份脚本

[root@localhost mysql]# more xtrabackupfull.sh

#!/bin/bash

#远程备份 IP 地址

#back_ip="127.0.0.1"

#主机 ip

#数据库信息

mysql_data_dir="/data/data"

mysql_user="root"

mysql_password="mysql"

mysql_host="127.0.0.1"

mysql_port=3306

#定义备份目录

backup_dir="/home/mysql/back_full"

echo "执行全量备份..."

# 获取当前时间戳

timestamp=$(date +'%Y%m%d%H%M%S')

back_dir="${backup_dir}/${timestamp}"

# 创建备份目录

mkdir -p "$back_dir"

#获取最新的全量备份目录

new_backup_dir=$(ls -1t "$backup_dir" | head -1)

#全量备份目录

full_dir="${backup_dir}/${new_backup_dir}"

#本地打包备份目录

#tar_backup="/home/mysql/full_mysqlbackup"

#mkdir -p $tar_backup

# 执行全量备份

xtrabackup --backup --target-dir="${back_dir}" --user="$mysql_user"

--password="$mysql_password" --host="$mysql_host" --port="$mysql_port"

#echo "压缩最新的全量备份..."

#cd $full_dir

#tar -cvf "${tar_backup}/${timestamp}.tar.gz" $full_dir

#scp ${tar_backup}/${timestamp}.tar.gz $back_ip:$tar_backup

2.增备脚本

[root@localhost mysql]# more xtrabackupinc.sh

#!/bin/bash

# 远程备份 IP 地址

#back_ip="192.168.40.112"

# 数据库信息

mysql_user="root"

mysql_password="mysql"

mysql_host="127.0.0.1"

mysql_port=3306

# 定义增量备份目录

backup_dir="/home/mysql/back_inc"

# 获取上一次的增量备份目录

last_backup_dir=$(ls -1t "$backup_dir" | head -1)

# 如果没有上一次的增量备份目录，那么使用最新的全量备份目录

if [ -z "$last_backup_dir" ]; then

full_back_dir="/home/mysql/back_full/"

last_backup_dir=$(ls -1t "$full_back_dir" | head -1)

backup_type="full_inc"

else

backup_type="inc"

# 获取当前时间戳

timestamp=$(date +'%Y%m%d%H%M%S')

back_dir="${backup_dir}/${timestamp}"

# 创建增量备份目录

mkdir -p "$back_dir"

# 本地打包备份目录

#tar_backup="/opt/${backup_type}_mysqlbackup"

#mkdir -p "$tar_backup"

# 根据备份类型设置备份目录

if [ "$backup_type" = "full_inc" ]; then

backup_basedir="$full_back_dir"

else

backup_basedir="$backup_dir"

# 执行增量备份

xtrabackup --backup --target-dir="${back_dir}" --user="$mysql_user"

--password="$mysql_password" --host="$mysql_host" --port="$mysql_port"

--incremental-basedir="${backup

_basedir}/${last_backup_dir}"

#echo "压缩最新的${backup_type}备份..."

#cd $back_dir

#tar -cvf "${tar_backup}/${timestamp}.tar.gz" $back_dir

#scp ${tar_backup}/${timestamp}.tar.gz $back_ip:$tar_bakup

3.定时任务

0 22 * * 0 sh /root/xtrabackupfull.sh

0 22 * * 1-5 sh /root/xtrabackupinc.sh

50 21 * * 0 rm -rf /home/mysql/back_full/*

50 21 * * 0 rm -rf /home/mysql/back_inc/*

4.全量增量恢复步骤

of 4

5墨值下载

mysql备份数据库运维命令备份恢复

关注

评论