MaraiDB—— 1.编译安装

最新推荐文章于 2021-08-24 11:56:52 发布

blueicex2020

最新推荐文章于 2021-08-24 11:56:52 发布

阅读量605

点赞数

分类专栏： MariaDB 文章标签： mariadb

本文链接：https://blog.csdn.net/blueicex2017/article/details/104454813

版权

MariaDB 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

编译安装和二进制安装需要重新编写systemctl文件，yum安装不需要，同时帮助文件也需要重新压缩。编译安装需要连网，需要下载源码。

1.安装准备

1.1 生成安装路径

[root@master soft]# mkdir /share/mariadb/mariadb10.5/{logs,etc/my.cnf.d} /share/data/mariadb/mariadb10.5 /share/{boost,cmake,boost} -pv

1.2 yum安装环境

[root@master soft]# yum install -y bison bison-devel boost boost-devel centos-release-scl cmake devtoolset-7 gcc gcc-c++ gnutls-devel jemalloc jemalloc-devel libaio-devel libarchive-devel libcurl-devel libevent-devel libxml2-devel ncurses ncurses-devel openssl openssl-devel zlib zlib-devel pcre pcre-devel

1.3 install cmake

if install require

[root@master soft]# tar xvf cmake-3.11.1.tar.gz  #建议是3.0以上
[root@master soft]# cd cmake-3.11.1/
[root@master cmake-3.11.1]#  ./configure --prefix=/share/cmake/ && gmake && make install && echo $?

1.4 install boost

if install require

[root@master soft]# tar xf boost_1_67_0.tar.gz 
[root@master soft]# cd boost_1_67_0/
[root@master boost_1_67_0]# ls
boost            boostcpp.jam  boost.png      bootstrap.sh  index.htm   INSTALL  libs             more     status
boost-build.jam  boost.css     bootstrap.bat  doc           index.html  Jamroot  LICENSE_1_0.txt  rst.css  tools
#或者安装包拷贝 也可以不安装
[root@master boost_1_67_0]# ./bootstrap.sh
[root@master boost_1_67_0]# ./b2 --prefix=/share/boost && echo $?

1.5 install openssl

if install require

[root@master soft]# tar xf openssl-1.1.0g.tar.gz 
[root@master soft]# mkdir /share/openssl
[root@master soft]# cd openssl-1.1.0g/
[root@master openssl-1.1.0g]# ./config --prefix=/share/openssl && make -j 4 && make install && echo $?

1.6 install pcre

if install require

[root@master soft]# tar xf pcre2-10.30.tar.gz 
[root@master soft]# cd pcre2-10.30/
[root@master pcre2-10.30]# ls 
[root@master pcre2-10.30]# ./configure --prefix=/share/pcre && make -j 4 && make install && echo $?

1.7 添加mariadb用户

可加可不加

[root@master boost_1_67_0]# groupadd -r maridb && useradd -r -g maridb -s /bin/false -d /share/maridb/  -M maridb

2.yum安装

2.1 配置yum源

#官网提供的yum源，不推荐使用，受网络速度限制
[root@master soft]# curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | bash
# 手写yum源
[root@master yum.repos.d]# vim mariadb.repo
[mariadb-10.5]
name=mariadb-10.5
baseurl=http://yum.mariadb.org/10.5/centos/7/aarch64/
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
enabled=1
gpgcheck = 1
[mariadb-10.4]
name=mariadb-10.4
baseurl=http://yum.mariadb.org/10.4/centos/7/aarch64/
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
enabled=1
gpgcheck = 1
[mariadb-10.3]
name=mariadb-10.2
baseurl=http://yum.mariadb.org/10.3/centos/7/aarch64/
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
enabled=1
gpgcheck = 1
[mariadb-10.2]
name=mariadb-10.2
baseurl=http://yum.mariadb.org/10.2/centos/7/aarch64/
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
enabled=1
gpgcheck = 1
[mariadb-10.1]
name=mariadb-10.1
baseurl=http://yum.mariadb.org/10.1/centos/7/aarch64/
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
enabled=1
gpgcheck = 1
[mariadb-10.0]
name=mariadb-10.0
baseurl=http://yum.mariadb.org/10.0/centos/7/aarch64/
enabled=1
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck = 1
[mariadb-tools]
name = MariaDB Tools
baseurl = https://downloads.mariadb.com/Tools/rhel/7Server/x86_64/
gpgcheck = 0
enabled = 1

