[MariaDB] MariaDB 10.1 Installation on CentOS 7(Source Compile)

1. 사전 준비

# yum -y install net-tools setuptool wget vim-enhanced lrzsz xinetd gcc gcc-c++ ncurses ncurses-devel bison
# yum -y install cmake openssl openssl-devel \
                 libtermcap libtermcap-devel gdbm-devel \
                 zlib* libxml* freetype* libpng* libjpeg* gd gd-dev \
                 libmcrypt libmcrypt-devel mhash mhash-devel apr apr-* libxml2 \
                 iconv unixODBC readline-devel \
                 qpixman qpixman-devel netpbm* libxslt* gmp gmp-devel \
                 bzip2-devel openssl-devel pcre-devel curl curl-devel \
                 libmcrypt libmcrypt-devel mhash mhash-devel enchant-devel enchant \
                 libicu libicu-devel
# yum remove mariadb-libs mysql-libs

 

2. MariaDB 10.1 Source Download : https://downloads.mariadb.com/MariaDB/mariadb-10.1.44/source/

MariaDB/mariadb-10.1.44/source/ - MariaDB

# wget https://downloads.mariadb.com/MariaDB/mariadb-10.1.44/source/mariadb-10.1.44.tar.gz

 

3. 압축 해제, 유저/그룹 생성 및 컴파일, 인스톨 실행

# tar xzvf mariadb-10.1.44.tar.gz

# groupadd -g 940 mysql
# useradd -g mysql -u 1200 -s /sbin/nologin -M mysql

# mkdir build-mariadb
# cd build-mariadb

# cmake ../mariadb-10.1.44 \
-DCMAKE_INSTALL_PREFIX=/app/mysql \
-DMYSQL_DATADIR=/data/mysql/data \
-DINSTALL_SYSCONFDIR=/etc \
-DINSTALL_SYSCONF2DIR=/etc/my.cnf.d \
-DMYSQL_TCP_PORT=3306 \
-DWITH_READLINE=1 \
-DWITH_SSL=bundled \
-DWITH_ZLIB=system \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_EXTRA_CHARSETS=all \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=../boost_1_59_0 \
-DWITH_ARIA_STORAGE_ENGINE=1 \
-DWITH_XTRADB_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_FEDERATEDX_STORAGE_ENGINE=1 \
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \
-DSYSCONFDIR=/etc \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock

# make -j `grep processor /proc/cpuinfo' | wc -l`
# make install

 

4. Database 생성 및 파일시스템 권한 변경

# cd /app/mysql/
# ./scripts/mysql_install_db --user=mysql --basedir=/app/mysql --datadir=/data/mysql/data
# chown -R mysql.mysql /app/mysql
# chown -R mysql.mysql /data/mysql

 

5. 서비스 등록 및 실행

# vi /usr/lib/systemd/system/mariadb.service
[Unit]
Description=mariadb-10.1.44
After=syslog.target network.target

[Service]
Type=forking
User=mysql
Group=mysql
ExecStart=/app/mysql/support-files/mysql.server start
ExecStop=/app/mysql/support-files/mysql.server stop

[Install]
WantedBy=multi-user.target

저장

 

# firewall-cmd --permanent --zone=public --add-port=3306/tcp
# firewall-cmd --reload
# systemctl start mariadb.service

 

6.  명령어 심볼릭 링크 생성

# ln -s /app/mysql/bin/mysql /usr/bin/mysql
# ln -s /app/mysql/bin/mysqladmin /usr/bin/mysqladmin

 

7. database root 유저 패스워드 설정 및 접속 확인

# mysqladmin -u root password

# mysql -u root -p
MariaDB> show databases;

 

8. 별도 관리계정 생성(외부접속 권한 포함)

MariaDB> GRANT ALL PRIVILEGES ON *.* TO 'myadmin'@'localhost' IDENTIFIED BY 'YOUR_PASSWORD';
MariaDB> GRANT ALL PRIVILEGES ON *.* TO 'myadmin'@'%' IDENTIFIED BY 'YOUR_PASSWORD';
MariaDB> flush privileges;

 

참고: https://skibis.tistory.com/292

Cent OS 7 MariaDB 10.0.31 소스 컴파일

       https://xinet.kr/?p=1494

CentOS 7 APM 최신버전 설치 ( apache php mariadb ) 컴파일 설치 ( comfile install)

      https://conory.com/blog/43046

[문제해결 일지] systemctl start mariadb 실행시 Failed to issue method call: No such file or directory. 에러