yum을 이용하여MariaDB 5.5 패키지 설치

서버 환경은 CentOS이다. 여기에 MariaDB를 설치하기 위해 아래와 같이 yum install을 실행했다.

# yum install MariaDB-server MariaDB-client
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
 * base: mirror.navercorp.com
 * extras: mirror.navercorp.com
 * updates: mirror.navercorp.com
No package MariaDB-server available.
  * Maybe you meant: mariadb-server
No package MariaDB-client available.
Error: Nothing to do

하지만 패키지를 찾을 수 없다는, 에러가 났다. 패키지 명의 오류인가 싶어 그냥 MariaDB로 다시 해보았다.

# yum install MariaDB
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
 * base: mirror.navercorp.com
 * extras: mirror.navercorp.com
 * updates: mirror.navercorp.com
No package MariaDB available.
  * Maybe you meant: mariadb
Error: Nothing to do

여전히 안된다. 그런데 검색을 해보니 그냥은 설치할 수 없고 별도의 Repository 추가를 해야한다고 한다. 그것은 아래와 같다.

# vi /etc/yum.repos.d/MariaDB.repo

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/5.5/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

다시 시도해 보자.

# yum install MariaDB-server MariaDB-client
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
 * base: mirror.navercorp.com
 * extras: mirror.navercorp.com
 * updates: mirror.navercorp.com
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.x86_64 0:5.5.50-1.el6 will be installed
--> Processing Dependency: MariaDB-common for package: MariaDB-client-5.5.50-1.el6.x86_64
---> Package MariaDB-server.x86_64 0:5.5.50-1.el6 will be installed
--> Processing Dependency: perl(Data::Dumper) for package: MariaDB-server-5.5.50-1.el6.x86_64
--> Processing Dependency: perl(DBI) for package: MariaDB-server-5.5.50-1.el6.x86_64
--> Running transaction check
---> Package MariaDB-common.x86_64 0:5.5.50-1.el6 will be installed
--> Processing Dependency: MariaDB-compat for package: MariaDB-common-5.5.50-1.el6.x86_64
---> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed
--> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64
--> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64
---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed
--> Running transaction check
---> Package MariaDB-compat.x86_64 0:5.5.50-1.el6 will be installed
---> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed
--> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch
--> Running transaction check
---> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed
--> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
--> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
---> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed
--> Running transaction check
---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed
---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

... (생략) ...

Complete!

추가 팁. 설치 후 포트를 바꾸는 방법. /etc/my.cnf에 추가한다.

[mysqld]

port = 13306

포트 모니터링은 netstat로 확인 가능하다.

# netstat -an | grep 13306
tcp        0      0 0.0.0.0:13306           0.0.0.0:*               LISTEN

그런데 포트 설정 후 MariaDB 기동이 안되는 경우가 있다.

160704 18:58:35 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 13: Permission denied
160704 18:58:35 [ERROR] Do you already have another mysqld server running on port: 13306 ?
160704 18:58:35 [ERROR] Aborting

이 때는 서버에서 다음과 같은 명령어를 수행한다.

# /usr/sbin/setenforce 0

호스트 리부팅 후에도 계속 적용하게끔 하려면 /etc/selinux/config 파일 내에 selinux=를 disabled로 설정한다.