2.2 yum安装

[root@master soft]# yum install -y rh-mariadb103

3.编译安装

3.1 git源码

#-b参数指定分支 需要参看MariaDB的分支
[root@master soft]# git clone https://github.com/MariaDB/server.git

3.2 make源码

A.查看系统核心数

[root@master soft]# cat /proc/cpuinfo |grep 'processor'|wc -l
8

B.检查cmake版本

[root@master soft]# cmake -version
cmake version 2.8.12.2
[root@master soft]# /share/cmake/bin/cmake -version
cmake version 3.11.1

C.make
Notice:★★
安装过程需要git submoduels，建议下载已经git过的包，解压后，直接安装：
百度网盘： https://pan.baidu.com/s/1giDCQnc3fzmjot98ilc3ng 提取码：fck3
另外，安装磁盘空间要预留10G的安装空间。

[root@master server]# /share/cmake/bin/cmake . -DCOMPILATION_COMMENT="Blueicex compile" -DCMAKE_INSTALL_PREFIX=/share/mariadb/mariadb10.5 -DMYSQL_DATADIR=/share/data/mariadb/mariadb10.5 -DMYSQL_UNIX_ADDR=/share/mariadb/mariadb10.5/etc/mysql.sock -DSYSCONFDIR=/share/mariadb/mariadb10.5/etc -DMYSQL_TCP_PORT=3306 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_XTRADB_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_EXAMPLE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_INNODB_MEMCACHED=ON -DWITH_BOOST=system -DWITH_PCRE=/share/pcre -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=1 -DWITH_EXTRA_CHARSETS=all -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8  -DDEFAULT_COLLATION=utf8_general_ci -DENABLED_LOCAL_INFILE=1 -DWITH_EMBEDDED_SERVER=1 -DWITHOUT_TOKUDB=1 -DMYSQL_USER=root -DWITH_DEBUG=0  && make -j 8 && make install && echo $?
[root@master server]# cd ..
[root@master soft]# mv server mariadb10.5

Notice:★★
编译失败需手动删除CMakeCache.txt

[root@master server]# make clean
[root@master server]# rm -rf CMakeCache.txt

Notice:★★
安装期间，可能会出现下载pcre2的压缩包的问题，需要手动下载，并复制到安装目录中。

[root@master soft]# wget https://ftp.pcre.org/pub/pcre/pcre2-10.34.zip
[root@master soft]# cp pcre2-10.34.zip /share/soft/server/extra/pcre2/src/
cp: overwrite ‘/share/soft/server/extra/pcre2/src/pcre2-10.34.zip’? y

3.3 修改配置文件

Notice:★★
mysql和mysqld要设置一样路径的sock

[root@master bin]# vim /share/mariadb/mariadb10.5/etc/my.cnf
[mysqld]
user=root
port=3306
skip_name_resolve=on
innodb_file_per_table=on
datadir=/share/data/mariadb/mariadb10.5
#mysql和mysqld要设置一样的sock
socket=/share/mariadb/mariadb10.5/etc/mysql.sock 
log-error=/share/mariadb/mariadb10.5/logs/mariadb.log
pid-file=/share/mariadb/mariadb10.5/etc/mariadb.pid
[mysql]
user=root
socket=/share/mariadb/mariadb10.5/etc/mysql.sock
[mysqld_safe]
user=root
log-error=/share/mariadb/mariadb10.5/logs/mariadb.log
pid-file=/share/mariadb/mariadb10.5/etc/mariadb.pid

