#############################
	#		custom install		#
	#############################

os : rocky linux 8.4
DBversion : 10.9.8  /  11.5.2

=====================================================================================
## Installation preset
=====================================================================================
yum install -y libncurses*

groupadd mysql
useradd -g mysql mysql
passwd mysql
mysql

export maria_zip=mariadb-11.5.2-linux-systemd-x86_64.tar.gz
export maria_dir=mariadb-11.5.2-linux-systemd-x86_64
export basedir=/u01/mysqlA
export datadir=/usr/service/mariadb/11.5.2/data
export logdir=/usr/service/mariadb/11.5.2/log

cat >> ~/.bash_profile <<eof
export MARIADB_HOME=$basedir
export MARIA_DATA=$datadir
export PATH=\$PATH:\$MARIADB_HOME/bin:\$MARIADB_HOME/scripts:\$MARIA_DATA
eof

. ~/.bash_profile
cat ~/.bash_profile

mkdir -p $datadir $logdir $(echo $MARIADB_HOME | sed 's:/[^/]*$::')
chown -R mysql:mysql $datadir $logdir

tar -xzvf $maria_zip -C $(echo $MARIADB_HOME | sed 's:/[^/]*$::')
cd $(echo $MARIADB_HOME | sed 's:/[^/]*$::')
ln -s $(echo $MARIADB_HOME | sed 's:/[^/]*$::')/$maria_dir $MARIADB_HOME


cat >> $MARIA_DATA/my.cnf <<eof
[server]
socket = $MARIA_DATA/mysql.sock

[client]
socket = $MARIA_DATA/mysql.sock
default-character-set       = utf8mb4

[mysql]
socket = $MARIA_DATA/mysql.sock
default-character-set       = utf8mb4
port  = 3306

[mysqld]
basedir = $MARIADB_HOME
datadir = $MARIA_DATA
port  = 3306
user  = mysql
socket = $MARIA_DATA/mysql.sock
pid_file = $MARIA_DATA/mysql.pid
log-error = $logdir/mysqld.err

collation-server     = utf8mb4_general_ci
init-connect         = 'SET NAMES utf8mb4'
character-set-server = utf8mb4
eof

## configuration
cat $MARIA_DATA/my.cnf

## edit file auth
chown mysql:mysql $MARIA_DATA/my.cnf
chmod 640 $MARIA_DATA/my.cnf


=====================================================================================
## mariadb installation
=====================================================================================
mariadb-install-db --user=mysql --defaults-file=$MARIA_DATA/my.cnf --basedir=$MARIADB_HOME --datadir=$MARIA_DATA



=====================================================================================
## regist systemd
=====================================================================================
cat >> /etc/systemd/system/mariaA.service << eof
[Unit]
Description=MariaDB Custom Server
After=network.target

[Service]
Type=forking
ExecStart=$MARIADB_HOME/bin/mariadbd --defaults-file=$MARIA_DATA/my.cnf
ExecStop=$MARIADB_HOME/bin/mysqladmin --defaults-file=$MARIA_DATA/my.cnf shutdown
User=mysql
Group=mysql
Restart=on-failure
PIDFile=$MARIA_DATA/mysql.pid

ProtectHome=false
ProtectSystem=false

ReadWritePaths=$MARIA_DATA

KillSignal=SIGTERM
SendSIGKILL=no
Restart=on-abort
RestartSec=5s
UMask=007
PrivateTmp=false
TimeoutStartSec=900
TimeoutStopSec=900
TasksMax=99%
LimitNOFILE=32768

[Install]
WantedBy=multi-user.target
eof

setenforce 0
systemctl daemon-reload

systemctl enable mariaA.service
systemctl start mariaA.service
systemctl stop mariaA.service
systemctl restart mariaA.service
systemctl status mariaA.service


=====================================================================================

=====================================================================================
왜 소켓경로를 지정해야 하는지 알 수 없음