游戏数据库部署脚本

 考虑到游戏批量上线的问题，写了一个游戏mysql的部署脚本，因系统环境一样，所以脚本中并不是去安装mysql，而是将编译好了mysql直接拿过来用

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124

#!/bin/bash # 2013 / 11 / 20 #Email:SongShouJiong@gyyx.cn cat << EOF   ==================================================== |此脚本用于XXXX数据库安装.                  | |-------------------------------------------------- | |程序目录：/usr/local/mysql5. 5                       | |-------------------------------------------------- | |数据目录：/home/mysql/data                         | |-------------------------------------------------- | |脚本运行时间由程序下载速度决定，请耐心等候.......  |   ==================================================== EOF url=http: //XXXXXX #------------------- check disk ------------------------          echo  "------------------------------------------" check_disk(){      if  fdisk -l | grep -q /dev/[sh]db;then          if  df -h | grep -q /data;then              echo  "Partition is ok!"          else              echo  "You must mount /data!"          fi      else          echo  "You must have two disk and mount it!"      fi          echo  "------------------------------------------" }                                                                                                                                                                             #----------------- add user --------------------------- add_user(){          useradd mysql          if  [ $? -eq  0  ];then              echo  "Useradd Mysql Success!"          else              echo  "Mysql User is Exits!!!"          fi          echo  "--------------------------------------------" } #---------------- down install mysql5 and mysql ---------- down_mysql(){          cd /usr/local          wget $url/mysql5.tgz > /dev/ null  2 >& 1          if  [ $? -eq  0  ];then              echo  "Download MysqlServer.tgz Success!"          else              echo  "Download MysqlServer.tgz Error!!!"          fi          echo  "--------------------------------------------"          tar zxvf mysql5.tgz > /dev/ null  2 >& 1          if  [ $? -eq  0  ];then              echo  "Unzip MysqlServer.tgz Success!"          else              echo  "Unzip MysqlServer.tgz Error!!!"                fi          echo  "/usr/local/mysql5.5/bin/mysqld_safe  --defaults-file=/usr/local/mysql5.5/etc/my.cnf --user=mysql &"  >> /etc/rc.local          echo  "--------------------------------------------"      #mkdir -p /data/mysql/          cd /data/          wget $url/mysql.tgz > /dev/ null  2 >& 1          if  [ $? -eq  0  ];then              echo  "Download Mysql_Database Success!"          else              echo  "Download Mysql_Database Error!!!"          fi          echo  "--------------------------------------------"          tar zxvf mysql.tgz > /dev/ null  2 >& 1          if  [ $? -eq  0  ];then              echo  "Unzip Mysql_Database Success!"          else              echo  "Unzip Mysql_Database Error!!"          fi          chown -R mysql.mysql /data/mysql/          ln -s /data/ /home/mysql/          echo  "--------------------------------------------" } #------------------Start Mysql-------------------------- start_mysql(){          /usr/local/mysql5. 5 /bin/mysqld_safe  --defaults-file=/usr/local/mysql5. 5 /etc/my.cnf --user=mysql & > /dev/ null  2 >& 1          sleep  3          a=`netstat -tunpl | grep : 7036  | wc -l`          if  [ $a -gt  0  ];then              echo  "Start Mysql Success!"          else              echo  "Start Mysql Error!"          fi          echo  "--------------------------------------------" } #------------------Create Game Database------------------- create_database(){ #        host=`ifconfig eth0 | grep  "inet addr:"  | awk  '{print $2}'  | cut -d: -f2`          wget $url/DB.sql > /dev/ null  2 >& 1          if  [ $? -eq  0  ];then              echo  "Download DB.sql Success!"          else              echo  "Download DB.sql Error!"          fi              echo  "----------------------------------------"          wget $url/DB2.sql > /dev/ null  2 >& 1          if  [ $? -eq  0  ];then              echo  "Download DB2.sql Success!"          else              echo  "Download DB2.sql Error!!!"          fi              echo  "----------------------------------------"          user=XXXX          passwd=XXXXX          /usr/local/mysql5. 5 /bin/mysql -u${user} -p${passwd} -e "source DB.sql;"          sleep  3          /usr/local/mysql5. 5 /bin/mysql -u${user} -p${passwd} -e "source DB2.sql;"          sleep  3          if  [ $? -eq  0  ];then              echo  "Create Game Database Success!"          else              echo  "Create Game Database Error!"          fi          echo  "---------------------------------------------" } check_disk add_user down_mysql start_mysql create_database

脚本的指定步骤大概是：检测磁盘是否符合数据库挂载要求------>新建mysql用户------>下载mysql程序包并解压------>启动mysql并添加到开机启动------>新建游戏数据库。

本文转自 linuxsong 51CTO博客，原文链接：http://blog.51cto.com/song49/1333221，如需转载请自行联系原作者