CentOS 64Bit MariaDB 10 소스 컴파일 설치하기

1. 소스컴파일에 필요한 라이브러리를 설치해준다

yum install cmake ncurses ncurses-devel bison gcc gcc-c++ -y

2. mariaDB 다운로드 및 설치 준비

cd /usr/local/src wget -N https://downloads.mariadb.org/interstitial/mariadb-10.1.10/source/mariadb-10.1.10.tar.gz tar zxvf mariadb-10.1.10.tar.gz mkdir build cd build

3. 컴파일

DCMAKE_INSTALL_PREFIX에 설치경로 입력

DMYSQL_DATADIR에 DB 저장 경로

cmake ../mariadb-10.1.10 -DWITH_READLINE=1 -DWITH_READLINE=1 -DWITH_SSL=bundled -DWITH_ZLIB=system -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DENABLED_LOCAL_INFILE=1 -DWITH_EXTRA_CHARSETS=all -DWITH_ARIA_STORAGE_ENGINE=1 -DWITH_XTRADB_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATEDX_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DCMAKE_INSTALL_PREFIX=/usr/local/mariadb -DMYSQL_DATADIR=/home/DB

4. 설치(시간이 오래걸립니다 기다려주세요 커피한잔하시면서...)

make ; make install

5. 데몬 복사

cp /usr/local/mariadb/support-files/mysql.server /etc/init.d/mysqld  chkconfig --add mysqld

5. 설정파일 복사

cp /usr/local/mariadb/support-files/my-innodb-heavy-4G.cnf /etc/my.cnf

6. 계정 추가

adduser mysql

7. DB 생성

/usr/local/mariadb/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mariadb --datadir=/home/DB

8. mysql 계정 mariadb 권한 설정

chown mysql.mysql /usr/local/mariadb -R

9. mysql 비밀번호 설정

vi /root/.bash_profile PATH=$PATH:$HOME/bin:/usr/local/mariadb/bin source /root/.bash_profile service mysqld start mysqladmin -u root password '비밀번호' mysqladmin -u root -h localhost -p password '비밀번호'

참고1 : http://crowz.tistory.com/402

참고2 : http://www.imcore.net/mariadb-5-5-x-source-install/