!includedir /etc/my.cnf.d

[root@master my.cnf.d]# pwd
/share/mariadb/mariadb10.5/etc/my.cnf.d
[root@master my.cnf.d]# cp /share/soft/mariadb10.5/support-files/rpm/*.cnf .
[root@master my.cnf.d]# ls
client.cnf  my.cnf  mysql-clients.cnf  server.cnf

3.4 添加环境变量

[root@master ~]# ln -sf /share/mariadb/mariadb10.5/ /share/lnhome/mariadb
[root@master ~]# echo 'export MARIADB_HOME=/share/lnhome/mariadb' >> /etc/profile
[root@master ~]# echo 'export PATH=$MARIADB_HOME/bin:$PATH' >> /etc/profile
[root@master ~]# echo 'export MARIADB_HOME=/share/lnhome/mariadb' >> ~/.bashrc
[root@master ~]# echo 'export PATH=$MARIADB_HOME/bin:$PATH' >> ~/.bashrc
[root@master ~]# source /etc/profile ~/.bashrc

3.5 更改目录权限

与“1.7 添加mariadb用户”统一起来，可加可不加

[root@master ~]# chown -R maridb:mairdb /share/mariadb
[root@master ~]# chown -R maridb:mairdb /share/data/mariadb

3.6 初始化数据库

Notice:★★
在mariadb的工作目录下运行，否则会报找不到bin的错误。
默认会在/var/lib/mysql下生成数据库文件

[root@master mariadb10.5]# pwd
/share/mariadb/mariadb10.5
[root@master mariadb10.5]# ./scripts/mysql_install_db --datadir=/share/data/mariadb/mariadb10.5 -basedir=/share/mariadb/mariadb10.5
Installing MariaDB/MySQL system tables in '/share/data/mariadb/mariadb10.5' ...
OK

3.7 数据库加固

[root@master mariadb10.5]# mysqld --defaults-file=/share/mariadb/mariadb10.5/etc/my.cnf --user=root &
[root@master mariadb10.5]# ps aux | grep mysqld
root      89602  1.7  0.9 2208472 73788 pts/0   Sl   08:38   0:00 mysqld --defaults-file=/share/mariadb/mariadb10.5/etc/my.cnf --user=root
[root@master mariadb10.5]# mysql_secure_installation 

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!
 ...............

3. 8验证安装

[root@master mariadb10.5]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.5.2-MariaDB Blueicex compile
.................

4.二进制安装

与源码安装雷同，缺少编译源码环节。

5.编写启动文件

5.1 拷贝service服务文件

[root@master mariadb10.5]# killall mysqld
[root@master support-files]# pwd
/share/mariadb/mariadb10.5/support-files
[root@master support-files]# cp mysql.server /etc/init.d/mysqld

5.2 手写systemctl服务文件

[root@master support-files]# vim /usr/lib/systemd/system/mariadb.service 
[Unit]
Description=MariaDB database server
After=network.target
After=syslog.target
[Service]
Type=forking
PIDFile=/share/mariadb/mariadb10.5/etc/mariadb.pid
ExecStart=/etc/init.d/mysqld start
ExecStop=/etc/init.d/mysqld stop
[Install]
WantedBy=multi-user.target

5.3 测试

[root@master mariadb10.5]# vim /etc/my.cnf
!includedir /share/mariadb/mariadb10.5/etc/

[root@master mariadb10.5]# service mysqld status
 ERROR! MariaDB is not running, but lock file (/var/lock/subsys/mysql) exists
[root@master mariadb10.5]# service mysqld start
Starting mysqld (via systemctl):                           [  OK  ]
[root@master mariadb10.5]# service mysqld status
 SUCCESS! MariaDB running (106534)
[root@master mariadb10.5]# service mysqld stop
Stopping mysqld (via systemctl):                           [  OK  ]
[root@master mariadb10.5]# service mysqld status
 ERROR! MariaDB is not running
 
