MariaDB ์„ค์น˜ํ•˜๊ธฐ

๋ฐ˜์‘ํ˜•

๋ฆฌ๋ˆ…์Šค๋กœ ์›น ์„œ๋ฒ„๋ฅผ ๊ตฌ๋™ํ•ด๋ณด์‹  ๋ถ„์ด๋ผ๋ฉด ๋ณดํ†ต ์•Œ๊ณ ๊ณ„์‹œ๋Š” DBMS๋Š” MySQL์ผ ๊ฒƒ์ž…๋‹ˆ๋‹ค. ๊ทธ๋Ÿฐ๋ฐ, ์ด MySQL๊ณผ ๋˜‘๋‹ฎ์€ DBMS ํ”„๋กœ๊ทธ๋žจ์ด  ์žˆ๋Š”๋ฐ, ์ด๊ฒƒ์ด ๋ฐ”๋กœ MariaDB์ž…๋‹ˆ๋‹ค.


MariaDB๋Š” MySQL๊ณผ ๋˜‘๊ฐ™์€ ๋ช…๋ น์–ด, ๋˜‘๊ฐ™์€ ๊ตฌ์กฐ๋กœ ์ด๋ฃจ์–ด์ง„ RDBMS๋กœ ์ตœ๊ทผ MySQL์ด ์˜ค๋ผํด๋กœ ์ธ์ˆ˜๋˜๋ฉด์„œ ์ƒ์šฉํ™” ์šฐ๋ ค๊ฐ€ ๋˜์–ด ๋งŽ์€ ์„œ๋ฒ„ ๊ด€๋ฆฌ์ž๋“ค์ด MariaDB๋กœ ๊ฐˆ์•„ํƒ€๋Š” ์‹ค์ •์ด๋ผ๊ณ  ํ•ฉ๋‹ˆ๋‹ค. MariaDB๋Š” MySQL๊ณผ ๊ฑฐ์˜ ๋˜‘๊ฐ™์ด ๊ฐœ๋ฐœ๋˜์–ด์ ธ์„œ ํ˜ธํ™˜์„ฑ์— ๋งŽ์€ ๋ฌด๋ฆฌ๊ฐ€ ์—†๊ณ , ํ”ํžˆ ์›น ์„œ๋ฒ„๋กœ์จ ์ž์ฃผ ์‚ฌ์šฉํ•˜๋Š” XpressEngine(์ดํ•˜ XE, ๊ตฌ ์ œ๋กœ๋ณด๋“œ)์—์„œ๋„ ์ผ๋ถ€ ์ฝ”๋“œ๋งŒ ์ˆ˜์ •ํ•˜๋ฉด ๋ฌด๋ฆฌ ์—†์ด ๋Œ๋ฆด ์ˆ˜ ์žˆ๋‹ค๊ณ ๋„ ํ•ฉ๋‹ˆ๋‹ค. MariaDB๋Š” GPLv2 License๋ฅผ ๋”ฐ๋ฆ…๋‹ˆ๋‹ค.


๊ทธ ๋ฟ๋งŒ ์•„๋‹ˆ๋ผ MariaDB๋Š” MySQL๊ณผ ์šฐ์ˆ˜ํ•œ ํผํฌ๋จผ์Šค๋ฅผ ๋ณด์ด๊ณ  ์žˆ์–ด, ์†๋„ ๋ฉด์—์„œ๋„ ๋งŽ์€ ์ฐจ์ด๊ฐ€ ์žˆ๋‹ค๊ณ  ํ•ฉ๋‹ˆ๋‹ค. ์–ผ๋งˆ ์ „์—๋Š” ์•ˆ๋“œ๋กœ์ด๋“œ๋ฅผ ๋งก๊ณ  ์žˆ๋Š” ํšŒ์‚ฌ Google๋„ MySQL์ด ์ ์  ์˜คํ”ˆ ์†Œ์Šค์™€ ๋ฉ€์–ด์ง์— ๋”ฐ๋ผ MySQL์„ MariaDB๋กœ ๋ณ€๊ฒฝํ•˜๊ฒ ๋‹ค๋Š” ์กฐ์ง๋„ ์žˆ๋Š” ๊ธฐ์‚ฌ๋„ ์‹ค๋ ธ๋”๊ตฐ์š”.


