Linux Shell经典面试题(其五)

最新推荐文章于 2023-02-22 12:28:28 发布

夕阳雨晴

最新推荐文章于 2023-02-22 12:28:28 发布

阅读量658

点赞数 1

分类专栏： Linux运维 shell脚本浅析文章标签： shell linux shell 面试题

本文链接：https://blog.csdn.net/sun1021873926/article/details/78534557

版权

Linux运维同时被 2 个专栏收录

14 篇文章 0 订阅

订阅专栏

shell脚本浅析

11 篇文章 2 订阅

订阅专栏

Linux Shell经典面试题(其五)

参考：http://jin771998569.blog.51cto.com/2147853/1639712

1.如何实现对MySQL数据库进行分库备份，请用脚本实现。

############mysql的分库备份脚本mysql-differ-database-backups.sh 的脚本编写##############

$ vi mysql-differ-database-backups.sh

#!/bin/bash
MYUSER=root
MYPASS=password
SOCKET="/var/lib/mysql/mysql.sock"
MYCMD="mysql -u$MYUSER -p$MYPASS"
MYDUMP="mysqldump -u$MYUSER -p$MYPASS"
BACKUP_DIR="/work/backup/mysql"

for database in `$MYCMD -e "show database;"|sed '1,2d' | egrep -v "mysql|schema"`
do
    if [! -f $BACKUP_DIR/${database} ];then
        mkdir -p $BACKUP_DIR/${database}
    fi
    $MYDUMP ${database} | gzip > $BACKUP_DIR/${database}_`date +%F`.tar.gz
done

2.如何实现对MySQL数据库进行分库加分表备份，请用脚本实现。

############mysql的分库+分表备份脚本mysql-differ-database-table-backups.sh 的脚本编写##############

$ vi mysql-differ-database-table-backups.sh

#!/bin/bash
MYUSER=root
MYPASS=password
SOCKET="/var/lib/mysql/mysql.sock"
MYCMD="mysql -u$MYUSER -p$MYPASS"
MYDUMP="mysqldump -u$MYUSER -p$MYPASS"
BACKUP_DIR="/work/backup/mysql"

for database in `$MYCMD -e "show database;"|sed '1,2d' | egrep -v "mysql|schema"`
do
    if [! -f $BACKUP_DIR/${database} ];then
        mkdir -p $BACKUP_DIR/${database}
    fi
    $MYDUMP ${database} | gzip > $BACKUP_DIR/${database}_`date +%F`.tar.gz

    for i in $database
        do
            tables=`$MYCMD -e "use $i;show tables;"|sed 1d`
            for j in $tables
                do
                    MYDUMP   -B --databases $i --tables $j > $BACKUP_DIR/${i}-${j}-`date +%F`.sql
                done
        done
done