去MariaDB官网下载MariaDB本文用的是MariaDB 10.1.16
https://downloads.mariadb.org
选择二进制版本,下载到/root目录下
mariadb-10.1.16-linux-x86_64.tar.gz
开始安装
[root@HE3 ~]# cat mariadb_auto_install.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
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
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
|
###### 二进制自动安装数据库脚本root密码MANAGER将脚本和安装包放在/root目录即可############### ######数据库目录/usr/ local /mysql############ ######数据目录/data/mysql############ ######日志目录/log/mysql############ ######端口号默认3306其余参数按需自行修改############ ################## #author:rrhelei@126.com# ################## #!/bin/bash PATH=/bin:/sbin:/usr/bin:/usr/sbin:/opt/bin:/opt/sbin:~/bin export PATH # Check if user isroot if [ $(id -u) != "0" ]; then echo "Error: You must be root to runthis script, please use root to install" exit 1 fi clear echo "=========================================================================" echo "A tool toauto-compile & install MariaDB-10.1.16 on Redhat/CentOS Linux " echo "=========================================================================" cur_dir=$(pwd) # set mysql rootpassword echo "===========================" mysqlrootpwd= "MANAGER" echo -e "Please input the root password of mysql:" read -p "(Default password: MANAGER):" mysqlrootpwd if[ "$mysqlrootpwd" = "" ]; then mysqlrootpwd= "MANAGER" fi echo "===========================" echo "MySQL root password:$mysqlrootpwd" echo "===========================" #which MySQL Versiondo you want to install? echo "===========================" isinstallmysql56= "n" echo "Install mariadb-10.1.16,Please input y" read -p "(Please input y , n):" isinstallmysql56 case "$isinstallmysql56" in y|Y|Yes|YES|yes|yES|yEs|YeS|yeS) echo "You will install MariaDB 10.1.16" isinstallmysql56= "y" ;; *) echo "INPUT error,You will exit install MariaDB 10.1.16" isinstallmysql56= "n" exit esac get_char() { SAVEDSTTY=`stty-g` stty-echo sttycbreak #ddif=/dev/tty bs=1 count =1 2> /dev/ null stty-raw sttyecho stty$SAVEDSTTY } echo "" echo "Press any key to start...or Press Ctrl+c to cancel" char =`get_char` # Initialize the installation related content. functionInitInstall() { cat/etc/issue uname -a MemTotal=` free -m | grep Mem | awk '{print $2}' ` echo -e "\n Memory is: ${MemTotal} MB " #Settimezone rm -rf /etc/localtime ln -s /usr/share/zoneinfo/Asia/Shanghai /etc/localtime # Delete Old Mysql program rpm -qa|grep mysql rpm -e mysql #DisableSeLinux if[ -s /etc/selinux/config ]; then sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config fi setenforce 0 } #Installation ofdepend on and optimization options. functionInstallDependsAndOpt() { cd $cur_dir cat>>/etc/security/limits.conf<<EOF * soft nproc 65535 * hard nproc 65535 * soft nofile 65535 * hard nofile 65535 EOF echo "fs.file-max=65535" >> /etc/sysctl.conf } #Install MySQL functionInstallMySQL56() { echo "============================Install MariaDB 10.1.16==================================" cd $cur_dir #Backup old my.cnf #rm -f /etc/my.cnf if [ -s /etc/my.cnf]; then mv /etc/my.cnf /etc/my.cnf.` date +%Y%m%d%H%M%S`.bak fi #mysql directoryconfiguration groupadd mysql -g512 useradd -u 512 -gmysql -s /sbin/nologin -d /home/mysql mysql tar xvf/root/mariadb-10.1.16-linux-x86_64.tar.gz mv /root/mariadb-10.1.16-linux-x86_64 /usr/ local /mysql mkdir -p /data/mysql mkdir -p /log/mysql chown -R mysql:mysql/data/mysql chown -R mysql:mysql/usr/ local /mysql chown -R mysql:mysql/log SERVERID=`ifconfigeth0 | grep "inet addr" | awk '{ print $2}' | awk -F. '{ print$4"3306"}' ` cat>>/etc/my.cnf<<EOF [client] port =3306 socket =/tmp/mysql.sock default - character - set =utf8 [mysql] default - character - set =utf8 [mysqld] port =3306 socket =/tmp/mysql.sock basedir =/usr/ local /mysql datadir =/data/mysql open_files_limit = 3072 back_log = 103 max_connections =800 max_connect_errors =100000 table_open_cache =512 external-locking = FALSE max_allowed_packet =32M sort_buffer_size =2M join_buffer_size =2M thread_cache_size =51 query_cache_size =32M tmp_table_size = 96M max_heap_table_size= 96M slow_query_log = 1 slow_query_log_file= /log/mysql/slow.log log-error =/log/mysql/error.log long_query_time = 1 server-id =$SERVERID log-bin =/log/mysql/mysql-bin sync_binlog = 1 binlog_cache_size =4M max_binlog_cache_size= 8M max_binlog_size =1024M expire_logs_days =60 key_buffer_size =32M read_buffer_size =1M read_rnd_buffer_size= 16M bulk_insert_buffer_size= 64M character - set -server=utf8 default -storage-engine= InnoDB binlog_format = row innodb_buffer_pool_dump_at_shutdown= 1 innodb_buffer_pool_load_at_startup= 1 binlog_rows_query_log_events= 1 explicit_defaults_for_timestamp= 1 #log_slave_updates=1 #gtid_mode= on #enforce_gtid_consistency=1 #innodb_write_io_threads= 8 #innodb_read_io_threads= 8 #innodb_thread_concurrency= 0 transaction_isolation= REPEATABLE - READ innodb_additional_mem_pool_size= 16M innodb_buffer_pool_size= 512M #innodb_data_home_dir= innodb_data_file_path= ibdata1:1024M:autoextend innodb_flush_log_at_trx_commit= 1 innodb_log_buffer_size= 16M innodb_log_file_size= 512M innodb_log_files_in_group= 2 innodb_max_dirty_pages_pct= 50 innodb_file_per_table= 1 innodb_locks_unsafe_for_binlog= 0 wait_timeout = 14400 interactive_timeout= 14400 skip- name -resolve [mysqldump] quick max_allowed_packet =32M EOF /usr/ local /mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/data/mysql --defaults-file=/etc/my.cnf--user=mysql cp/usr/ local /mysql/support-files/mysql.server /etc/init.d/mysqld chmod 700 /etc/init.d/mysqld chkconfig --add mysql chkconfig --leve l2345 mysqld on cat >>/etc/ld.so.conf.d/mysql-x86_64.conf<<EOF /usr/ local /mysql/lib EOF ldconfig if [ -d "/proc/vz" ]; then ulimit -s unlimited fi /etc/init.d/mysqldstart cat >>/etc/profile <<EOF export PATH=$PATH:/usr/ local /mysql/bin export LD_LIBRARY_PATH=/usr/ local /mysql/lib EOF /usr/ local /mysql/bin/mysqladmin-u root password $mysqlrootpwd cat >/tmp/mysql_sec_script<<EOF use mysql; delete frommysql. user where user != 'root' or host!= 'localhost' ; flush privileges ; EOF /usr/ local /mysql/bin/mysql-u root -p$mysqlrootpwd -h localhost < /tmp/mysql_sec_script #rm -f/tmp/mysql_sec_script /etc/init.d/mysqldrestart source /etc/profile echo "============================MariaDB 10.1.16 installcompleted=========================" } functionCheckInstall() { echo "===================================== Check install===================================" clear ismysql= "" echo "Checking..." if [ -s/usr/ local /mysql/bin/mysql ] && [ -s /usr/ local /mysql/bin/mysqld_safe ]&& [ -s /etc/my.cnf ]; then echo "MySQL: OK" ismysql= "ok" else echo "Error: /usr/local/mysql notfound!!!MySQL install failed." fi if [ "$ismysql" = "ok" ]; then echo "MariaDB 10.1.16 completed! enjoy it." echo "=========================================================================" netstat -ntl else echo "Sorry,Failed to install MySQL!" echo "You cantail /root/mysql-install.log from your server." fi } #The installationlog InitInstall2>&1 | tee /root/mysql-install.log CheckAndDownloadFiles2>&1 | tee -a /root/mysql-install.log InstallDependsAndOpt2>&1 | tee -a /root/mysql-install.log InstallMySQL562>&1 | tee -a /root/mysql-install.log CheckInstall2>&1 | tee -a /root/mysql-install.log |
[root@HE3 ~]# mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 6
Server version: 10.1.16-MariaDB MariaDB Server
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
至此,mariadb-10.1.16安装成功