Rocky os 8.9 APM 설치 - mysql(mariadb) 설치

아래의 사이트를 보고 진행했습니다.

정확한 정보를 보고 싶으면 아래 사이트로 가주세요.

 

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

APM 최신버전 설치 yum ( apache 2.4.37 / php 8.3.2 / mariadb 11.3.1 )

 

웹서버를 먼저 만들어 보기로 했다.

가상으로 리눅스를 먼저 올리고..

 

뭔지도 모를 명령어를 복사하여 실행해봤다.

 

# curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version="mariadb-11.3.1"

 

[root@localhost etc]# curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version="mariadb-11.3.1"            # [info] Checking for script prerequisites. # [info] MariaDB Server version 11.3.1 is valid # [info] Repository file successfully written to /etc/yum.repos.d/mariadb.repo # [info] Adding trusted package signing keys... /etc/pki/rpm-gpg /etc /etc # [info] Successfully added trusted package signing keys # [info] Cleaning package cache... 25 파일이 삭제되었습니다

 

# yum install MariaDB-client MariaDB-connect-engine mariadb-devel mariadb-server

Rocky Linux 8 - AppStream                                                                                                 1.0 MB/s |  10 MB     00:10 Rocky Linux 8 - BaseOS                                                                                                    1.9 MB/s | 2.9 MB     00:01 Rocky Linux 8 - Extras                                                                                                     14 kB/s |  14 kB     00:01 MariaDB Server                                                                                                            113 kB/s | 312 kB     00:02 MariaDB MaxScale                                                                                                          3.2 kB/s | 6.9 kB     00:02 MariaDB Tools                                                                                                              34 kB/s |  25 kB     00:00 종속성이 해결되었습니다. ==========================================================================================================================================================  꾸러미                                   구조                  버전                                                    저장소                       크기 ========================================================================================================================================================== 설치 중:  MariaDB-client                           x86_64                11.3.1-1.el8                                            mariadb-main                 17 M  MariaDB-connect-engine                   x86_64                11.3.1-1.el8                                            mariadb-main                2.6 M  MariaDB-server                           x86_64                11.3.1-1.el8                                            mariadb-main                 27 M  mariadb-devel                            x86_64                3:10.3.39-1.module+el8.8.0+1452+2a7eab68                appstream                   1.1 M 향상 중:  glibc                                    x86_64                2.28-251.el8_10.2                                       baseos                      2.2 M  glibc-all-langpacks                      x86_64                2.28-251.el8_10.2                                       baseos                       26 M  glibc-common                             x86_64                2.28-251.el8_10.2                                       baseos                      1.0 M ................ ................ ................ 향상되었습니다:   glibc-2.28-251.el8_10.2.x86_64                    glibc-all-langpacks-2.28-251.el8_10.2.x86_64        glibc-common-2.28-251.el8_10.2.x86_64   glibc-gconv-extra-2.28-251.el8_10.2.x86_64        glibc-langpack-en-2.28-251.el8_10.2.x86_64          glibc-langpack-ko-2.28-251.el8_10.2.x86_64   krb5-libs-1.18.2-27.el8_10.x86_64                 openssl-1:1.1.1k-12.el8_9.x86_64                    openssl-libs-1:1.1.1k-12.el8_9.x86_64   zlib-1.2.11-26.el8.x86_64 설치되었습니다:   MariaDB-client-11.3.1-1.el8.x86_64        MariaDB-client-compat-11.3.1-1.el8.noarch       MariaDB-common-11.3.1-1.el8.x86_64   MariaDB-compat-11.3.1-1.el8.x86_64        MariaDB-connect-engine-11.3.1-1.el8.x86_64      MariaDB-server-11.3.1-1.el8.x86_64   MariaDB-server-compat-11.3.1-1.el8.noarch compat-openssl10-1:1.0.2o-4.el8_6.x86_64        galera-4-26.4.16-1.el8.x86_64   keyutils-libs-devel-1.5.10-9.el8.x86_64   krb5-devel-1.18.2-27.el8_10.x86_64              libcom_err-devel-1.45.6-5.el8.x86_64   libkadm5-1.18.2-27.el8_10.x86_64          libnsl-2.28-251.el8_10.2.x86_64                 libselinux-devel-2.9-8.el8.x86_64   libsepol-devel-2.9-3.el8.x86_64           libverto-devel-0.3.2-2.el8.x86_64               make-1:4.2.1-11.el8.x86_64   mariadb-connector-c-3.1.11-2.el8_3.x86_64 mariadb-connector-c-devel-3.1.11-2.el8_3.x86_64 mariadb-devel-3:10.3.39-1.module+el8.8.0+1452+2a7eab68.x86_64   openssl-devel-1:1.1.1k-12.el8_9.x86_64    pcre2-devel-10.32-3.el8_6.x86_64                pcre2-utf16-10.32-3.el8_6.x86_64   pcre2-utf32-10.32-3.el8_6.x86_64          socat-1.7.4.1-1.el8.x86_64                      unixODBC-2.3.7-1.el8.x86_64   zlib-devel-1.2.11-26.el8.x86_64 완료되었습니다!

 

