심히 걱정된다 - 2008/08/20 09:58
DB Setup
OS : CentOS 5.2 Default Setup
IP : 61.32.177.164 / 192.168.30.4
------------------------------------------------------------------------------------------
Pre Install
yum install gcc gcc-c++ ncurses-devel
------------------------------------------------------------------------------------------
MySQL 5.0 설치
RPM 디폴트 설치
1. yum install mysql-server
2. service mysqld start
3. service mysqld stop
4. mv /var/lib/mysql /data/mysql50
5. ln -s /data/mysql50 /var/lib/mysql
6. mv /etc/my.cnf /var/lib/mysql
7. service mysqld start
------------------------------------------------------------------------------------------
MySQL 4.0 설치
소켓의 위치와 서비스 포트를 변경
1. mysql-4.0.27.tar.gz 다운로드
2. 컨피규레이션
./configure --prefix=/usr/local/mysql40 --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --with-charset=euc_kr --without-debug --enable-assembler --with-innodb --with-berkeley-db --enable-local-infile --with-pthread --with-named-thread-lib=-lpthread --with-readline--with-unix-socket-path=/tmp/mysql40.sock --with-tcp-port=3307
에러시 확인할 사항
/usr/include/pthread.h 마지막 라인에 /* Linuxthreads */ 추가
3. make
4. make install
5. /usr/local/mysql40/bin/mysql_install_db
디비초기화
6. mv /usr/local/mysql40/var /data/mysql40; ln -s /data/mysql40 /usr/local/mysql40/var
물리적 데이터 저장위치 이동 후 심볼릭 링크
7. chown -R mysql.mysql /data/mysql40
소유권 이동
8. vi /data/mysql40/my.cnf
mysql40 환경설정 파일작성
--------------------------------------------------------------------------------
[client]
port = 3307
socket = /tmp/mysql40.sock
[mysqld]
port = 3307
socket = /tmp/mysql40.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size= 16M
thread_concurrency = 8
default-character-set = euc_kr
log-bin
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
-------------------------------------------------------------------------------------
9. vi /etc/rc.d/rc.local
시스템 시작 시 자동실행
/usr/local/mysql40/bin/mysqld_safe &
10. /usr/local/mysql40/bin/mysqld_safe &
데몬 실행
11. /usr/local/mysql40/bin/mysql
접속 확인
12. netstat -an
3306 포트와 3307 포트 리슨 확인
OS : CentOS 5.2 Default Setup
IP : 61.32.177.164 / 192.168.30.4
------------------------------------------------------------------------------------------
Pre Install
yum install gcc gcc-c++ ncurses-devel
------------------------------------------------------------------------------------------
MySQL 5.0 설치
RPM 디폴트 설치
1. yum install mysql-server
2. service mysqld start
3. service mysqld stop
4. mv /var/lib/mysql /data/mysql50
5. ln -s /data/mysql50 /var/lib/mysql
6. mv /etc/my.cnf /var/lib/mysql
7. service mysqld start
------------------------------------------------------------------------------------------
MySQL 4.0 설치
소켓의 위치와 서비스 포트를 변경
1. mysql-4.0.27.tar.gz 다운로드
2. 컨피규레이션
./configure --prefix=/usr/local/mysql40 --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --with-charset=euc_kr --without-debug --enable-assembler --with-innodb --with-berkeley-db --enable-local-infile --with-pthread --with-named-thread-lib=-lpthread --with-readline--with-unix-socket-path=/tmp/mysql40.sock --with-tcp-port=3307
에러시 확인할 사항
/usr/include/pthread.h 마지막 라인에 /* Linuxthreads */ 추가
3. make
4. make install
5. /usr/local/mysql40/bin/mysql_install_db
디비초기화
6. mv /usr/local/mysql40/var /data/mysql40; ln -s /data/mysql40 /usr/local/mysql40/var
물리적 데이터 저장위치 이동 후 심볼릭 링크
7. chown -R mysql.mysql /data/mysql40
소유권 이동
8. vi /data/mysql40/my.cnf
mysql40 환경설정 파일작성
--------------------------------------------------------------------------------
[client]
port = 3307
socket = /tmp/mysql40.sock
[mysqld]
port = 3307
socket = /tmp/mysql40.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size= 16M
thread_concurrency = 8
default-character-set = euc_kr
log-bin
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
-------------------------------------------------------------------------------------
9. vi /etc/rc.d/rc.local
시스템 시작 시 자동실행
/usr/local/mysql40/bin/mysqld_safe &
10. /usr/local/mysql40/bin/mysqld_safe &
데몬 실행
11. /usr/local/mysql40/bin/mysql
접속 확인
12. netstat -an
3306 포트와 3307 포트 리슨 확인
TAG
Trackback Address ::
http://blog.jinbo.net/manim/trackback/22