[root@master mariadb10.5]# systemctl daemon-reload
[root@master mariadb10.5]# systemctl start mariadb.service
[root@master mariadb10.5]# systemctl status mariadb.service
● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
   Active: active (running) since Thu 2020-02-27 10:05:44 CST; 8s ago
  Process: 108742 ExecStart=/etc/init.d/mysqld start (code=exited, status=0/SUCCESS)

6.cmake编译选项

Notice:★★
system为采用系统安装路径，可以指定服务安装路径，适时调整。

#编辑注释
-DCOMPILATION_COMMENT="Blueicex compile" 
 #安装根路径
-DCMAKE_INSTALL_PREFIX=/share/mariadb/mariadb10.5      
#数据库存放路径，建议逻辑卷存储
-DMYSQL_DATADIR=/share/data/mariadb/mariadb10.5   
#sock存放路径
-DMYSQL_UNIX_ADDR=/share/mariadb/mariadb10.5/etc/mysql.sock
#配置文件路径
-DSYSCONFDIR=/share/mariadb/mariadb10.5/etc
#TCP/IP端口
-DMYSQL_TCP_PORT=3306  
#数据库innobase引擎
-DWITH_INNOBASE_STORAGE_ENGINE=1    
#数据库archive引擎
-DWITH_ARCHIVE_STORAGE_ENGINE=1 
#数据库blackhole存储引擎
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 
-DWITH_XTRADB_STORAGE_ENGINE=1 
-DWITH_MYISAM_STORAGE_ENGINE=1 
#不使用就是-DWITHOUT
-DWITH_FEDERATED_STORAGE_ENGINE=1
-DWITH_EXAMPLE_STORAGE_ENGINE=1
-DWITH_PARTITION_STORAGE_ENGINE=1
-DWITH_INNODB_MEMCACHED=ON

#-DDOWNLOAD_BOOST=1
-DWITH_BOOST=system          
-DWITH_PCRE=system          	 
 #readline库
-DWITH_READLINE=1  
#系统传输使用SSL加密                                 
-DWITH_SSL=system          
#系统传输使用zlib压缩，节约带宽                       
-DWITH_ZLIB=system 
#libwrap库
-DWITH_LIBWRAP=1 
      
#扩展支持编码 ( all | utf8,gbk,gb2312 | none )      
-DWITH_EXTRA_CHARSETS=all   
#扩展字符支持
-DEXTRA_CHARSETS=all
#字符集utf8
-DDEFAULT_CHARSET=utf8  
#校验字符
-DDEFAULT_COLLATION=utf8_general_ci 
#启用加载本地数据
-DENABLED_LOCAL_INFILE=1           
-DWITH_EMBEDDED_SERVER=1 
#这个参数一般都要设置上，表示不安装tokudb引擎，tokudb是MySQL中一款开源的存储引擎，可以管理大量数据并且有一些新的特性
-DWITHOUT_TOKUDB=1   
#运行用户
-DMYSQL_USER=root
#调试模式
-DWITH_DEBUG=0

-DCOMPILATION_COMMENT="Blueicex compile" -DCMAKE_INSTALL_PREFIX=/share/mariadb/mariadb10.5 -DMYSQL_DATADIR=/share/data/mariadb/mariadb10.5 -DMYSQL_UNIX_ADDR=/share/mariadb/mariadb10.5/etc -DSYSCONFDIR=/share/mariadb/mariadb10.5/etc -DMYSQL_TCP_PORT=3306 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_XTRADB_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_EXAMPLE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_INNODB_MEMCACHED=ON -DWITH_BOOST=system -DWITH_PCRE=system -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=1 -DWITH_EXTRA_CHARSETS=all -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8  -DDEFAULT_COLLATION=utf8_general_ci -DENABLED_LOCAL_INFILE=1 -DWITH_EMBEDDED_SERVER=1 -DWITHOUT_TOKUDB=1 -DMYSQL_USER=root -DWITH_DEBUG=0

