All pages
1 of 4

Loading...

Loading...

Loading...

Loading...

์„ค์น˜ ์ค€๋น„ํ•˜๊ธฐ

SysMaster DB 8.3๋ฅผ ์„ค์น˜ํ•˜๊ธฐ ์ „ ์ค€๋น„ ๊ณผ์ •์„ ๋‹ค์Œ๊ณผ ๊ฐ™์€ ๋‹จ๊ณ„๋กœ ์„ค๋ช…ํ•œ๋‹ค.

  1. - ์„ค์น˜ํ•˜๊ธฐ ์ „์— ํ™•์ธํ•ด์•ผ ํ•  ์‹œ์Šคํ…œ์˜ ์š”๊ตฌ ์‚ฌํ•ญ์— ๋Œ€ํ•ด์„œ ์„ค๋ช…ํ•œ๋‹ค.

  2. - SysMaster DB 8.3๋ฅผ ์„ค์น˜ํ•˜๊ธฐ ์ „์— ํ•„์š”ํ•œ ํ™˜๊ฒฝ ๊ตฌ์„ฑ์— ๋Œ€ํ•ด์„œ ์„ค๋ช…ํ•œ๋‹ค.

  3. - ์„ค์น˜๋ฅผ ์œ„ํ•œ ๋ฐฐํฌ ํŒŒ์ผ๋“ค์˜ ๊ตฌ์„ฑ ์š”์†Œ์— ๋Œ€ํ•ด์„œ ์„ค๋ช…ํ•œ๋‹ค.

์‹œ์Šคํ…œ ์š”๊ตฌ์‚ฌํ•ญ
์„ค์น˜ ํ™˜๊ฒฝ ์„ธํŒ…
๋ฐฐํฌ ํŒŒ์ผ ๊ตฌ์„ฑ

๋ฐฐํฌ ํŒŒ์ผ ๊ตฌ์„ฑ

์„ค์น˜ ํ™˜๊ฒฝ์— ๋”ฐ๋ฅธ SysMaster DB 8.3์˜ ๋ฐฐํฌ ํŒŒ์ผ์€ ๋‹ค์Œ๊ณผ ๊ฐ™์ด ๊ตฌ์„ฑ๋œ๋‹ค.


Java TPM Agent์˜ ๋ฐฐํฌ ํŒŒ์ผ์€ ๋‹ค์Œ๊ณผ ๊ฐ™์ด ๊ตฌ์„ฑ๋œ๋‹ค.

1. SysMaster DB 8.3 ํŒŒ์ผ ๊ตฌ์„ฑ

Docker-compose (Podman-compose) ํ™˜๊ฒฝ

Kubernetes ํ™˜๊ฒฝ

2. Java TPM Agent ํŒŒ์ผ ๊ตฌ์„ฑ

sysmaster-db
sysmaster-db-{version}.tar
meta.conf
repo.conf
docker-compose.yml
podman-compose.yml
.env
sysmaster-db-patch-{version}.tar
patch
license
    +-- oss_license
        |-- font_licenses.md
        |-- OSS_LICENSES.md
        |-- THIRD-PARTY-NOTICES.txt
        |-- (and other open-source license files)
sysmaster-db-{version}.tar
kubernetes
    +-- init
        |-- 0.namespace.yaml
        |-- configmap.yaml
        |-- pvc.yaml
        |-- service.yaml
    +-- db
        |-- metadb-deployment.yaml
        |-- repodb-deployment.yaml
    +-- kafka
        |-- kafka.yaml
    +-- sysmaster
        |-- analyzer-deployment.yaml
        |-- client-deployment.yaml
        |-- collector-deployment.yaml
        |-- sdm-deployment.yaml
        |-- tibero-master-deployment.yaml
sysmaster-db-patch-{version}.tar
patch
license
    +-- oss_license
        |-- font_licenses.md
        |-- OSS_LICENSES.md
        |-- THIRD-PARTY-NOTICES.txt
        |-- (and other open-source license files)
jdk8
    +-- aix7
        |-- ibm-semeru-open-jdk_ppc64_aix_8u382b05_openj9-0.40.0.tar
    +-- centos7
        |-- OpenJDK8U-jdk_x64_linux_8u342b07.tar.gz
lib
    +-- aix7
        |-- libJNITpmStat.so
    +-- centos7
        |-- libJNITpmStat.so
application.yml
set.sh
tpmagent.jar
tpmctl.sh
tryrun.sh

์„ค์น˜ ํ™˜๊ฒฝ ์„ธํŒ…

1. ๋„์ปค(Docker) ํ˜น์€ ํŒŒ๋“œ๋งจ(Podman) ์„ค์น˜