뭔지는 모르겠지만 "향상"이 되고 "설치"가 하여 "완료"가 되었다.

 

# vi /etc/my.cnf.d/server.cnf

다 알려고 하지말고, 시키는대로만 해보자. 설정 파일을 수정해보자.

set nu 로 확인해보니.. 48 line으로 된 짧은 설정파일이다.

[mysqld] 부분에 몇 줄 더 추가해줘야 한다.

 

[mysqld] character-set-server=utf8 collation-server=utf8_unicode_ci skip-character-set-client-handshake   #connection max_connections = 1000 max_connect_errors = 1000 wait_timeout= 60   # sqlmode sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

 

열심히 타이핑 후 set list로 공백까지 확인했다. 완벽. 퍼풱. 그 잡채.

 

# systemctl enable mariadb

Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /usr/lib/systemd/system/mariadb.service.

 

서비스에 등록은 OK

 

# systemctl start mariadb

Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.

 

영어가 잼뱅이라도 failed는 무슨 뜻인지 알겠다.

뭐가 문제인지 확인해보자

# systemctl status mariadb.service

● mariadb.service - MariaDB 11.3.1 database server    Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)   Drop-In: /etc/systemd/system/mariadb.service.d            └─migrated-from-my.cnf-settings.conf    Active: failed (Result: exit-code) since Wed 2024-06-05 07:00:09 EDT; 1min 46s ago      Docs: man:mariadbd(8)            https://mariadb.com/kb/en/library/systemd/   Process: 51153 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)   Process: 51119 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   &&>   Process: 51117 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)  Main PID: 51153 (code=exited, status=1/FAILURE)    Status: "MariaDB server is down"  6월 05 07:00:09 jk_test systemd[1]: Starting MariaDB 11.3.1 database server...  6월 05 07:00:09 jk_test mariadbd[51153]: 2024-06-05  7:00:09 0 [Warning] Could not increase number of max_open_files to more than 32768 (request: 33032)  6월 05 07:00:09 jk_test mariadbd[51153]: 2024-06-05  7:00:09 0 [ERROR] Unknown collation: 'utf_unicode_ci'  6월 05 07:00:09 jk_test mariadbd[51153]: 2024-06-05  7:00:09 0 [ERROR] Aborting  6월 05 07:00:09 jk_test systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE  6월 05 07:00:09 jk_test systemd[1]: mariadb.service: Failed with result 'exit-code'.  6월 05 07:00:09 jk_test systemd[1]: Failed to start MariaDB 11.3.1 database server.

[ERROR] Unknown collation: 'utf_unicode_ci'

얘가 문제라는데... 위의 설정을 다시 짚어보자.

 

'utf_unicode_ci' -> 'utf8_unicode_ci' 로 수정

난 퍼풱하지 않았음. 다시 

 

# systemctl start mariadb

별 다른 프롬프트가 뜨지 않았다.

 

# mysql

mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead Welcome to the MariaDB monitor.  Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 11.3.1-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>

 

오예, 성공