先解压:
[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