当前位置: > shell编程 >

shell 部署游戏数据库脚本

时间:2014-04-29 02:14来源:linux.it.net.cn 作者:IT网

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

#!/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(){
iffdisk -l | grep -q /dev/[sh]db;then
ifdf -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/null2>&1
if[ $? -eq 0];then
echo "Download MysqlServer.tgz Success!"
else
echo "Download MysqlServer.tgz Error!!!"
fi
echo "--------------------------------------------"
tar zxvf mysql5.tgz > /dev/null2>&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/null2>&1
if[ $? -eq 0];then
echo "Download Mysql_Database Success!"
else
echo "Download Mysql_Database Error!!!"
fi
echo "--------------------------------------------"
tar zxvf mysql.tgz > /dev/null2>&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/null2>&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/null2>&1
if[ $? -eq 0];then
echo "Download DB.sql Success!"
else
echo "Download DB.sql Error!"
fi
echo "----------------------------------------"
wget $url/DB2.sql > /dev/null2>&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并添加到开机启动------>新建游戏数据库。

脚本仅供参考,如果您有什么好的建议或者意见,欢迎您Send mail:SongShouJiong@gyyx.cn.

本文出自 “我的未来不是梦。” 博客,请务必保留此出处http://song49.blog.51cto.com/4480450/1333221

(责任编辑:IT)
------分隔线----------------------------
栏目列表
推荐内容