考虑到游戏批量上线的问题，写了一个游戏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，如需转载请自行联系原作者
