mariaDB安装

MariaDB安装

先解压：

[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_notifymagic                   my-medium.cnf        mysql.servermy-huge.cnf             my-small.cnf         policymy-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/mariadbdatadir=/data/mariadbconf=/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 startReloading systemd:                                         [  确定  ]Starting mariadb (via systemctl):                          [  确定  ][root@shuai-01 mariadb]# ps aux |grep mariadbroot       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.pidmysql      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=3306root       4942  0.0  0.0 112676   976 pts/0    R+   22:49   0:00 grep --color=auto mariadb