1.1. ์—”์ง„ ์„ ํƒ

์‚ฌ์šฉํ•˜๊ณ ์ž ํ•˜๋Š” ์—”์ง„์— ๋”ฐ๋ผ ๋„์ปค ํ˜น์€ ํŒŒ๋“œ๋งจ์„ ์„ค์น˜ํ•œ๋‹ค.

  • Docker ์—”์ง„์„ ์‚ฌ์šฉํ•  ๊ฒฝ์šฐ

    • Docker-compose, Kubernetes ๋ฅผ ํ†ตํ•ด SysMaster DB๋ฅผ ๊ตฌ๋™ํ•  ์ˆ˜ ์žˆ๋‹ค.

  • RHEL์˜ Podman ์—”์ง„์„ ์‚ฌ์šฉํ•  ๊ฒฝ์šฐ

    • Podman-compose ํ™˜๊ฒฝ์„ ํ†ตํ•ด SysMaster DB๋ฅผ ๊ตฌ๋™ํ•  ์ˆ˜ ์žˆ๋‹ค.

์•„๋ž˜์˜ ์ฃผ์†Œ์—์„œ ๋„์ปค ์—”์ง„ ์„ค์น˜ ๋ฐฉ๋ฒ• ๋ฌธ์„œ๋ฅผ ํ™•์ธํ•œ ํ›„ ์šด์˜์ฒด์ œ์— ๋งž๋Š” ๋„์ปค ์—”์ง„์„ ์„ค์น˜ํ•œ๋‹ค.

์„ค์น˜ ํ™˜๊ฒฝ์˜ ์ธํ„ฐ๋„ท ์—ฐ๊ฒฐ ์—ฌ๋ถ€์— ๋”ฐ๋ฅธ ์„ค์น˜ ๋ฐฉ๋ฒ•์€ ๋‹ค์Œ๊ณผ ๊ฐ™๋‹ค.

  • ์ธํ„ฐ๋„ท ์—ฐ๊ฒฐ์ด ๊ฐ€๋Šฅํ•œ ๊ฒฝ์šฐ

    • "Install using the repository" ๊ณผ์ •์— ๋”ฐ๋ผ ์„ค์น˜ํ•œ๋‹ค.

    • ์ด๋•Œ ๋ณ„๋„์˜ ๋ฒ„์ „์„ ๋ช…์‹œํ•˜์ง€ ์•Š๊ณ  ๊ฐ€์žฅ ์ตœ์‹  ๋ฒ„์ „์„ ์„ค์น˜ํ•  ๊ฒƒ์„ ๊ถŒ์žฅํ•œ๋‹ค.

  • ์ธํ„ฐ๋„ท ์—ฐ๊ฒฐ์ด ๋ถˆ๊ฐ€๋Šฅํ•œ ๊ฒฝ์šฐ

์ด๋•Œ ๋„์ปค ์—”์ง„ ์„ค์น˜ ๊ณผ์ •์—์„œ ์ตœ์ข…์ ์œผ๋กœ ์„ค์น˜๋˜์–ด์•ผ ํ•˜๋Š” ํŒจํ‚ค์ง€๋Š” docker-ce, docker-ce-cli, containerd.io, docker-compose-plugin์ด๋‹ค.

docker version ๋ช…๋ น์„ ์‚ฌ์šฉํ•˜์—ฌ ์ •์ƒ์ ์œผ๋กœ ๋„์ปค/ ํŒŒ๋“œ๋งจ์ด ์„ค์น˜๋˜์—ˆ๋Š”์ง€ ํ™•์ธํ•œ๋‹ค.

์•„๋ž˜์˜ ์ฃผ์†Œ์—์„œ ์„ค์น˜ ๋ฐฉ๋ฒ•์„ ํ™•์ธํ•œ ํ›„ ์„ค์น˜ํ•œ๋‹ค.

ํŒŒ๋“œ๋งจ ์—”์ง„ ์„ค์น˜ ๊ณผ์ •์—์„œ ์ตœ์ข…์ ์œผ๋กœ ์„ค์น˜๋˜์–ด์•ผ ํ•˜๋Š” ํŒจํ‚ค์ง€๋Š” podman, Slirp4netns, podman-plugins์ด๋‹ค.

podman version ๋ช…๋ น์„ ์‚ฌ์šฉํ•˜์—ฌ ์ •์ƒ์ ์œผ๋กœ ๋„์ปค/ ํŒŒ๋“œ๋งจ์ด ์„ค์น˜๋˜์—ˆ๋Š”์ง€ ํ™•์ธํ•œ๋‹ค.