7.查找mysql配置文件

这是系统生成的配置文件位置，并不一定存在。

[root@master ~]#  mysqld --verbose --help |grep -A 1 'Default options'
2020-02-26 15:11:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-02-26 15:11:05 0 [Warning] Could not open mysql.plugin table. Some options may be missing from the help text
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf

8.安装脚本

#清理文件
rm -rf /share/mariadb /share/cmake /share/boost /share/openssl /share/pcre /share/soft/mariadb-10.5.1
cp -rpfn /etc/{profile.bak,profile}
cp -rpfn ~/.bashrcbak ~/.bashrc
#yum make clean all
#yum makecache
#ansible node -m copy -a 'dest=/var/cache/ src=/var/cache/yum'

#生成安装目录
mkdir /share/mariadb/mariadb10.5/{logs,etc/my.cnf.d} /share/{lnhome,soft} /share/data/mariadb/mariadb10.5 /share/{boost,cmake,boost} -pv 

#安装附属包
cd /share/soft
wget ftp://ftpuser/cmake-3.11.1.tar.gz
tar xf cmake-3.11.1.tar.gz 
cd cmake-3.11.1
./configure --prefix=/share/cmake/ 
make -j 4
make install 
echo $? 

cd /share/soft
wget ftp://ftpuser/boost_1_67_0.tar.gz
tar xf boost_1_67_0.tar.gz 
cd boost_1_67_0 
./bootstrap.sh 
./b2 --prefix=/share/boost
 echo $? 
 
cd /share/soft
wget ftp://ftpuser/openssl-1.1.0g.tar.gz
tar xf openssl-1.1.0g.tar.gz 
mkdir /share/openssl
cd openssl-1.1.0g 
./config --prefix=/share/openssl
make -j 4 
make install 
echo $? 
   
cd /share/soft
wget ftp://ftpuser/pcre2-10.30.tar.gz
tar xf pcre2-10.30.tar.gz
cd pcre2-10.30
./configure --prefix=/share/pcre
make -j 4
make install
echo $? 

#安装环境包(重点是这里)Notice:★★★★★★★★
yum install -y bison 
yum install -y bison-devel 
yum install -y boost 
yum install -y boost-devel 
yum install -y centos-release-scl 
yum install -y cmake devtoolset-7
yum install -y gcc 
yum install -y gcc-c++ 
yum install -y gnutls-devel 
yum install -y jemalloc 
yum install -y jemalloc-devel 
yum install -y libaio-devel 
yum install -y libarchive-devel 
yum install -y libcurl-devel 
yum install -y libevent-devel 
yum install -y libxml2-devel 
yum install -y ncurses 
yum install -y ncurses-devel 
yum install -y openssl 
yum install -y openssl-devel 
yum install -y zlib 
yum install -y zlib-devel 
yum install -y pcre 
yum install -y pcre-devel 

#下载安装包
cd /share/soft
wget ftp://ftpuser/mariadb-10.5.1.tar.gz
tar xf mariadb-10.5.1.tar.gz

#编译安装
cd mariadb-10.5.1
mkdir /share/soft/mariadb-10.5.1/extra//pcre2/src/ -pv
cd /share/soft/mariadb-10.5.1/extra//pcre2/src/
wget ftp://ftpuser/pcre2-10.34.zip
cd /share/soft/mariadb-10.5.1
/share/cmake/bin/cmake . -DCOMPILATION_COMMENT="Blueicex compile" -DCMAKE_INSTALL_PREFIX=/share/mariadb/mariadb10.5 -DMYSQL_DATADIR=/share/data/mariadb/mariadb10.5 -DMYSQL_UNIX_ADDR=/share/mariadb/mariadb10.5/etc/mysql.sock -DSYSCONFDIR=/share/mariadb/mariadb10.5/etc -DMYSQL_TCP_PORT=3306 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_XTRADB_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_EXAMPLE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_INNODB_MEMCACHED=ON -DWITH_BOOST=system -DWITH_PCRE=/share/pcre -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=1 -DWITH_EXTRA_CHARSETS=all -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8  -DDEFAULT_COLLATION=utf8_general_ci -DENABLED_LOCAL_INFILE=1 -DWITH_EMBEDDED_SERVER=1 -DWITHOUT_TOKUDB=1 -DMYSQL_USER=root -DWITH_DEBUG=0  && make -j 8 && make install && echo $?


