mariaDB安装

MariaDB安装

wget下载一个软件包很慢的话，可以通过-b选项，以后台的方式下载软件包

先解压：

[root@shuai-01 src]# tar zxvf mariadb-10.2.6-linux-glibc_214-x86_64.tar.gz 

移动并改名：

[root@shuai-01 src]# mv mariadb-10.2.6-linux-glibc_214-x86_64 /usr/local/mariadb

安装mariadb，指定用户，指定目录：

[root@shuai-01 mariadb]# ./scripts/mysql_install_db --user=mysql --datadir=/data/mariadb

[root@shuai-01 mariadb]# echo $?
0

拷贝配置文件：

[root@shuai-01 mariadb]# ls support-files/
binary-configure        my-large.cnf         mysql-log-rotate  wsrep_notify
magic                   my-medium.cnf        mysql.server
my-huge.cnf             my-small.cnf         policy
my-innodb-heavy-4G.cnf  mysqld_multi.server  wsrep.cnf

有好几个配置文件，根据内存大小选择

[root@shuai-01 mariadb]# cp support-files/my-small.cnf /usr/local/mariadb/my.cnf

拷贝启动脚本：

[root@shuai-01 mariadb]# cp support-files/mysql.server /etc/init.d/mariadb

编辑配置文件和启动脚本：
启动脚本
basedir=/usr/local/mariadb datadir=/data/mariadb
conf=/usr/local/mariadb/my.cnf
conf配置文件所在的路径

# If you change base dir, you must also change datadir. These may get
# overwritten by settings in the MySQL configuration files.

basedir=/usr/local/mariadb
datadir=/data/mariadb
conf=/usr/local/mariadb/my.cnf

# Default value, in seconds, afterwhich the script should timeout waiting
# for server start.

在脚本中指定一下配置文件的路径

启动之前，先看MySQL数据库启动没有，启动了要关掉，不然有冲突。

启动mariadb：

[root@shuai-01 mariadb]# /etc/init.d/mariadb start
Reloading systemd:                                         [  确定  ]
Starting mariadb (via systemctl):                          [  确定  ]
[root@shuai-01 mariadb]# ps aux |grep mariadb
root       4778  0.2  0.1 115392  1752 ?        S    22:49   0:00 /bin/sh /usr/local/mariadb/bin/mysqld_safe --defaults-file=/usr/local/mariadb/my.cnf --datadir=/data/mysql --pid-file=/data/mysql/shuai-01.pid
mysql      4894  7.8  5.7 1125132 57872 ?       Sl   22:49   0:02 /usr/local/mariadb/bin/mysqld --defaults-file=/usr/local/mariadb/my.cnf --basedir=/usr/local/mariadb --datadir=/data/mysql --plugin-dir=/usr/local/mariadb/lib/plugin --user=mysql --log-error=/data/mysql/shuai-01.err --pid-file=/data/mysql/shuai-01.pid --socket=/tmp/mysql.sock --port=3306
root       4942  0.0  0.0 112676   976 pts/0    R+   22:49   0:00 grep --color=auto mariadb