AWS EC2에서 마리아디비(MariaDB) 설치하기

AWS에서는 MariaDB 공식 홈페이지에 나온 방법으로 MariaDB 설치가 되지 않는다.

 

MariaDB 패키지 목록을 확인해 보면, "mariadb105-server"로 시작하는 패키지가 존재하며, 이것을 설치하면 된다.

뒤의 105 라는 숫자는 MariaDB 10.5 버전을 의미한다.

$ yum list | grep -i mariadb*
mariadb-connector-c.x86_64                                        3.1.13-1.amzn2023.0.3                       amazonlinux
mariadb-connector-c-config.noarch                                 3.1.13-1.amzn2023.0.3                       amazonlinux
mariadb-connector-c-devel.x86_64                                  3.1.13-1.amzn2023.0.3                       amazonlinux
mariadb-connector-c-test.x86_64                                   3.1.13-1.amzn2023.0.3                       amazonlinux
mariadb105.x86_64                                                 3:10.5.23-1.amzn2023.0.1                    amazonlinux
mariadb105-backup.x86_64                                          3:10.5.23-1.amzn2023.0.1                    amazonlinux
mariadb105-common.x86_64                                          3:10.5.23-1.amzn2023.0.1                    amazonlinux
mariadb105-connect-engine.x86_64                                  3:10.5.23-1.amzn2023.0.1                    amazonlinux
mariadb105-cracklib-password-check.x86_64                         3:10.5.23-1.amzn2023.0.1                    amazonlinux
mariadb105-devel.x86_64                                           3:10.5.23-1.amzn2023.0.1                    amazonlinux
mariadb105-errmsg.x86_64                                          3:10.5.23-1.amzn2023.0.1                    amazonlinux
mariadb105-gssapi-server.x86_64                                   3:10.5.23-1.amzn2023.0.1                    amazonlinux
mariadb105-oqgraph-engine.x86_64                                  3:10.5.23-1.amzn2023.0.1                    amazonlinux
mariadb105-pam.x86_64                                             3:10.5.23-1.amzn2023.0.1                    amazonlinux
mariadb105-rocksdb-engine.x86_64                                  3:10.5.23-1.amzn2023.0.1                    amazonlinux
mariadb105-server.x86_64                                          3:10.5.23-1.amzn2023.0.1                    amazonlinux
mariadb105-server-utils.x86_64                                    3:10.5.23-1.amzn2023.0.1                    amazonlinux
mariadb105-sphinx-engine.x86_64                                   3:10.5.23-1.amzn2023.0.1                    amazonlinux
mariadb105-test.x86_64                                            3:10.5.23-1.amzn2023.0.1                    amazonlinux
perl-DBD-MariaDB.x86_64                                           1.22-1.amzn2023.0.4                         amazonlinux
perl-DBD-MariaDB-tests.x86_64                                     1.22-1.amzn2023.0.4                         amazonlinux

 

 

설치 ㄱㄱ

 

$ sudo yum install mariadb105-server
Last metadata expiration check: 0:07:21 ago on Mon Oct  7 01:30:23 2024.
Dependencies resolved.
=============================================================================================================
 Package                                 Arch        Version                          Repository        Size
=============================================================================================================
Installing:
 mariadb105-server                       x86_64      3:10.5.23-1.amzn2023.0.1         amazonlinux       11 M
Installing dependencies:
 mariadb-connector-c                     x86_64      3.1.13-1.amzn2023.0.3            amazonlinux      196 k
 mariadb-connector-c-config              noarch      3.1.13-1.amzn2023.0.3            amazonlinux      9.2 k
 mariadb105                              x86_64      3:10.5.23-1.amzn2023.0.1         amazonlinux      1.6 M
 mariadb105-common                       x86_64      3:10.5.23-1.amzn2023.0.1         amazonlinux       30 k
 mariadb105-errmsg                       x86_64      3:10.5.23-1.amzn2023.0.1         amazonlinux      214 k
 mysql-selinux                           noarch      1.0.4-2.amzn2023.0.3             amazonlinux       36 k
 perl-B                                  x86_64      1.80-477.amzn2023.0.6            amazonlinux      179 k
 perl-DBD-MariaDB                        x86_64      1.22-1.amzn2023.0.4              amazonlinux      153 k
 perl-DBI                                x86_64      1.643-7.amzn2023.0.3             amazonlinux      700 k
 perl-Data-Dumper                        x86_64      2.174-460.amzn2023.0.2           amazonlinux       55 k
 perl-File-Copy                          noarch      2.34-477.amzn2023.0.6            amazonlinux       20 k
 perl-FileHandle                         noarch      2.03-477.amzn2023.0.6            amazonlinux       16 k
 perl-Math-BigInt                        noarch      1:1.9998.39-2.amzn2023.0.2       amazonlinux      202 k
 perl-Math-BigRat                        noarch      0.2614-458.amzn2023.0.2          amazonlinux       39 k
 perl-Math-Complex                       noarch      1.59-477.amzn2023.0.6            amazonlinux       47 k
 perl-Sys-Hostname                       x86_64      1.23-477.amzn2023.0.6            amazonlinux       18 k
 perl-base                               noarch      2.27-477.amzn2023.0.6            amazonlinux       17 k
Installing weak dependencies:
 mariadb105-backup                       x86_64      3:10.5.23-1.amzn2023.0.1         amazonlinux      6.3 M
 mariadb105-cracklib-password-check      x86_64      3:10.5.23-1.amzn2023.0.1         amazonlinux       16 k
 mariadb105-gssapi-server                x86_64      3:10.5.23-1.amzn2023.0.1         amazonlinux       18 k
 mariadb105-server-utils                 x86_64      3:10.5.23-1.amzn2023.0.1         amazonlinux      216 k

Transaction Summary
=============================================================================================================
Install  22 Packages

Total download size: 20 M
Installed size: 118 M
Is this ok [y/N]: y

 

 

시스템 등록 ㄱㄱ

$ sudo systemctl enable mariadb
Created symlink /etc/systemd/system/mysql.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/mysqld.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /usr/lib/systemd/system/mariadb.service.
$ sudo systemctl start mariadb

 

 

루트(root) 패스워드 변경 ㄱㄱ

$ sudo mysqladmin -u root -p password
Enter password:
New password:
Confirm new password:

 

접속해 볼까?

$ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 10.5.23-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)]>

 

버전은 10.5로 되어있고 접속도 잘 된다. 끝.