5.备份 | Evergreen Notes

数据备份

1.数据库备份

SHELL

[root@database_bak scripts]# cat back_mysql.sh 
#!/bin/bash
 
bak_dir='/opt/bak'
conf_file='/root/scripts/mysql_info'
server_num=`cat ${conf_file} | wc -l`
backup_time=`date +"%y-%m-%d"`
 
cd /root/scripts/
mkdir -p /opt/bak/${backup_time}
 
for i in `seq ${server_num}`;
do
        host=`cat ${conf_file} | awk 'NR=="'$i'" {print $1}'`
        user=

SHELL

2.网络设备备份

PYTHON

[root@database_bak scripts]# cat mysql_info
10.10.8.158 root 2A] tomatsbi_prod
10.10.8.110 root @ v60
10.10.8.110 root @ bi
10.10.8.157 root 2A] dw_amcs
10.10.8.176 root ! portal
10.10.8.180 root !ams23 ams
10.10.8.105 root QAl03vP3 ecology
10.10.8.193 dwh yxUE9 yxUE9KKMd5J!
10.10.8.88 root OP- C7A6EF8A5E414164B517024D8C87B292
10.10.8.88 root OP-1 yundong-flowable
10.10.8.88 root OP-2021 usercenter
 
 /root/scripts/back_mysql.sh > /root/scripts/log/run_bak_mysql.log 2>&1

30 7 * * 5 /home/backup/network/exec_backup_switch.sh > /home/backup/network/exec_backup_switch.logs 2>&1
 
[root@database_bak network]# cat cat exec_backup_switch.sh 
cat: cat: No such file or directory
#!/bin/bash
 
 
if [[ -L "$0" ]]; then
    script_path=$(readlink -f "$0")
else
    script_path="$0"
fi
 
script_dir=$(dirname