欢迎投稿

今日深度:

mariaDB安装,

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

www.htsjk.Com true http://www.htsjk.com/mariadb/33684.html NewsArticle mariaDB安装, MariaDB安装 wget下载一个软件包很慢的话,可以通过-b选项,以后台的方式下载软件包 先解压: [root@shuai-01 src]# tar zxvf mariadb-10.2.6-linux-glibc_214-x86_64.tar.gz 移动并改名: [root...
相关文章
    暂无相关文章
评论暂时关闭