SQream Studio 설치

@ 테스트 환경
CPU : Intel® Core™ i7-11600H 2.9GHz
RAM : 32GB
HDD : 512GB SSD(M.2, NVMe)
GPU : NVIDIA RTX 3050 Ti GDDR6 4GB
OS : CentOS Linux release 7.9.2009 (Core)

DB : v2022.1.2

 

1. 임의의 경로에 다운로드한 SQream Studio 설치 파일의 압축을 해제합니다.

[sqream@nt761xda /home/sqream/product/07_studio]$ ls -rlt
합계 22540
-rw-r--r-- 1 sqream sqream 23079836 10월 29 22:06 sqream-studio-5.4.4.x86_64.tar.gz

[sqream@nt761xda /home/sqream/product/07_studio]$ gzip -d sqream-studio-5.4.4.x86_64.tar.gz

[sqream@nt761xda /home/sqream/product/07_studio]$ ls -rlt
합계 108792
-rw-r--r-- 1 sqream sqream 111400960 10월 29 22:06 sqream-studio-5.4.4.x86_64.tar

[sqream@nt761xda /home/sqream/product/07_studio]$ tar xvf sqream-studio-5.4.4.x86_64.tar
......

[sqream@nt761xda /home/sqream/product/07_studio]$ ls -rlt
합계 108792
drwxrwxr-x 5 sqream sqream        70  3월 16  2022 sqream-admin
-rw-r--r-- 1 sqream sqream 111400960 10월 29 22:06 sqream-studio-5.4.4.x86_64.tar

 

2. 압축이 해제된, sqream-admin 디렉터리를 SQream Database가 설치된 경로로 이동시킵니다.

[sqream@nt761xda /home/sqream/product/07_studio]$ mv sqream-admin /home/sqream/SQREAM/.

[sqream@nt761xda /home/sqream/product/07_studio]$ ls -rlt /home/sqream/SQREAM
합계 0
drwxrwxr-x  5 sqream sqream  70  3월 16  2022 sqream-admin
drwxrwxr-x 10 sqream sqream 145 10월 27 18:31 sqream-db-v2022.1.2
drwxrwxr-x  2 sqream sqream  25 10월 27 18:37 sqream_license
lrwxrwxrwx  1 sqream sqream  19 10월 27 18:44 sqream -> sqream-db-v2022.1.2
drwxrwxr-x  3 sqream sqream  22 10월 27 18:54 sqream_cluster
drwxrwxr-x  3 sqream sqream  17 10월 27 19:53 sqream_config
drwxrwxr-x  3 sqream sqream  23 10월 27 23:58 logs
drwxrwxr-x  2 sqream sqream 102 10월 28 19:44 sqream_script
drwxrwxr-x  5 sqream sqream  80 10월 29 18:01 prometheus
drwxrwxr-x  6 sqream sqream 211 10월 29 18:33 sqream-dashboard

 

3. SQream Studio에서 사용하기 위한 Process Manager와 연결을 위한 Node.JS를 설치합니다.

[sqream@nt761xda /home/sqream/product/07_studio]$ su
암호:

[root@nt761xda /home/sqream/product/07_studio]$ curl -sL https://rpm.nodesource.com/setup_12.x | sudo bash -
......

[root@nt761xda /home/sqream/product/07_studio]$ yum clean all && sudo yum makecache fast
......

[root@nt761xda /home/sqream/product/07_studio]$ yum install -y nodejs
......
Complete!

[root@nt761xda /home/sqream/product/07_studio]$ npm install -g pm2
......
added 184 packages from 182 contributors in 38.947s

 

4. SQream Studio를 기동 합니다.

[sqream@nt761xda /home/sqream/SQREAM/sqream-dashboard]$ nohup npm start >> /home/sqream/SQREAM/logs/127.0.0.1/127.0.0.1_dash.log
nohup: ignoring input and redirecting stderr to stdout
[sqream@nt761xda /home/sqream/SQREAM/sqream-dashboard]$ cd /home/sqream/SQREAM/sqream-admin
[sqream@nt761xda /home/sqream/SQREAM/sqream-admin]$ npm run setup -- -y --host=127.0.0.1 --port=3108 --data-collector-url=http://127.0.0.1:8100/api/dashboard/data

sqream-studio@5.4.7 setup /home/sqream/SQREAM/sqream-admin
node ./server/build/main.js install "-y" "--host=127.0.0.1" "--port=3108" "--data-collector-url=http://127.0.0.1:8100/api/dashboard/data"

Config generated successfully. Run `npm start` to start the app.
[sqream@nt761xda /home/sqream/SQREAM/sqream-admin]$ nohup npm start >> /home/sqream/SQREAM/logs/127.0.0.1/127.0.0.1_admin.log
nohup: ignoring input and redirecting stderr to stdout

• SQream Studio는 별도의 터미널로 기동 시키고 종료되지 않아야 하므로, 별도의 기동 스크립트를 생성하여 기동하는 편이 좋습니다.

 

5. 웹브라우저의 주소창에 SQream이 설치된 서버IP:8080 주소를 입력하여 SQream Studio에 접속합니다.

• Username과 Password는 sqream, Database는 master를 입력하면 로그인됩니다.