์ž ์„ค๋ช…์€ ์ด์ฏค์ด๋ฉด ๋œ ๊ฒƒ๊ฐ™์œผ๋‹ˆ, ์ด์ œ ์„ค์น˜์— ๋“ค์–ด๊ฐ€๋ณด๋„๋ก ํ•ฉ์‹œ๋‹ค.


MariaDB Downloads


์ด ํฌ์ŠคํŠธ์—์„œ๋Š” MariaDB๋ฅผ deb/rpm ๊ฐ™์€ ํŒจํ‚ค์ง€ ์„ค์น˜๊ฐ€ ์•„๋‹Œ Repository์—์„œ ์ง์ ‘ ๋ฐ›์•„์„œ apt-get/yum ๋ช…๋ น์–ด๋ฅผ ์‚ฌ์šฉํ•ด ๋‹ค์šด๋กœ๋“œํ•˜์—ฌ ์„ค์น˜ํ•˜๋„๋ก ํ•˜๊ฒ ์Šต๋‹ˆ๋‹ค. ๋จผ์ € MariaDB Downloads๋ฅผ ํด๋ฆญํ•ฉ์‹œ๋‹ค.



์ž์‹ ์ด ์‚ฌ์šฉํ•˜๊ณ  ์žˆ๋Š” ๋ฆฌ๋ˆ…์Šค์˜ ์ข…๋ฅ˜, ๋ฒ„์ „, ๊ทธ๋ฆฌ๊ณ  MariaDB ๋ฒ„์ „์„ ์„ ํƒํ•˜๋Š”๋ฐ, MariaDB ๋ฒ„์ „์€ ํ˜„์žฌ 5.5๊ฐ€ ์•ˆ์ •ํ™” ๋ฒ„์ „, 10.0.4์˜ ๊ฒฝ์šฐ ์•ŒํŒŒ ๋ฒ„์ „(ํ˜„์žฌ ๊ฐœ๋ฐœ ์ค‘์ธ ๋ฒ„์ „)์ด๋ฏ€๋กœ ์•ˆ์ •ํ™”๋œ 5.5 ๋ฒ„์ „์˜ ์‚ฌ์šฉ์„ ๊ถŒ์žฅํ•ฉ๋‹ˆ๋‹ค. ๊ทธ๋ฆฌ๊ณ  Debian ๊ณ„์—ด์˜ ๋ฆฌ๋ˆ…์Šค๋ฅผ ์„ ํƒํ•˜์‹  ๊ฒฝ์šฐ, Mirror, ๋‹ค์šด๋กœ๋“œ ํ•  ์„œ๋ฒ„๋ฅผ ์„ ํƒํ•ด์•ผํ•˜๋Š”๋ฐ, ํ•œ๊ตญ์˜ KAIST ์„œ๋ฒ„๋ฅผ ์„ ํƒํ•˜๋„๋ก ํ•ฉ์‹œ๋‹ค.


์ €๋Š” ์ œ๊ฐ€ ์‚ฌ์šฉํ•˜๊ณ  ์žˆ์ž, ๊ฐ€์žฅ ๋งŽ์ด ์‚ฌ์šฉํ•˜๋Š” Ubuntu 13.04์™€ ๊ทธ๋ฆฌ๊ณ  CentOS 6 ๋ฒ„์ „์˜ ๋ฆฌ๋ˆ…์Šค๋ฅผ ์˜ˆ๋กœ ๋“œ๋Ÿฌ ์„ค๋ช…ํ•˜๋„๋ก ํ•˜๊ฒ ์Šต๋‹ˆ๋‹ค.


