最近在搞MySQL，由于经常测试一些东西。因此，就写了一个一键安装脚本。
脚本用途：
|
1
|
用于在CentOS
/RHEL
6.x系统上快速部署出Mysql的单实例或者多实例环境
|
脚本说明：
|
1
2
3
4
|
该脚本运行情况良好
针对脚本中，每一步命令执行的正误判断以及提醒非常醒目，可协助执行者快速定位错误源
脚本诸多内容都以声明变量，增加了脚本的灵活性和扩展性
脚本以做模块化处理，对应功能对应函数，方便SA快速更改和了解该脚本
|
该脚本使用注意事项：
|
1
2
3
4
5
6
|
1、能够通公网或者mysql源码包已经放置到
/usr/local/src
目录下
2、本脚本运行环境要求yum源已经配好
3、注意使用的mysql版本，为了稳定期间，本脚本暂稳定支持5.5以后的mysql源码包。本脚本默认使用5.6.16版本的源码包。如果你需要使用其它版本，请更改MYSQL_SOFT变量以及源码包的下载路径
4、mysql安装默认位置为
/usr/local/mysql
，如需更改请自行修改INSTALL_PATH变量
5、由于我基本每条命令都有做注释，因此其它一些参数的修改，请自己研究，此处不再啰嗦
6、系统环境要求CentOS
/RHEL
6.x版本
|
以下为脚本内容：
|
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
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
|
#!/bin/bash
#
# The script used in CentOS/RHEL 6. X system automatically deploy mysql single instance and multiple instances of the environment
# Written by sunsky
# Mail : nolinux@126.com
# QQ : 274546888
# Date : 2014-7-19 14:23:00
#
.
/etc/init
.d
/functions
tac () {
if
[ $? == 0 ];
then
action
''
/bin/true
else
action
''
/bin/false
fi
}
pre_instance () {
echo
' -- Add MySQL User<1>'
useradd
-r -u 306 mysql;tac
echo
' -- Install Some Packages<1>'
yum
install
wget
make
cmake gcc gcc-c++ ncurses ncurses-devel perl -y &>
/dev/null
;tac
echo
' -- Downloading MySQL<2>'
cd
/usr/local/src
;tac
#wget http://cdn.mysql.com/Downloads/MySQL-5.6/${MYSQL_SOFT}.tar.gz;tac
echo
' -- Unpack the source code package<2>'
tar
-zxf
/usr/local/src/
${MYSQL_SOFT}.
tar
.gz -C
/usr/local/src/
;tac
cd
/usr/local/src/
${MYSQL_SOFT};tac
echo
' -- Install MySQL<3>'
cmake -DCMAKE_INSTALL_PREFIX=$INSTALL_PATH -DINSTALL_DATADIR=$DATA_DIR -DDEFAULT_CHARSET=utf8 -DWITH_EXTRA_CHARSETS=all -DMYSQL_USER=mysql -DDEFAULT_COLLATION=utf8_general_ci &>
/dev/null
;tac
make
&>
/dev/null
;tac
make
install
&>
/dev/null
;tac
echo
' -- Change the directory owner and group<1>'
chown
-R mysql.mysql
/usr/local/mysql
;tac
echo
' -- Create my.cnf<1>'
echo
|
cp
/usr/local/src/
${MYSQL_SOFT}
/support-files/my-default
.cnf
/etc/my
.cnf ;tac
echo
' -- Create Mysqld Scripts<2>'
echo
|
cp
/usr/local/mysql/support-files/mysql
.server
/etc/init
.d
/mysqld
;tac
chmod
+x
/etc/init
.d
/mysqld
;tac
#echo ' -- Start Mysqld Service Test<1>'
#sleep 3
#/etc/init.d/mysqld start > /dev/null;tac
#echo ' -- View MySQL Database Status<1>'
#/etc/init.d/mysqld status | grep "SUCCESS" > /dev/null;tac
#if [ $? == 0 ];then action ' -- MySQL Install Done!' /bin/true;else action ' -- MySQL Install Failed!' false;fi
#action ' -- MySQL Command Global Path<2>'
#echo 'export PATH=/usr/local/mysql/bin/:$PATH' >> /etc/profile;tac
#sleep 1
#source /etc/profile;tac
}
single_instance () {
echo
' -- Initialized MySQL database, the default port 3306<1>'
$INIT_DB --datadir=$DATA_DIR &>
/dev/null
;tac
echo
' -- Start Mysqld Service Test<1>'
/etc/init
.d
/mysqld
start >
/dev/null
;tac
echo
' -- View MySQL Database Status<1>'
/etc/init
.d
/mysqld
status |
grep
"SUCCESS"
>
/dev/null
;tac
if
[ $? == 0 ];
then
action
' -- MySQL Install Done!'
/bin/true
;
else
action
' -- MySQL Install Failed!'
false
;
fi
action
' -- MySQL Command Global Path<2>'
echo
'export PATH=/usr/local/mysql/bin/:$PATH'
>>
/etc/profile
;tac
sleep
1
source
/etc/profile
;tac
}
single_of_multiple () {
action
' -- Add Mysqld_Multi User<2>'
user=
"mysql"
;tac
password=
"sunsky"
;tac
action
' -- Stop MySQL Database<1>'
/etc/init
.d
/mysqld
stop &>
/dev/null
;tac
action
" -- Mysqld_multi Configure<2>"
sed
-i
's/^[^#]/#/g'
/etc/my
.cnf;tac
cat
>
/etc/my
.cnf << EOF
[mysqld_multi]
mysqld =
/usr/local/mysql/bin/mysqld_safe
mysqladmin =
/usr/local/mysql/bin/mysqladmin
user = $user
password = $password
[mysqld3306]
server-
id
= 1
port = 3306
socket =
/tmp/mysql3306
.sock
pid-
file
=
/tmp/mysql3306
.pid
basedir =
/usr/local/mysql
datadir =
/usr/local/mysql/data
key_buffer_size = 16k
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
EOF
tac
echo
' -- prepare my_default_print<1>'
echo
|
cp
/usr/local/mysql/bin/my_print_defaults
/usr/bin/
;tac
sleep
1
action
" -- Initialize multiple instance of the 3306 instance<1>"
echo
' -- Start multiple instances of the 3306 instance<1>'
$MULTI_DB 3306;tac
sleep
5
action
" -- Examples of 3306 authorized users<1>"
$MYSQL_DB -S
/tmp/mysql3306
.sock -e
"grant shutdown on *.* to '$user'@'%' identified by '$password';"
;tac
action
" -- Instance 3306 has user and password to shutdown<1>"
}
multiple_instances () {
user=
"mysql"
password=
"sunsky"
for
port
in
$*;
do
netstat
-lntp |
grep
$port &>
/dev/null
if
[ $? -
eq
0 ];
then
action
" -- Instance $port is running<1>"
else
cat
/etc/my
.cnf |
grep
mysqld${port} >
/dev/null
if
[ $? -
eq
0 ];
then
echo
" -- $port instance is already exists,please input other port number!"
$MULTI_DB $port && action
" -- Instance $port open to complete"
/bin/true
|| action
" -- Instance $port open failed"
/bin/false
else
cat
>>
/etc/my
.cnf << EOF
[mysqld${port}]
server-
id
= $[${port}%3305]
port = ${port}
socket =
/tmp/mysql
${port}.sock
pid-
file
=
/tmp/mysql
${port}.pid
basedir =
/usr/local/mysql
datadir =
/usr/local/mysql/data
${port}
key_buffer_size = 16k
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
EOF
echo
" -- Create $port Instance Datadir<2>"
mkdir
-p ${DATA_DIR}${port};tac
chown
-R mysql.mysql ${DATA_DIR}${port};tac
echo
" -- Initialize multiple instance of the $port instance<1>"
$INIT_DB --datadir=${DATA_DIR}${port} &>
/dev/null
;tac
echo
" -- Start multiple instances of the $port instance<1>"
$MULTI_DB $port && action
" -- Instance $port open to complete"
|| action
" -- Instance $port open failed"
;tac
echo
" -- Examples of $port authorized users"
sleep
3
$MYSQL_DB -S
/tmp/mysql
${port}.sock -e
"grant shutdown on *.* to '$user'@'localhost' identified by '$password';"
&& action
" -- Instance $port has user and password to shutdown"
/bin/true
|| action
" -- Instance $port has user and password to shutdown"
/bin/false
fi
fi
done
}
# MySQL Install Path
INSTALL_PATH=
'/usr/local/mysql'
# MySQL DATA_DR
DATA_DIR=
"$INSTALL_PATH/data"
# MySQL Command Path
INSTALL_DB=
"$INSTALL_PATH/scripts/mysql_install_db"
MYSQL_DB=
"$INSTALL_PATH/bin/mysql"
MYSQL_MULTI=
"$INSTALL_PATH/bin/mysqld_multi"
INIT_DB=
"$INSTALL_DB --user=mysql --basedir=$INSTALL_PATH --defaults-file=/etc/my.cnf"
MULTI_DB=
"$MYSQL_MULTI --defaults-file=/etc/my.cnf start"
MYSQL_SOFT=
'mysql-5.6.16'
case
$
# in
0)
cat
<< EOF
The system administrator, hello!
This is a key to
install
mysql single instance and multiple instances of the script
You can use the name
in
the script with the upper slogans, to define several instances installed!
Example:
[root@sunsky ~]
# bash auto_install_mysql_instance.Sh 3306 3307
Install two mysql instance, port Numbers 3306 and 3307 respectively.
If you are familiar with shell, are
free
to change the script!If you are not familiar with, please
do
not change!
EOF
;;
1)
echo
'> Now begin to single instance database initialization'
echo
'>> STEP ONE : Prepare the MySQL Environment'
pre_instance
echo
'>>> STEP TWO : Install the MySQL single instance'
single_instance
echo
'>>>> SETP THREE : MySQL single instance installation is complete!'
;;
*)
echo
'> Now start multi-instance database initialization'
echo
'>> STEP ONE : Prepare the MySQL Environment'
pre_instance
single_instance
echo
'>>> STEP TWO : Install the MySQL single of multiple instance'
single_of_multiple
echo
'>>>> STEP THREE : Install the MySQL others of multiple instance'
multiple_instances $*
echo
'>>>>> SETP FOUR : MySQL multiple instance installation is complete'
;;
esac
|
以上就是脚本的内容，该脚本主体为5个函数組，分别是tac、pre_instance、single_instance、single_of_multiple和multiple_instances。
|
1
2
3
4
5
|
tac负责做脚本中命令执行的正误判断，方便定位错误源
pre_instance负责准备mysql安装的环境，比如用户创建、相关工具安装、mysql源码包准备、mysql软件安装等
single_instance负责初始化单实例数据库
single_of_multiple负责多实例环境下，对纯单实例的实例做修改
multiple_instances负责创建多实例环境
|
脚本中间声明了若干变量，这里不做介绍!
下面一个case语句用来调度执行我们整个脚本。如果你直接执行脚本，什么都不跟的话，默认会显示出帮助信息。
帮助信息如下：
下面我列举，正常安装单实例
正常多实例安装
希望该脚本能对大家有所帮助！
如果发现脚本里面有什么欠妥当的地方，请及时告知我！谢谢！
本文转自 aaao 51CTO博客，原文链接：http://blog.51cto.com/nolinux/1440414，如需转载请自行联系原作者
