cubrid DB 설치

cubrid는 어디 DB인가 했는데 opensource DB에 국산제품이라 하더라.

일단 한 번 설치나 해보고 JBoss에 연결해보자.

connection test 목적을 위해서 구성중이니, 여기에 적힌게 절대적인건 아니다..

 

1. cubrid 설치 파일 다운로드

https://www.cubrid.com/downloads

CUBRID | 다운로드

 

 

 

해당 파일을 설치하고자 하는 경로에 업로드 (예시는 /sw/cubrid_engine 경로에 설치했다.)

 

2. sh 타입으로 설치를 진행 (기본 y로 설치)

sh CUBRID-11.2-latest-Linux.x86_64.sh

[설치 문구]
Do you accept the license? [yN]: 
y
By default the CUBRID will be installed in:
  "/sw/cubrid_engine/CUBRID-11.x.x.~~"
Do you want to include the subdirectory CUBRID-11.x.x.~~?
Saying no will install in: "/sw/cubrid_engine" [Yn]: 
y

Using target directory: /sw/cubrid_engine/CUBRID-11.x.x.~~

Since CUBRID broker and server versions should match, please make sure that you are running the same version if you operate them in separate machines.
Do you want to continue? [Yn] : 
y
Extracting, please wait...

Unpacking finished successfully
demodb has been successfully created.

If you want to use CUBRID, run the following command to set required environment variables.
  $ . /cubrid/.cubrid.sh

 

3. cubrid 설치 확인

. ~/.cubrid.sh

[app@testDB cubrid_engine]$ cubrid_rel
CUBRID 11.4.4 (11.4.4.1832-7f8f019) (64bit release build for Linux) (Jan  8 2026 13:13:08)

 

4. cubrid service 기동

[app@testDB cubrid_engine]$ cubrid service start
@ cubrid master start
++ cubrid master start: success
@ cubrid broker start
++ cubrid broker start: success
@ cubrid manager server start
++ cubrid manager server start: success
[app@testDB cubrid_engine]$

[app@testDB cubrid_engine]$ cubrid service status
@ cubrid master status
++ cubrid master is running.
@ cubrid server status
@ cubrid pl status
@ cubrid broker status
  NAME                   PID  PORT    AS   JQ                  TPS                  QPS   SELECT   INSERT   UPDATE   DELETE   OTHERS     LONG-T     LONG-Q         ERR-Q  UNIQUE-ERR-Q  #CONNECT   #REJECT 
===========================================================================================================================================================================================================
* query_editor          5293 30000     5    0                    0                    0        0        0        0        0        0     0/60.0     0/60.0             0             0         0         0 
* broker1               5304 33000     5    0                    0                    0        0        0        0        0        0     0/60.0     0/60.0             0             0         0         0 
@ cubrid gateway status
++ cubrid gateway is not running.
@ cubrid manager server status
++ cubrid manager server is running.

 

5. 데이터베이스 경로 설정을 위해 디렉토리 생성 후 디렉토리로 이동

[app@testDB cubrid_engine]$ pwd
/sw/cubrid_engine
[app@testDB cubrid_engine]$ mkdir cubdata
[app@testDB cubrid_engine]$ cd cubdata

 

6. DB 생성 및 DB 기동

[app@testDB cubdata]$ cubrid createdb cub_testdb ko_KR.utf8
[app@testDB cubdata]$ cubrid server start cub_testdb
@ cubrid server start: cub_testdb

 

7. Cubrid 접속 테스트(기본계정의 ID는 dba이다. 패스워드는 default는 없다. 8.번에서 비밀번호 설정 필요)

[app@testDB ~]$ csql -u dba cub_testdb

 

8. dba계정에 패스워드 부여

csql> ALTER USER dba PASSWORD '1234';

 

9. 서비스 확인 및 포트 확인(33000)