๋จผ์ € Ubuntu Linux๋Š” ์•„๋ž˜์™€ ๊ฐ™์ด ์ง„ํ–‰ํ•ฉ๋‹ˆ๋‹ค.



$ sudo apt-get instsall software-properties-common python-software-properties

 --> ๋ฃจํŠธ ๊ถŒํ•œ์œผ๋กœ ๋จผ์ € PPA๋ฅผ ์‚ฌ์šฉํ•˜๋„๋ก ํ•˜๋Š” ํ”„๋กœ๊ทธ๋žจ์„ ์„ค์น˜ํ•ฉ๋‹ˆ๋‹ค.


$ sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db

 --> ํŒจํ‚ค์ง€๋ฅผ ๋ฐ›์„ key๊ฐ’์„ ๊ฐ€์ ธ์™€ ๋“ฑ๋กํ•ฉ๋‹ˆ๋‹ค.


$ sudo add-apt-repository 'deb http://ftp.kaist.ac.kr/mariadb/repo/5.5/ubuntu raring main'

 --> ๋ ˆํฌ์ง€ํ† ๋ฆฌ๋ฅผ /etc/apt/sources.lst์— ๋“ฑ๋กํ•ฉ๋‹ˆ๋‹ค.


$ sudo apt-get update

 --> ํŒจํ‚ค์ง€ ๋ชฉ๋ก์„ ์ƒˆ๋กœ ๋ถˆ๋Ÿฌ์˜ต๋‹ˆ๋‹ค.


$ sudo apt-get install mariadb-server

 --> MariaDB๋ฅผ ์„ค์น˜ํ•ฉ๋‹ˆ๋‹ค.


์›๋ณธ์—์„œ์˜ ๋ฐ‘์— ๋‚ด์šฉ์€ PPA์™€ ๊ด€๋ จ์—†์ด ์ˆ˜๋™์œผ๋กœ /etc/apt/sources.lst์˜ ๋ชฉ๋ก์„ ์ˆ˜์ •ํ•ด์„œ ์‚ฌ์šฉํ•˜๋Š” ๋ฐฉ๋ฒ•์ž…๋‹ˆ๋‹ค. 


$ vim /etc/apt/sources.lst


์œ„ ๋ช…๋ น์–ด๋ฅผ ์ด์šฉํ•ด์„œ ๋ฐ‘์˜ ๋‚ด์šฉ์„ ๊ทธ๋Œ€๋กœ ๋ณต์‚ฌ ๋ถ™์—ฌ๋„ฃ๊ธฐ ํ•˜์‹œ๊ณ , ๋‘๋ฒˆ์งธ ๋ถ€๋ถ„๋งŒ ํ•˜์‹œ๋ฉด ๋ฉ๋‹ˆ๋‹ค.



CentOS์˜ ๊ฒฝ์šฐ..


$ sudo vim /etc/yum.repos.d/MariaDB.repo

 --> ํ•ด๋‹น ํŒŒ์ผ์„ ๋ถˆ๋Ÿฌ์˜ต๋‹ˆ๋‹ค.


# MariaDB 5.5 CentOS repository list - created 2013-08-22 06:39 UTC

# http://mariadb.org/mariadb/repositories/

[mariadb]

name = MariaDB

baseurl = http://yum.mariadb.org/5.5/centos6-amd64

gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

gpgcheck=1


์œ„ ๋‚ด์šฉ์„ ๋ณต์‚ฌ ๋ถ™์—ฌ๋„ฃ๊ธฐ ํ•ฉ๋‹ˆ๋‹ค.


$ sudo yum install MariaDB-server MariaDB-client

 --> MariaDB๋ฅผ ์„ค์น˜ํ•ฉ๋‹ˆ๋‹ค.



๋ฐ˜์‘ํ˜•
TAGS.

Tistory Comments