#生成my.cnf 
echo '!includedir /share/mariadb/mariadb10.5/etc/'>/etc/my.cnf
cat<<EOF>/share/mariadb/mariadb10.5/etc/my.cnf
[mysqld]
user=root
port=3306
skip_name_resolve=on
innodb_file_per_table=on
datadir=/share/data/mariadb/mariadb10.5
#mysql和mysqld要设置一样的sock
socket=/share/mariadb/mariadb10.5/etc/mysql.sock 
log-error=/share/mariadb/mariadb10.5/logs/mariadb.log
pid-file=/share/mariadb/mariadb10.5/etc/mariadb.pid
[mysql]
user=root
socket=/share/mariadb/mariadb10.5/etc/mysql.sock
[mysqld_safe]
user=root
log-error=/share/mariadb/mariadb10.5/logs/mariadb.log
pid-file=/share/mariadb/mariadb10.5/etc/mariadb.pid

!includedir /etc/my.cnf.d
EOF

#生成ln
ln -sf /share/mariadb/mariadb10.5/ /share/lnhome/mariadb

#生成环境变量
#cp -rpfn /etc/{profile,profile.bak}
#cp -rpfn ~/.bashrc ~/.bashrcbak
echo 'export MARIADB_HOME=/share/lnhome/mariadb' >> /etc/profile
echo 'export PATH=$MARIADB_HOME/bin:$PATH' >> /etc/profile
echo 'export MARIADB_HOME=/share/lnhome/mariadb' >> ~/.bashrc
echo 'export PATH=$MARIADB_HOME/bin:$PATH' >> ~/.bashrc
source /etc/profile ~/.bashrc

#生成数据库文件
cd /share/mariadb/mariadb10.5
./scripts/mysql_install_db --datadir=/share/data/mariadb/mariadb10.5 -basedir=/share/mariadb/mariadb10.5

#安全加固
mysqld --defaults-file=/share/mariadb/mariadb10.5/etc/my.cnf --user=root &
mysql_secure_installation  
killall mysqld

#生成服务文件
cp /share/mariadb/mariadb10.5/support-files/mysql.server /etc/init.d/mysqld
cat<<EOF>/usr/lib/systemd/system/mariadb.service
[Unit]
Description=MariaDB database server
After=network.target
After=syslog.target
[Service]
Type=forking
PIDFile=/share/mariadb/mariadb10.5/etc/mariadb.pid
ExecStart=/etc/init.d/mysqld start
ExecStop=/etc/init.d/mysqld stop
[Install]
WantedBy=multi-user.target
EOF

service mysqld start
service mysqld status
service mysqld stop
service mysqld status
 
#验证安装
systemctl daemon-reload
systemctl start mariadb.service 
systemctl status mariadb.service

#清理文件
cd /share/soft
rm -rf cmake-3.11.1*  boost_1_67_0* openssl-1.1.0g* pcre2-10.30* mariadb-10.5.1*

————Blueicex 2020/2/24 02:52 blueice1980@126.com

blueicex2020

关注

0
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
MaraiDB—— 1.编译安装

编译安装和二进制安装需要重新制作systemctl文件，yum安装不需要，同事帮助文件也需要重新压缩制作。1.安装准备[root@master soft]# mkdir /share/mariadb/{data,log,etc} /share/{boost,cmake,boost} -pv[root@master soft]# yum install -y bison bison-devel...
复制链接

扫一扫

专栏目录