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로 설정한다.