[ Cubrid ] Cubrid 서버 설치

1. 서버 설치

docker run --privileged --cap-add=SYS_TIME -d -it -p 30000:30000 --name cubrid centos:8 init

docker exec -it cubrid /bin/bash

# 리눅스 아키텍처 확인
uname -m

mkdir -p /app/server/databases/cubrid

curl -L https://ftp.cubrid.org/CUBRID_Engine/11.3_latest/CUBRID-11.3-latest-Linux.x86_64.tar.gz -o /app/server/databases/CUBRID-11.3-latest-Linux.x86_64.tar.gz

tar -xvf /app/server/databases/CUBRID-11.3-latest-Linux.x86_64.tar.gz -C /app/server/databases/cubrid --strip-components=1

echo Y | sh /app/server/databases/cubrid/share/scripts/setup.sh /app/server/databases/cubrid

# bash접속시 환경변수 적용
cp /root/.cubrid.sh /etc/profile.d/cubrid.sh

# 현재 터미널에 환경변수 적용
source /etc/profile.d/cubrid.sh

# 큐브리드 버전 확인
/app/server/databases/cubrid/bin/cubrid_rel

/app/server/databases/cubrid/bin/cubrid createdb --db-volume-size=500M --log-volume-size=200M testdb ko_KR

# . /root/.cubrid.sh
# 위 명령어에서 환경변수 확인
# 큐브리드 마스터, 브로커, 매니저 서버 실행
# cubrid service start
# 큐브리드 데이터베이스 서버 실행
# cubrid server start demodb
# 큐브리드 데이터베스 서버 상태 확인
# cubrid service status
cat <<'CUBRID_SERVICE' > /etc/systemd/system/cubrid.service
[Unit]
Description=CUBRID Database Service
After=network.target

[Service]
Type=forking
Environment="CUBRID=/app/server/databases/cubrid"
Environment="CUBRID_DATABASES=/app/server/databases/cubrid/databases"
Environment="LD_LIBRARY_PATH=/app/server/databases/cubrid/lib:/app/server/databases/cubrid/cci/lib:$LD_LIBRARY_PATH"
Environment="SHLIB_PATH=$LD_LIBRARY_PATH"
Environment="LIBPATH=$LD_LIBRARY_PATH"
Environment="PATH=/app/server/databases/cubrid/bin:/usr/sbin:$PATH"
ExecStart=/bin/sh -c "/app/server/databases/cubrid/bin/cubrid service start && /app/server/databases/cubrid/bin/cubrid server start testdb"
ExecStop=/bin/sh -c "/app/server/databases/cubrid/bin/cubrid server stop testdb && /app/server/databases/cubrid/bin/cubrid service stop"
Restart=on-failure

[Install]
WantedBy=multi-user.target
CUBRID_SERVICE

systemctl daemon-reload

systemctl enable cubrid

systemctl start cubrid

systemctl status cubrid

 

2. 클라이언트 접속 확인

[ https://www.cubrid.com/downloads ] 에서 jdbc 드라이버 다운로드

JDBC URL : [ jdbc:CUBRID:localhost:30000:testdb:public:: ] 및 Username : [ dba ] 설정 후 Test Connection 접속확인