1、关闭firewalld和SELinux文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
2、删除CentOS 7.6自带的MariaDB:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# rpm -qa | grep -i mariadb --> mariadb-libs-5.5.60-1.el7_5.x86_64文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
3、如果之前安装过MySQL,也删除:# rpm -qa | grep -i mysql文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
4、删除之前MySQL的配置文件:# rm -rf /etc/my.cnf? # rm -rf /etc/my.cnf.d文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
5、安装编译时需要用到的开发工具软件包组:# yum -y groupinstall "Development Tools"文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
6、安装编译时需要用到的依赖软件包:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# yum -y install epel-release文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# yum -y install zlib-devel libxml2-devel ncurses-devel bison-devel openssl-devel readline-devel libaio-devel boost-devel libcurl-devel libarchive-devel jemalloc-devel libevent-devel lvm2 bzip2-devel ntpdate文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
7、服务器时间同步文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
8、创建逻辑卷,用于存放MariaDB数据:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
(1)虚拟机中新增一块10G的硬盘文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
(2)分区:# fdisk /dev/sdb --> n --> p --> 1 --> 回车 --> 回车 --> t --> 8e --> p --> w --> # partx -a /dev/sdb文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
(3)查看分区情况:# fdisk -l文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
(4)创建pv:# pvcreate /dev/sdb1? # pvs文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
(5)创建vg:# vgcreate data /dev/sdb1? # vgs文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
(6)创建lv:# lvcreate -l +100%FREE data -n mariadb? # lvs文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
(7)创建文件系统:# mke2fs -t ext4 /dev/data/mariadb文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
(8)创建挂载目录:# mkdir -pv /data文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
(9)开机自动挂载:# vim /etc/fstab --> /dev/data/mariadb /data ext4 defaults 0 0文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
(10)挂载分区:# mount -a? # mount文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
(11)查看磁盘使用情况:# df -Th文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
9、创建mariadb用户和组:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# groupadd -r mariadb文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# useradd -r -s /sbin/nologin -g mariadb mariadb文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# id mariadb文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
10、创建MariaDB安装目录:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# mkdir -pv /usr/local/mariadb-10.3.14文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# chown -R mariadb.mariadb /usr/local/mariadb-10.3.14文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
11、在逻辑卷中创建MariaDB数据存放目录:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# mkdir -pv /data/mariadb文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# chown -R mariadb.mariadb /data/mariadb文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# chmod o-rx /data/mariadb文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
12、下载cmake,地址https://cmake.org/download/文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
13、编译安装cmake:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# tar -xf cmake-3.14.3.tar.gz -C /usr/src文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# cd /usr/src/cmake-3.14.3文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# ./bootstrap文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# gmake && gmake install文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# which cmake --> /usr/local/bin/cmake文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# cmake --version文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
备注:yum方式安装的cmake版本为2.8.12文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
14、下载MariaDB 10.3,地址https://downloads.mariadb.org/mariadb/+releases/文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
15、编译安装MariaDB 10.3:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# tar -xf mariadb-10.3.14.tar.gz -C /usr/src文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# cd /usr/src/mariadb-10.3.14文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mariadb-10.3.14 -DMYSQL_DATADIR=/data/mariadb -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DSYSCONFDIR=/etc -DMYSQL_TCP_PORT=3306 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_ARIA_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_CONNECT_STORAGE_ENGINE=1 -DWITH_CSV_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_SEQUENCE_STORAGE_ENGINE=1 -DWITH_SPHINX_STORAGE_ENGINE=1 -DWITH_XTRADB_STORAGE_ENGINE=1 -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci -DEXTRA_CHARSETS=all -DENABLE_PROFILING=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_USER=mariadb -DWITH_CURL=system -DWITH_DEBUG=0 -DWITH_LIBWRAP=0 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# make && make install文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
备注:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
(1)./configure类似于cmake .? ./configure --help类似于cmake . -LH或ccmake .文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
(2)如果想清理此前编译生成的文件,使用命令# make clean和# rm -rf CMakeCache.txt文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
16、初始化MariaDB数据库:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# ll -lh /data/mariadb --> 空文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# /usr/local/mariadb-10.3.14/scripts/mysql_install_db --user=mariadb --datadir=/data/mariadb文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# ll -lh /data/mariadb文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
17、创建配置文件:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# cp /usr/local/mariadb-10.3.14/support-files/wsrep.cnf /etc/my.cnf文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# vim /etc/my.cnf,在[mysqld]配置段中增加如下代码:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
[mysqld]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
port=3306文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
basedir=/usr/local/mariadb-10.3.14文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
datadir=/data/mariadb文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
socket=/tmp/mysql.sock文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
log-error=/var/log/mariadb.log文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
character-set-server=utf8mb4文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
collation-server=utf8mb4_general_ci文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
lower_case_table_names=1文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
innodb_file_per_table=1文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
skip_name_resolve=1文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
symbolic-links=0文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
18、编写unit文件:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# vim /usr/lib/systemd/system/mariadb.service文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
[Unit]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
Description=MariaDB 10.3.14 database server文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
After=syslog.target文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
After=network.target文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
[Service]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
Type=simple文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
User=mariadb文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
Group=mariadb文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
ExecStart=/usr/local/mariadb-10.3.14/bin/mysqld_safe --datadir=/data/mariadb文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
TimeoutSec=300文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
PrivateTmp=false文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
[Install]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
WantedBy=multi-user.target文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# systemctl daemon-reload文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
19、启动MariaDB数据库:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# systemctl start mariadb.service文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# ss -tunlp | grep 3306文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# systemctl enable mariadb.service文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# systemctl status mariadb.service文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
20、配置系统环境变量:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# vim /etc/profile.d/mariadb.sh --> export PATH=/usr/local/mariadb-10.3.14/bin:$PATH文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# . /etc/profile.d/mariadb.sh文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# echo $PATH文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# mysql --version文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
21、MariaDB安全配置向导:# mysql_secure_installation文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
22、配置MariaDB库文件和头文件:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# vim /etc/ld.so.conf.d/mariadb.conf --> /usr/local/mariadb-10.3.14/lib文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# ldconfig文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# ln -sv /usr/local/mariadb-10.3.14/include /usr/include/mysql文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
23、授权用户远程登录:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
# mysql -uroot -p文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
MariaDB> grant all on *.* to 'root'@'%' identified by '123456';文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
MariaDB> flush privileges;文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
24、使用客户端工具Navicat Premium远程连入MariaDB:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html
文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/12982.html