K8s中备份数据检查验证（一）

最新推荐文章于 2024-10-14 16:29:35 发布

原创最新推荐文章于 2024-10-14 16:29:35 发布 · 414 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#备份验证 #K8s数据检查

运维同时被 2 个专栏收录

12 篇文章

订阅专栏

K8s

8 篇文章

订阅专栏

本文介绍了一种针对Kubernetes环境中MySQL、MongoDB、Redis及Etcd数据库的备份验证脚本。该脚本运行于K8s的master节点，通过对比现运行数据与备份数据，确保备份的完整性和有效性。

对k8s中备份的数据进行验证，对比现k8s运行中的数据与备份的数据，检查是否备份异常。

脚本包括对K8s中的mysql,mongodb,redis及etcd四种数据库的现行状态及备份检查。

脚本运行在K8s中的master主机中。

bak 目录：里边的备份数据是从K8s中各个备份点 scp 或 rsync到此目录中。

dbtmp目录：验证过程中自动生成的验证的数据文件。

直接运行./check.sh就可以生成 .md格式的验证结果。

如下是check.sh代码：

#!/bin/bash

#运行目录
rundir=$(cd $(dirname $0); pwd)
#格式化当前日期
theday=`date +%F`

outmd=${rundir}/check-out-${theday}.md

echo "# 备份验证-${theday}" > ${outmd}

echo -e "\e[92m 开始iotplat-Mysql数据库检查... \e[0m" 

echo "## iotplat-Mysql" >> ${outmd}
echo "--------------------------" >> ${outmd}
echo "> 当前系统的数据" >> ${outmd}
echo " " >> ${outmd}
echo " \`\`\` " >> ${outmd}

#./status-mysql.sh mysql-0 -n default  >> ${outmd}
./status-mysql-iotplat.sh >> ${outmd}

echo " \`\`\` " >> ${outmd}

echo "> 备份的数据" >> ${outmd}
echo " " >> ${outmd}
echo " \`\`\` " >> ${outmd}

# ./mysql-check.sh /home/mysql-iotplat.tar.gz >> ${outmd}
./mysql-check-iotplat.sh  >> ${outmd}

echo " \`\`\` " >> ${outmd}

cat -n ${rundir}/check-out-${theday}.md
echo -e "\e[92m 开始s1plat-Mysql数据库检查... \e[0m"

echo "## s1plat-Mysql" >> ${outmd}
echo "--------------------------" >> ${outmd}
echo "> 当前系统的数据" >> ${outmd}
echo " " >> ${outmd}
echo " \`\`\` " >> ${outmd}

#./status-mysql.sh mysql-0 -n default  >> ${outmd}
./status-mysql-s1plat.sh >> ${outmd}

echo " \`\`\` " >> ${outmd}

echo "> 备份的数据" >> ${outmd}
echo " " >> ${outmd}
echo " \`\`\` " >> ${outmd}

# ./mysql-check.sh /home/mysql-s1plat.tar.gz >> ${outmd}
./mysql-check-s1plat.sh  >> ${outmd}

echo " \`\`\` " >> ${outmd}
echo "--------------------------" >> ${outmd}

cat -n ${rundir}/check-out-${theday}.md
echo -e "\e[92m 开始iotplat-Redis数据库检查... \e[0m"

echo "## iotplat-Redis" >> ${outmd}
echo "--------------------------" >> ${outmd}

echo "> 当前系统的数据" >> ${outmd}
echo " " >> ${outmd}
echo " \`\`\` " >> ${outmd}
#./status-mysql.sh mysql-0 -n default  >> ${outmd}
./status-redis-iotplat.sh >> ${outmd}

echo " \`\`\` " >> ${outmd}

echo "> 备份的数据" >> ${outmd}
echo " " >> ${outmd}
echo " \`\`\` " >> ${outmd}

./redis-check-iotplat.sh  >> ${outmd}

echo " \`\`\` " >> ${outmd}


cat -n ${rundir}/check-out-${theday}.md
echo -e "\e[92m 开始s1plat-Redis数据库检查... \e[0m"

echo "## s1plat-Redis" >> ${outmd}
echo "--------------------------" >> ${outmd}

echo "> 当前系统的数据" >> ${outmd}
echo " " >> ${outmd}
echo " \`\`\` " >> ${outmd}
#./status-mysql.sh mysql-0 -n default  >> ${outmd}
./status-redis-s1plat.sh >> ${outmd}

echo " \`\`\` " >> ${outmd}

echo "> 备份的数据" >> ${outmd}
echo " " >> ${outmd}
echo " \`\`\` " >> ${outmd}

# ./mysql-check.sh /home/mysql.tar.gz >> ${outmd}
./redis-check-s1plat.sh  >> ${outmd}

echo " \`\`\` " >> ${outmd}

echo "--------------------------" >> ${outmd}


cat -n ${rundir}/check-out-${theday}.md
echo -e "\e[92m 开始ehome-MongoDB数据库检查... \e[0m"

echo "## ehome-MongoDB" >> ${outmd}
echo "--------------------------" >> ${outmd}
echo "> 当前系统的数据" >> ${outmd}
echo " " >> ${outmd}
echo " \`\`\` " >> ${outmd}

#./status-mysql.sh mysql-0 -n default  >> ${outmd}
./status-mongodb.sh >> ${outmd}

echo " \`\`\` " >> ${outmd}

echo "> 备份的数据" >> ${outmd}
echo " " >> ${outmd}
echo " \`\`\` " >> ${outmd}

# ./mysql-check.sh /home/mysql.tar.gz >> ${outmd}
./mongodb-check.sh  >> ${outmd}

echo " \`\`\` " >> ${outmd}
echo "--------------------------" >> ${outmd}

cat -n ${rundir}/check-out-${theday}.md
echo -e "\e[92m 开始Etcd数据库检查... \e[0m"

echo "## Etcd" >> ${outmd}
echo "--------------------------" >> ${outmd}
echo "> 当前系统的数据" >> ${outmd}
echo " " >> ${outmd}
echo " \`\`\` " >> ${outmd}

./status-etcd.sh >> ${outmd}

echo " \`\`\` " >> ${outmd}

echo "> 备份的数据" >> ${outmd}
echo " " >> ${outmd}
echo " \`\`\` " >> ${outmd}

# ./mysql-check.sh /home/mysql.tar.gz >> ${outmd}
./etcd-check.sh  >> ${outmd}

echo " \`\`\` " >> ${outmd}
echo "--------------------------" >> ${outmd}
cat -n ${rundir}/check-out-${theday}.md

echo -e "\e[92m 检查完成！ \e[0m"

运行后输出的结果.md如下：