服务器之家:专注于服务器技术及软件下载分享
分类导航

Mysql|Sql Server|Oracle|Redis|MongoDB|PostgreSQL|Sqlite|DB2|mariadb|Access|数据库技术|

服务器之家 - 数据库 - MongoDB - Linux服务器下MariaDB 10自动化安装部署

Linux服务器下MariaDB 10自动化安装部署

2020-05-07 16:00MongoDB教程网 MongoDB

这篇文章主要介绍了Linux服务器下MariaDB 10自动化安装部署,需要的朋友可以参考下

去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安装成功

延伸 · 阅读

精彩推荐
  • MongoDBmongodb数据库基础知识之连表查询

    mongodb数据库基础知识之连表查询

    这篇文章主要给大家介绍了关于mongodb数据库基础知识之连表查询的相关资料,文中通过示例代码介绍的非常详细,对大家学习或者使用mongodb具有一定的参...

    ZJW02155642020-05-22
  • MongoDBMongoDB系列教程(五):mongo语法和mysql语法对比学习

    MongoDB系列教程(五):mongo语法和mysql语法对比学习

    这篇文章主要介绍了MongoDB系列教程(五):mongo语法和mysql语法对比学习,本文对熟悉Mysql数据库的同学来说帮助很大,用对比的方式可以快速学习到MongoDB的命...

    MongoDB教程网3252020-05-01
  • MongoDB在mac系统下安装与配置mongoDB数据库

    在mac系统下安装与配置mongoDB数据库

    这篇文章主要介绍了在mac系统下安装与配置mongoDB数据库的操作步骤,有需要的朋友可以借鉴参考下,希望能够有所帮助,祝大家多多进步,早日升职加薪...

    CXYhh1219312021-11-14
  • MongoDBWindows下MongoDB配置用户权限实例

    Windows下MongoDB配置用户权限实例

    这篇文章主要介绍了Windows下MongoDB配置用户权限实例,本文实现需要输入用户名、密码才可以访问MongoDB数据库,需要的朋友可以参考下 ...

    MongoDB教程网3082020-04-29
  • MongoDBMongoDB查询之高级操作详解(多条件查询、正则匹配查询等)

    MongoDB查询之高级操作详解(多条件查询、正则匹配查询等)

    这篇文章主要给大家介绍了关于MongoDB查询之高级操作(多条件查询、正则匹配查询等)的相关资料,文中通过示例代码介绍的非常详细,对大家的学习或者...

    w田翔3872020-12-19
  • MongoDBMongoDB多条件模糊查询示例代码

    MongoDB多条件模糊查询示例代码

    这篇文章主要给大家介绍了关于MongoDB多条件模糊查询的相关资料,文中通过示例代码介绍的非常详细,对大家学习或者使用MongoDB具有一定的参考学习价值...

    浅夏晴空5902020-05-25
  • MongoDBMongodb索引的优化

    Mongodb索引的优化

    MongoDB 是一个基于分布式文件存储的数据库。由 C++ 语言编写。接下来通过本文给大家介绍Mongodb索引的优化,本文介绍的非常详细,具有参考借鉴价值,感...

    MRR3252020-05-05
  • MongoDBMongoDB的索引

    MongoDB的索引

    数据库中的索引就是用来提高查询操作的性能,但是会影响插入、更新和删除的效率,因为数据库不仅要执行这些操作,还要负责索引的更新 ...

    MongoDB教程网2532020-05-12