-
Notifications
You must be signed in to change notification settings - Fork 0
/
Mysql5.7_binary_ins.sh
175 lines (156 loc) · 5.22 KB
/
Mysql5.7_binary_ins.sh
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
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
#!/usr/bin/env bash
cat << EOF
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
REQUIRED: centOS-6 (Defulte 64bit)
DESCRIPTION: Install Mysql in CentOS
SOFTVERSION: mysql-5.7.9
AUTHOR: Yangzhiquan
REVISION: 1.2
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
EOF
usage="\033[31mUsage: $0 [mysql3306|mysql3307|mysql3308]\033[0m"
mysql3306_port=3306
mysql3307_port=3307
mysql3308_port=3308
base3306_dir=/app/local/mysql3306
base3307_dir=/app/local/mysql3307
base3308_dir=/app/local/mysql3308
data3306_dir=/app/data/mysqldb3306
data3307_dir=/app/data/mysqldb3307
data3308_dir=/app/data/mysqldb3308
check_dir(){
#检查mysql目录是否存在,$1:baseDir $2:dataDir
echo "开始检测目录"
for dir in $1 $2
do
if [ -d $dir ];then
echo -e "\033[31m${dir}目录已存在,请先确认是否已安装mysql,如果没有安装,请手动删除此目录,并重新运行此程序!\033[0m"
exit 0
else
mkdir -p $dir
echo "${dir}目录已创建完成!"
fi
done
}
check_port(){
#检查mysql端口号是否被占用,$1:MysqlPort
echo "开始检测端口号"
port_nu=` netstat -ntlp | grep $1 |wc -l`
if [ $port_nu -gt 0 ]; then
echo -e "\033[31mInfo: 安装程序已退出，Mysql${1}port 被占用,请确认该端口号\033[0m"
exit 0
else
echo "Mysql ${1} 端口号正常!"
fi
}
check_mysql_user(){
#检查mysql用户是否存在
num1=`id mysql| wc -l`
if [ $num1 -lt 1 ]; then
/usr/sbin/groupadd mysql
/usr/sbin/useradd mysql -g mysql -s /sbin/nologin
echo "Mysql用户已创建完成"
fi
}
develop_install(){
#安装基础开发环境
yum -y install gcc gcc-c++ ncurses-devel wget dos2unix
echo "基础开发环境已安装完成!"
}
get_soft(){
#软件下载
if [ ! -e mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz ]; then
echo "开始下载mysql-5.5.46-2.tar"
wget http://oms.2144gy.com:810/upfiles/soft/mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz
echo "软件下载成功，开始解压配置"
fi
}
Insall(){
#解压编译安装mysql,$1:basedir,$2:datadir
echo "开始解压软件."
tar zxvf mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz
echo "解压已完成。"
mv mysql-5.7.9-linux-glibc2.5-x86_64/* ${1}
echo "目录移动已完成##########################"
chown -R mysql.mysql $1
chown -R mysql.mysql $2
}
import_config(){
#导入my.cnf配置文件以及配置环境变量,$1:MysqlPort,$2:basedir
echo "开始导入my.cnf############################"
wget -P ./mysql57_tmp/ http://oms.2144gy.com:810/upfiles/soft/config/mysql57/my${1}.cnf
wget -P ./mysql57_tmp/ http://oms.2144gy.com:810/upfiles/soft/config/mysql57/mysqld${1}
dos2unix ./mysql57_tmp/mysqld${1}
cp -rf ./mysql57_tmp/my${1}.cnf ${2}/my.cnf
cp -rf ./mysql57_tmp/mysqld${1} /etc/init.d/
rm -rf ./mysql57_tmp/
chmod 755 /etc/init.d/mysqld${1}
chkconfig --add mysqld${1}
echo "mysqld${1}加入开机启动完成"
echo export PATH=\$PATH:${2}/bin >/etc/profile.d/mysql${1}.sh
source /etc/profile
echo "mysql${1}加入环境遍历完成"
}
db_config(){
#配置数据库,$1:baseDir,$2:datadir
mkdir -p ${2}/log
chown -R root.mysql ${1}
chown -R mysql.mysql ${2}
${1}/bin/mysqld --initialize-insecure --basedir=$1 --datadir=${2}/data/ --user=mysql
echo "数据库初始化已完成!#########################"
}
lib_config(){
#导出mysql lib和include文件
echo ${1}/lib > /etc/ld.so.conf.d/mysql${2}.conf
ldconfig
ln -s ${1}/include /usr/include/mysql${2}
echo "mysql${2} lib和include文件都已导出."
}
start_mysql(){
#启动Mysql服务,$1:MysqlPort
/etc/init.d/mysqld${1} start
echo -e "\033[31m安装已全部完成,请执行下面的语句刷新环境变量\033[0m"
echo "source /etc/profile"
}
case $1 in
mysql3306)
check_dir ${base3306_dir} ${data3306_dir}
check_port ${mysql3306_port}
check_mysql_user
develop_install
get_soft
Insall ${base3306_dir} ${data3306_dir} ${mysql3306_port}
import_config ${mysql3306_port} ${base3306_dir}
db_config ${base3306_dir} ${data3306_dir}
lib_config ${base3306_dir} ${mysql3306_port}
start_mysql ${mysql3306_port}
;;
mysql3307)
check_dir ${base3307_dir} ${data3307_dir}
check_port ${mysql3307_port}
check_mysql_user
develop_install
get_soft
Insall ${base3307_dir} ${data3307_dir} ${mysql3307_port}
import_config ${mysql3307_port} ${base3307_dir}
db_config ${base3307_dir} ${data3307_dir}
lib_config ${base3307_dir} ${mysql3307_port}
start_mysql ${mysql3307_port}
;;
mysql3308)
check_dir ${base3308_dir} ${data3308_dir}
check_port ${mysql3308_port}
check_mysql_user
develop_install
get_soft
Insall ${base3308_dir} ${data3308_dir} ${mysql3308_port}
import_config ${mysql3308_port} ${base3308_dir}
db_config ${base3308_dir} ${data3308_dir}
lib_config ${base3308_dir} ${mysql3308_port}
start_mysql ${mysql3308_port}
;;
*)
echo -e $usage
exit 0
;;
esac