Mariadb 설치

OS : CeontOS7

Mariadb version : 10.2.13

 

*mariadb 10.3 의 경우, cmake 버전이 3.3.24로 진행해야함 

 

# 필수 라이브러리 설치
yum -y install gcc gcc-c++ libtermcap-devel gdbm-devel zlib* libxml* freetype* libpng* libjpeg* iconv flex gmp ncurses-devel libaio gnutls-devel

# cmake 에러 발생시
wget https://cmake.org/files/v3.3/cmake-3.3.2.tar.Z
cd cmake-3.3.2
./bootstrap
make
make install
cmake -version 

tar xvfz mariadb-10.2.13.tar.gz 
# 소스컴파일 
cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mariadb \
-DMYSQL_DATADIR=/usr/local/mariadb/data \
-DMYSQL_TCP_PORT=3306 \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DWITH_READLINE=1 \
-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 \
-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 

make
make install

groupadd -g 500 mysql
useradd -u500 -g500 -d /usr/local/mariadb -s /bin/false mysql

cp -arp /usr/local/mariadb/support-files/my-huge.cnf /etc/my.cnf

/usr/local/mariadb/scripts/mysql_install_db --user=mysql  --basedir=/usr/local/mariadb --datadir=/usr/local/mariadb/data

chmod 711 /usr/local/mariadb
chmod 700 /usr/local/mariadb/data
chmod 751 /usr/local/mariadb/bin
chmod 750 /usr/local/mariadb/bin/*
chmod 755 /usr/local/mariadb/bin/mysql
chmod 755 /usr/local/mariadb/bin/mysqldump
chmod 700 /usr/local/mariadb/support-files/mysql.server

echo “/usr/local/mariadb/lib” > /etc/ld.so.conf.d/mysql.conf

/usr/local/mariadb/bin/mysqladmin -u root password '패스워드'

#심볼릭링크 생성
ln -s /usr/local/mariadb/bin/mysql /usr/sbin/mysql
ln -s /usr/local/mariadb/bin/mysqldump /usr/sbin/mysqldump 
ln -s /usr/local/mariadb/bin/mysql_config /usr/sbin/mysql_config
ln -s /usr/local/mariadb/bin/mysqladmin /usr/sbin/mysqladmin

chown -R mysql.mysql /usr/local/mariadb

#systemctl 서비스 등록 

----------------------------------------------------------------------------
vi /etc/systemd/system/mariadb.service
[Unit]
Description=mariadb
After=syslog.target network.target

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

[Install]
WantedBy=multi-user.target
----------------------------------------------------------------------------

systemctl enable mariadb