課時7-備份與恢復----資料庫備份策略指令碼

小亮520cl發表於2015-11-24
資料庫指令碼
一個指令碼

  1. #!/bin/bash
  2. export LANG=en_US.UTF-8
  3. export LC_CTYPE="zh_CN.UTF-8"

  5. function usage()
  6. {
  7. cat << EOF
  8. Usage: $0 [OPTION]
  9.     -?,--help show this help and exit
  10.     --user=<> set the username to connect the mysql
  11.     --password=<> set the password to connect the mysql
  12.     --backuptype=<> set the type of backup,such as DATA_FULL,DATA_INC
  13.     --defaults-file=<> set the config file
  14.     --backup_path=<> set the remote host by formate name@host
  15.     --innoback=<> set the full path of the innoback
  16.     --xtraback=<> set the full path of the xtraback
  17. EOF
  18. }

  20. function get_option()
  21. {
  22.         echo "$1" | sed 's/=[/a-zA-Z0-9]*$//' | sed 's/^--//' | tr '[a-z]' '[A-Z]'
  23. }

  25. function get_option_value()
  26. {
  27.         echo "$1" | sed 's/^--[a-zA-Z_-]*=//'
  28. }


  31. function parse_option()
  32. {
  33.         while test $# -gt 0
  34.         do
  35.                 case $1 in
  36.                         --user=*)
  37.                         USER=`get_option_value "$1"`
  38.                         echo "USER : $USER"
  39.                         ;;
  40.                         --password=*)
  41.                         PASSWORD=`get_option_value "$1"`
  42.                         echo "PASSWORD : $PASSWORD"
  43.                         ;;
  44.                         --backup_path=*)
  45.                         BACKUP_PATH=`get_option_value "$1"`
  46.                         echo "BACKUP_PATH : $BACKUP_PATH"
  47.                         ;;
  48.                         --defaults-file=*)
  49.                         MYCNF=`get_option_value "$1"`
  50.                         echo "MYCNF : $MYCNF"
  51.                         ;;
  52.                         --backuptype=*)
  53.                         BACKUPTYPE=`get_option_value "$1"`
  54.                         echo "BACKUPTYPE : $BACKUPTYPE"
  55.                         ;;
  56.                         --innoback=*)
  57.                         INNOBACK=`get_option_value "$1"`
  58.                         #echo "INNOBACK : $INNOBACK"
  59.                         ;;
  60.                         --xtraback=*)
  61.                         XTRABACK=`get_option_value "$1"`
  62.                         #echo "XTRABACK : $XTRABACK"
  63.                         ;;
  64.                         -?|--help)
  65.                         usage
  66.                         exit 0
  67.                         ;;
  68.                         *)
  69.                         echo "Unknown option '$1'"
  70.                         ;;
  71.                 esac
  72.                 shift
  73.         done
  74. }

  76. back_full()
  77. {
  78.    parse_option
  79.    $INNOBACK --user=$USERNAME --password=$PASSWORD --defaults-file=$MYCNF --no-timestamp $DATA_FULL/base$DATE
  80. 2> $DATA_FULL/timestamp$DATE.log
  81.    grep 'INNOBACKupex: completed OK!' $DATA_FULL/timestamp$DATE.log
  82. }

  84. back_inc()
  85. {
  86.         parse_option
  87.         $XTRABACK --defaults-file=$MYCNF --user=$USERNAME --password=$PASSWORD --backup --target-dir=$DATA_I
  88. NC/base_inc$DAY --incremental-basedir=$DATA_FULL/base`date -d "$DAY days ago" +%F` 2> $DATA_INC/timestamp$DATE
  89. _inc.log
  90. }
  91. # XTRABACKup conf
  92. MYCNF=/home/data/mydata/3308/my.cnf
  93. USERNAME=root
  94. PASSWORD=ESBecs00
  95. BACKUP_PATH=/xback
  96. DATA_FULL=$BACKUP_PATH/back_data_full
  97. DATA_INC=$BACKUP_PATH/back_data_inc
  98. INNOBACK=/usr/bin/innobackupex
  99. XTRABACK=/usr/bin/xtrabackup

  101. mkdir -p $DATA_FULL $DATA_INC

  103. DAY=`date +%w`
  104. echo $DAY
  105. #0
  106. DATE=`date +%F`
  107. echo $DATE
  108. #2015-11-22
  109. case $DAY in
  110.     0)
  111.         # Sunday Full backup
  112.         back_full
  113.         ;;
  114.     1)
  115.         # Monday Relatively Sunday's incremental backup
  116.         back_inc
  117.         ;;
  118.     2)
  119.         # Tuesday Compared with Monday's incremental backup
  120.         back_inc
  121.         ;;
  122.     3)
  123.         # Wednesday Full backup
  124.         back_inc
  125.         ;;
  126.     4)
  127.         # Thursday Relatively Wednesday's incremental backup
  128.         back_inc
  129.         ;;
  130.     5)
  131.         # Friday Compared with Thursday's incremental backup
  132.         back_inc
  133.         ;;
  134.     6)
  135.         # Saturday Compared with Friday
  136.         back_inc
            ;;
    esac


點評：有備份策略，程式碼邏輯也比較完善。

點評：備份邏輯完整，但是沒有體現備份策略和自動化。

點評：很多人都直接借用了，不得不說好。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29096438/viewspace-1845248/，如需轉載，請註明出處，否則將追究法律責任。

相關文章