'Docker-compose', 'Kubernetes', 'Podman-compose' ์ค‘์—์„œ ํ•˜๋‚˜๋งŒ ์„ ํƒํ•˜์—ฌ ์„ค์น˜ํ•œ๋‹ค.

    • Docker ์„ค์น˜ ์‹œ docker-compose-plugin ํŒจํ‚ค์ง€๊ฐ€ ํ•จ๊ป˜ ์„ค์น˜๋œ๋‹ค. Docker๊ฐ€ ์ •์ƒ์ ์œผ๋กœ ์„ค์น˜๋˜์—ˆ์„ ๊ฒฝ์šฐ docker-compose ํ™˜๊ฒฝ์„ ์œ„ํ•œ ๋ณ„๋„์˜ ์ถ”๊ฐ€ ์„ค์น˜ ๊ณผ์ •์€ ํ•„์š” ์—†๋‹ค.

    • docker compose version ๋ช…๋ น์„ ์‚ฌ์šฉํ•ด ์ •์ƒ์ ์œผ๋กœ docker compose๊ฐ€ ์„ค์น˜๋˜์—ˆ๋Š”์ง€ ํ™•์ธํ•œ๋‹ค.

  • Podman-compose

"Install from a package" ๊ณผ์ •์— ๋”ฐ๋ผ ํŒจํ‚ค์ง€ ๋ณ„ ์„ค์น˜ ํŒŒ์ผ์„ ๋ณ„๋„๋กœ ๋ฐฐํฌํ•ด ์„ค์น˜ํ•œ๋‹ค.

  • ์ด๋•Œ ๊ฐ ํŒจํ‚ค์ง€ ๋ณ„๋กœ ๊ฐ€์žฅ ์ตœ์‹  ๋ฒ„์ „์„ ์„ค์น˜ํ•  ๊ฒƒ์„ ๊ถŒ์žฅํ•œ๋‹ค.

  • ๋‹ค์Œ์€ Centos 7, x86-64 ๊ธฐ์ค€์˜ ์„ค์น˜ ํŒŒ์ผ ๊ฒฝ๋กœ ์˜ˆ์‹œ์ด๋‹ค.

  • Podman-compose ๋Š” podman ์„ docker-compose ์ฒ˜๋Ÿผ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๊ฒŒ ํ•ด์ฃผ๋Š” ํˆด์ด๋‹ค.

  • Python ๊ธฐ๋ฐ˜์œผ๋กœ ๋งŒ๋“ค์–ด์ ธ ์žˆ์–ด pip๋ฅผ ์‚ฌ์šฉํ•ด์„œ ์„ค์น˜ํ•œ๋‹ค sudo pip3 install podman-compose

  • ์ •์ƒ์ ์œผ๋กœ podman-compose๊ฐ€ ์„ค์น˜๋˜์—ˆ๋Š”์ง€ ํ™•์ธํ•œ๋‹ค. podman-compose version

  • Kubernetes

    • ์•„๋ž˜์˜ ์ฃผ์†Œ์—์„œ Kubernetes ์„ค์น˜ ๋ฐฉ๋ฒ•์„ ํ™•์ธํ•œ ํ›„ ์šด์˜์ฒด์ œ์— ๋งž๋Š” Kubernetes๋ฅผ ์„ค์น˜ํ•œ๋‹ค.

    • ์ถ”๊ฐ€์ ์œผ๋กœ ์•„๋ž˜์˜ ์ฃผ์†Œ์—์„œ Kubectl ์„ค์น˜ ๋ฐฉ๋ฒ•์„ ํ™•์ธํ•œ ํ›„ ์šด์˜์ฒด์ œ์— ๋งž๋Š” Kubectl์„ ์„ค์น˜ํ•œ๋‹ค.

  • 1.2. ๋„์ปค(Docker) ์—”์ง„ ์„ค์น˜

    ์ฐธ๊ณ 

    ๋ฆฌ๋ˆ…์Šค์˜ ๊ฒฝ์šฐ ๋„์ปค ์—”์ง„ ์„ค์น˜ ์ดํ›„ sudo ๋ช…๋ น์–ด ์—†์ด ์šด์˜ํ•˜๊ธฐ ์œ„ํ•ด ์•„๋ž˜ ์ฃผ์†Œ๋ฅผ ์ฐธ๊ณ ํ•˜์—ฌ ์‹œ์Šคํ…œ ๊ตฌ์„ฑํ•˜๋Š” ๊ฒƒ์„ ๊ถŒ์žฅํ•œ๋‹ค.

    1.3 ํŒŒ๋“œ๋งจ(Podman) ์—”์ง„ ์„ค์น˜

    ์ฐธ๊ณ 

    ํŒŒ๋“œ๋งจ(Podman)์€ rootless container ๊ธฐ๋Šฅ์„ ์ง€์›ํ•˜์—ฌ sudo ๋ช…๋ น์–ด ์—†์ด ์ปจํ…Œ์ด๋„ˆ๋ฅผ ์šด์šฉํ•  ์ˆ˜ ์žˆ๋‹ค. Linux Kernel 4.18 ์ดํ•˜์—์„œ๋Š” ๋””์Šคํฌ ๋ณผ๋ฅจ์„ rootless container์— ๋งˆ์šดํŠธ ํ•  ์ˆ˜ ์—†๊ธฐ ๋•Œ๋ฌธ์— Podman์€ Red Hat Enterprise Linux 8 ์ด์ƒ๋ถ€ํ„ฐ ์ง€์›ํ•œ๋‹ค.

    2. SysMaster DB 8 ๊ตฌ๋™ ํ”Œ๋žซํผ ์„ค์น˜

    Docker-compose

    https://docs.docker.com/engine/install/
    https://podman.io/get-started
    https://download.docker.com/linux/centos/7/x86_64/stable/Packages/
    https://kubernetes.io/ko/docs/setup/production-environment/tools/
    https://kubernetes.io/ko/docs/tasks/tools/
    https://docs.docker.com/engine/install/linux-postinstall/

    ์‹œ์Šคํ…œ ์š”๊ตฌ์‚ฌํ•ญ

    1. ์ง€์› ํ”Œ๋žซํผ ๋ฐ ์šด์˜์ฒด์ œ

    SysMaster DB 8.3์˜ ๊ณต์‹์ง€์› ํ”Œ๋žซํผ ๋ฐ ์šด์˜์ฒด์ œ๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™๋‹ค.

    ๊ตฌ๋ถ„
    ์ œํ’ˆ ๋ฐ ๋ฒ„์ „

    ์šด์˜์ฒด์ œ

    • Linux:

      • CentOS 7 (64-bit)

      • Red Hat Enterprise Linux 7 ~ 9 (64-bit)

      • Oracle Linux Server release 9.4

    Docker


    SysMaster DB 8.3๋ฅผ ์„ค์น˜ํ•˜๊ธฐ ์œ„ํ•ด ํ•„์š”ํ•œ ํ•˜๋“œ์›จ์–ด ๋ฐ ์†Œํ”„ํŠธ์›จ์–ด์˜ ์š”๊ตฌ ์‚ฌํ•ญ์€ ๋‹ค์Œ๊ณผ ๊ฐ™๋‹ค.

    ๊ตฌ๋ถ„
    ์‚ฌ์–‘

    SysMaster DB 8.3์˜ ๊ด€์ œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋Œ€์ƒ ๊ถŒ์žฅ ํŒจ์น˜๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™๋‹ค.

    ํŒจ์น˜ ๋ฒˆํ˜ธ
    ํŒจ์น˜ ๋‚ด์šฉ

    ์›น ๋ธŒ๋ผ์šฐ์ €

    Chrome (์ตœ์‹  ๋ฒ„์ „ ์‚ฌ์šฉ ๊ถŒ์žฅ)

    281081

    V$TEMPSEG_USAGE ๋ทฐ์˜ SESSION_NUMBER ์ปฌ๋Ÿผ ๊ฐ’ ํ‘œ๊ธฐ ์ž˜๋ชป๋˜๋Š” ๋ฌธ์ œ ๊ฐœ์„ 

    [์ฐธ๊ณ ] ํ•ด๋‹น ํŒจ์น˜๊ฐ€ ์—†๋Š” ๊ฒฝ์šฐ [Realtime] > [Usage Monitoring] > [Temp Usage], [Analysis] > [Usage Analysis] > [Temp Usage] ๋ฉ”๋‰ด์— ๋ถ€์ •ํ™•ํ•œ ์ •๋ณด๊ฐ€ ํ‘œ์ถœ๋  ์ˆ˜ ์žˆ๋‹ค.

    304981b

    SQL Trace ์ •๋ณด ์ˆ˜์ง‘ ์‹œ machine, OS user ์ถ”๊ฐ€ ์ˆ˜์ง‘

    [์ฐธ๊ณ ] ํ•ด๋‹น ํŒจ์น˜๊ฐ€ ์—†๋Š” ๊ฒฝ์šฐ SQL Trace ์ •๋ณด์—์„œ OS User ์™€ Machine ์ •๋ณด๊ฐ€ ๋ถ€์ •ํ™•ํ•˜๊ฒŒ ํ‘œ์ถœ๋  ์ˆ˜ ์žˆ๋‹ค. 279651f ํŒจ์น˜ ์„ ์ ์šฉ์ด ํ•„์š”ํ•˜๋ฉฐ, 279651e ํŒจ์น˜ ์ดํ•˜ ํŒจ์น˜์™€๋Š” ํ˜ธํ™˜๋˜์ง€ ์•Š๋Š”๋‹ค.

    307175a

    SQL Trace ์ •๋ณด ์ˆ˜์ง‘ ์‹œ, ์ด๋ฏธ ๋‹ซํžŒ ์„ธ์…˜์˜ ๊ฒฝ์šฐ ์ˆ˜์ง‘๋˜์ง€ ์•Š๋Š” ๋ฌธ์ œ ์ˆ˜์ •

    [์ฐธ๊ณ ] ํ•ด๋‹น ํŒจ์น˜๊ฐ€ ์—†๋Š” ๊ฒฝ์šฐ ์„ธ์…˜์ด ์ž์ฃผ ์—ด๋ฆฌ๊ณ  ๋‹ซํžˆ๋Š” ํ™˜๊ฒฝ์˜ ๊ฒฝ์šฐ์—๋Š” SQL Trace ์ •๋ณด๋ฅผ ์ƒ๋‹นํžˆ ๋ˆ„๋ฝํ•˜์—ฌ ์ˆ˜์ง‘ํ•˜๊ฒŒ ๋œ๋‹ค.

    328607b

    Wait count, wait time ์ •๋ณด ์ˆ˜์ง‘ ์‹œ, wait event ์˜ wait count, time ๋ณด์ • ๋ฌธ์ œ ์ˆ˜์ • [์ฐธ๊ณ ] ํ•ด๋‹น ํŒจ์น˜๊ฐ€ ์—†๋Š” ๊ฒฝ์šฐ wait time๊ณผ wait count์˜ ๊ฐ’์ด ๋ถ€์ •ํ™•ํ•˜๊ฒŒ ํ‘œ์ถœ๋  ์ˆ˜ ์žˆ๋‹ค.

    304770a

    TSC ๋ชจ๋‹ˆํ„ฐ๋ง ์ „์šฉ ํŒจ์น˜ [์ฐธ๊ณ ] ํ•ด๋‹น ํŒจ์น˜๊ฐ€ ์—†๋Š” ๊ฒฝ์šฐ ์•„๋ž˜ ์ •๋ณด๋“ค์ด V$DATABASE ๋ทฐ์— ์—†์–ด primary์™€ standby๊ฐ€ ๊ตฌ๋ถ„๋˜์ง€ ์•Š๋Š” ๋“ฑ TSC ๋ชจ๋‹ˆํ„ฐ๋ง ๊ด€๋ จ ์ •๋ณด๋“ค์ด ๋ถ€์ •ํ™•ํ•˜๊ฒŒ ๋ณด์—ฌ์ง„๋‹ค.

    338513a

    ์‹ค์ œ TPR ์—ฐ๋™์— ํ•„์š”ํ•œ ํŒจ์น˜๋กœ, ์„œ๋ฒ„ ํŒจ์น˜ ์—†์ด ํŒจํ‚ค์ง€ ์ƒ์„ฑ ์Šคํฌ๋ฆฝํŠธ๋งŒ ์‹คํ–‰ํ•˜๋ฉด ๋œ๋‹ค.

    338594a

    TPR ์—ฐ๋™ ์ค‘ TPR ๋ฆฌํฌํŠธ ํŒŒ์ผ์ด ํ‹ฐ๋ฒ ๋กœ ์„œ๋ฒ„์— ์ƒ์„ฑ๋˜๋Š”๋ฐ, ์ด๋ฅผ ์‚ญ์ œํ•ด์ฃผ๋Š” ํ‹ฐ๋ฒ ๋กœ ํŒจํ‚ค์ง€์˜ ๋ฒ„๊ทธ๋ฅผ์ˆ˜์ •ํ•œ ํŒจ์น˜์ด๋‹ค.

    [์ฐธ๊ณ ] ํ•ด๋‹น ํŒจ์น˜ ์—†์–ด๋„ TPR ์—ฐ๋™ ๊ธฐ๋Šฅ์€ ๋™์ž‘ํ•˜์ง€๋งŒ ๋ฆฌํฌํŠธ ํŒŒ์ผ์ด ์„œ๋ฒ„์— ์Œ“์—ฌ์„œ ์ฃผ๊ธฐ์ ์œผ๋กœ ์‚ญ์ œ๊ฐ€ ํ•„์š”ํ•˜๋‹ค.

    ๋ฆฌํฌํŠธ ํŒŒ์ผ ์ˆ˜๋™์œผ๋กœ ์‚ญ์ œ ๋ฐฉ๋ฒ• : ์ฃผ๊ธฐ์ ์œผ๋กœ ๋‹ค์Œ๊ณผ ๊ฐ™์ด .tpr ๋กœ ์‹œ์ž‘ํ•˜๋Š” ๋ฆฌํฌํŠธ ํŒŒ์ผ ์‚ญ์ œ.

    rm -f .tpr*

    149894l

    ํ•ด๋‹น ํŒจ์น˜๊ฐ€ ์—†๋Š” ํ‹ฐ๋ฒ ๋กœ 6์—์„œ ์ง€์›ํ•˜์ง€ ์•Š๋Š” ์ฟผ๋ฆฌ๋ฅผ TPR ์Šค๋ƒ…์ƒท ์กฐํšŒ์‹œ ์‚ฌ์šฉํ•˜๊ณ  ์žˆ์–ด ํ•ด๋‹น ํŒจ์น˜๊ฐ€ ์—†์œผ๋ฉด ํ•ด๋‹น ํŒจ์น˜๊ฐ€ ์—†๋Š” ํ‹ฐ๋ฒ ๋กœ 6์—์„œ๋Š” ์กฐํšŒ๊ฐ€ ๋˜์ง€ ์•Š๋Š”๋‹ค.

    250728f

    Standby์—์„œ V$INSTANCE ๋ทฐ๋ฅผ ์กฐํšŒํ•  ์ˆ˜ ์žˆ๋„๋ก ํ•ด์ฃผ๋Š” ํŒจ์น˜. ํ•ด๋‹น ํŒจ์น˜๊ฐ€ ์—†์œผ๋ฉด ํ•ด๋‹น ์ธ์Šคํ„ด์Šค๊ฐ€ ํด๋Ÿฌ์Šคํ„ฐ๋ง์ด ๋˜์ง€ ์•Š๋Š”๋‹ค.

    339899a

    DB ๋น„์ •์ƒ ์ข…๋ฃŒ ์ƒํƒœ ํŒ๋‹จ ๋กœ์ง ๊ฐœ์„ 

    [์ฐธ๊ณ ] ํ•ด๋‹น ํŒจ์น˜๊ฐ€ ์—†๋Š” ๊ฒฝ์šฐ kill -9 ๋“ฑ ์™ธ๋ถ€ ์š”์ธ์œผ๋กœ DB๊ฐ€ ๋น„์ •์ƒ ์ข…๋ฃŒ๋˜์—ˆ์„ ๋•Œ, TPM Agent์—์„œ DB ์ข…๋ฃŒ ์—ฌ๋ถ€๊ฐ€ ์ •ํ™•ํžˆ ํŒ๋‹จ๋˜์ง€ ์•Š์„ ์ˆ˜ ์žˆ๋‹ค.

    Rocky Linux release 8 ~ 9 (64-bit)

  • Windows:

    • Windows 10 (64-bit)

    • Windows Server 2022 (64-bit)

  • ์•„๋ž˜(Docker ๋ฐ Podman) ์ง€์› ํ”Œ๋žซํผ ๋ฐ ์†Œํ”„ํŠธ์›จ์–ด ์š”๊ตฌ ์‚ฌํ•ญ ์„ค์น˜๋ฅผ ์ง€์›ํ•˜๋Š” ์šด์˜์ฒด์ œ๋ฉด ๊ธฐ๋™ ๊ฐ€๋Šฅ

  • v28 ์ด์ƒ

    Docker-compose

    v2.40.2 ์ด์ƒ

    Podman

    v4.4.1 ์ด์ƒ, Linux Kernel 4.18์„ ์‚ฌ์šฉํ•˜๋Š” Linux Red Hat Enterprise Linux 8 ์ด์ƒ๋ถ€ํ„ฐ ์ง€์›.

    Podman-compose

    v1.0.6 ์ด์ƒ

    Kubernetes

    v1.17 ์ด์ƒ

    ๊ด€์ œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค

    Tibero 6 FixSet06 ์ด์ƒ Tibero 7

    [์ฐธ๊ณ ] SysMasterDB์˜ Tibero ๊ด€์ œ ์—ฐ๋™์€ Tibero ๋ฒ„์ „๋ช…๋ฟ ์•„๋‹ˆ๋ผ ์„œ๋ฒ„ ๋ฐ”์ด๋„ˆ๋ฆฌ์˜ ๋นŒ๋“œ ํ˜•์ƒ๊ณผ ์—ฐ๋™ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ๊ฐ„ ํ˜ธํ™˜์„ฑ์„ ๊ธฐ์ค€์œผ๋กœ ํ•œ๋‹ค. ๋™์ผํ•œ Tibero ๋ฒ„์ „์ด๋ผ๋„ ๋นŒ๋“œ ์‹œ์  ๋ฐ ์ ์šฉ ํŒจ์น˜ ๋‚ด์—ญ์— ๋”ฐ๋ผ ์—ฐ๋™ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ์™€ ํ˜ธํ™˜๋˜์ง€ ์•Š์„ ์ˆ˜ ์žˆ๋‹ค. ํŠนํžˆ 2022๋…„ ์ด์ „ ๋นŒ๋“œ ๋ฐ”์ด๋„ˆ๋ฆฌ๋Š” ์ •์ƒ ๊ด€์ œ๋ฅผ ๋ณด์žฅํ•˜์ง€ ์•Š์œผ๋ฉฐ, ๊ธฐ๋ณธ ์ง€์› ๋Œ€์ƒ์—์„œ ์ œ์™ธ๋œ๋‹ค.

    ๊ด€์ œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์šด์˜ ์ฒด์ œ

    • Linux:

      • CentOS 7 (64-bit)

      • Red Hat Enterprise Linux 7 ~ 10 (64-bit)

      • Oracle Linux 8 ~ 10 (64-bit)

      • Rocky Linux 8 ~ 10 (64-bit)

      • ProLinux 7.5 (64-bit)

      • AIX 7.2 (64-bit)

    • [์ฐธ๊ณ ]

      • C++11 ์ง€์› ์ปดํŒŒ์ผ๋Ÿฌ

      • gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44) ์ด์ƒ

      • GLIBCXX_3.4.19 ์ด์ƒ

    CPU

    8 Core

    RAM

    32 GB

    ์ €์žฅ ๊ณต๊ฐ„

    240373

    Program ์ด PE_SLAVE ์ธ Session ์—์„œ OS User ์™€ Machine ์ •๋ณด ๋ˆ„๋ฝ ๊ฐœ์„ 

    [์ฐธ๊ณ ] ํ•ด๋‹น ํŒจ์น˜๊ฐ€ ์—†๋‹ค๋ฉด Program ์ด PE_SLAVE ์ธ Session ์—์„œ OS User ์™€ Machine ์ •๋ณด๊ฐ€ ๋ˆ„๋ฝ๋œ๋‹ค.

    276404

    ํ‹ฐ๋ฒ ๋กœ์˜ global view ์กฐํšŒ ์‹œ ์ˆ˜ํ–‰๋˜๋Š” ๋‚ด๋ถ€ ์ฟผ๋ฆฌ์— ๋Œ€ํ•ด ์ˆ˜ํ–‰ ์‹œ๋งˆ๋‹ค physical plan์„ ์ƒˆ๋กœ ์ƒ์„ฑํ•˜๋Š” ๋ฌธ์ œ ๊ฐœ์„ 

    [์ฐธ๊ณ ] SysMaster DB 8์—์„œ๋Š” Lock ์ •๋ณด ์ˆ˜์ง‘์„ ์œ„ํ•ด global view๋ฅผ ๋งค์ดˆ ์กฐํšŒํ•œ๋‹ค. ํ•ด๋‹น ํŒจ์น˜๊ฐ€ ์—†๋Š” ๊ฒฝ์šฐ ๋งค์ดˆ ํŠน์ • SQL์— ๋Œ€ํ•ด physical plan์„ ์ƒ์„ฑํ•˜์—ฌ [Analysis] > [Plan Analysis] ๋“ฑ์—์„œ ํ•ด๋‹น SQL์— ๋Œ€ํ•ด ์กฐํšŒ ์‹œ ์‘๋‹ต ์—†์Œ ํ˜„์ƒ์ด ๋ฐœ์ƒํ•  ์ˆ˜ ์žˆ๋‹ค.

    279651f

    Docker Engine 24๋ฒ„์ „ ํ™˜๊ฒฝ์—์„œ ์ปจํ…Œ์ด๋„ˆ ๋‹ค์ค‘ ๋„คํŠธ์›Œํฌ(endpoint) ์—ฐ๊ฒฐ ์‹คํŒจ ๋ฌธ์ œ๊ฐ€ ํ™•์ธ๋˜์—ˆ์œผ๋ฉฐ, ํ•ด๋‹น ๋„คํŠธ์›Œํฌ ์ฒ˜๋ฆฌ ๊ด€๋ จ ์ด์Šˆ๋Š” Docker Engine 28๋ฒ„์ „์—์„œ ์ˆ˜์ •๋˜์—ˆ๋‹ค. ๋”ฐ๋ผ์„œ ์•ˆ์ •์ ์ธ ๊ธฐ๋™์„ ์œ„ํ•ด Docker Engine 28๋ฒ„์ „ ์ด์ƒ ์‚ฌ์šฉ์„ ๊ถŒ์žฅํ•œ๋‹ค.

    ์ฐธ๊ณ 

    '๊ด€์ œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค'๋Š” '๊ด€์ œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์šด์˜ ์ฒด์ œ' ๋ชฉ๋ก์— ์žˆ๋Š” ์šด์˜ ์ฒด์ œ์— ์„ค์น˜๋œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์— ๋Œ€ํ•ด์„œ๋งŒ ๊ด€์ œ๊ฐ€ ๊ฐ€๋Šฅํ•˜๋‹ค.

    ์ฃผ์˜

    Docker Compose 2.40.2 ๋ฒ„์ „ ๋ฏธ๋งŒ์ธ ๊ฒฝ์šฐ Docker Compose์—์„œ ์›๊ฒฉ OCI Compose ์•„ํ‹ฐํŒฉํŠธ ์„ค์ • ๊ฐ’ ๊ฒ€์ฆ ๋ฏธํก์œผ๋กœ ๋ฐœ์ƒํ•˜๋Š” ๊ฒฝ๋กœ ํƒ์ƒ‰ ์ทจ์•ฝ์ ์ด ์žˆ๋‹ค. ๋”ฐ๋ผ์„œ 2.40.2 ๋ฒ„์ „ ์ด์ƒ์œผ๋กœ ์—…๋ฐ์ดํŠธ๋ฅผ ๊ถŒ๊ณ ํ•œ๋‹ค.

    2. ํ•˜๋“œ์›จ์–ด ๋ฐ ์†Œํ”„ํŠธ์›จ์–ด

    ์ฐธ๊ณ 

    ์ด Active Session ์ˆ˜ 600๊ฐœ (Active Session ์ˆ˜ 60๊ฐœ ร— ์ธ์Šคํ„ด์Šค 10๋Œ€) ๊ธฐ์ค€์˜ ์‚ฌ์–‘์ด๋‹ค.

    3. ๊ด€์ œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๊ถŒ์žฅ ํŒจ์น˜

    30 GB ์ด์ƒ (์ˆ˜์ง‘ ์ •๋ณด์˜ ๋ณด๊ด€ ์ฃผ๊ธฐ(RETENTION_DAY)์— ๋”ฐ๋ผ ์ผ ๋‹น 50 GB ์ถ”๊ฐ€ ํ•„์š”)

    libtpmstat ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์ƒ์„ฑ

    [์ฐธ๊ณ ] ํ•ด๋‹น ํŒจ์น˜๊ฐ€ ์—†๋Š” ๊ฒฝ์šฐ libtpmstat ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ๋ฅผ TPM Agent ์„ค์น˜ ์‹œ ํ•จ๊ป˜ ๋ฐฐํฌํ•ด์•ผ ํ•œ๋‹ค. TPM Agent 8.1.3 ์ด์ƒ์€ ํ•˜์œ„ ๋ฒ„์ „ ํŒจ์น˜์ธ 279651e ์ดํ•˜ ํŒจ์น˜์™€ ํ˜ธํ™˜์ด ๋˜์ง€ ์•Š๊ธฐ์—, 279651f ์ด์ƒ ํŒจ์น˜๊ฐ€ ํ•„์š”ํ•˜๋‹ค. Tibero์— ์ ์šฉ๋œ 279651 ํŒจ์น˜ ๋ฒ„์ „๊ณผ ์ƒ๊ด€ ์—†์ด, TPM Agent ๋นŒ๋“œ ์‹œ ์‚ฌ์šฉํ•œ 279651 ํŒจ์น˜ ๋ฒ„์ „๊ณผ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ์˜ 279651 ํŒจ์น˜ ๋ฒ„์ „์ด ๋งž์•„์•ผ ํ•œ๋‹ค.

    GLIBC_2.17 ์ด์ƒ

    1) OPEN_MODE์— value ์ถ”๊ฐ€
        - READ ONLY WITH APPLY
    
    2) PROTECTION_MODE
       : Protection mode currently in effect for the database
        - UNPROTECTED
        - PROTECTION
        - AVAILABILITY
        - PERFORMANCE
    
    3) DATABASE_ROLE
       : Current role of the database
        - PRIMARY
        - PHYSICAL STANDBY
        - LOGICAL STANDBY (TODO)
        - SNAPSHOT STANDBY
        - CASCADING STANDBY
    
    4) STANDBY_BECAME_PRIMARY_TSN
       : TSN at which the physical standby database became primary
    
    5) STANDBY_BECAME_PRIMARY_DATE
       : Time at which the physical standby database became primary