[운영 종료] TmaxTibero Tech Blog

티맥스티베로 공식 블로그는 https://tmaxtibero.blog/ 로 이전되었습니다.

티맥스티베로 공식 블로그 이전 자세히보기

Admin, 환경설정

[Tibero] Tibero 운영 가이드 for beginner (4)

TmaxTiberotech 2023. 5. 12. 14:08

3.2. TAC

TAC(Tibero Active Cluster)는 하나의 Database에 복수의 Instance로 구성된 DB 입니다.

아래는 TAS(Tibero Active Storage)인 경우의 기동과 종료 절차입니다.

3.2.3. Startup with TAS

순서
케이스
Script
1
Cluster Manager
Common
$ tbcm –b
2
TAS
cmrctl 사용
$ cmrctl start as --name <AS1_Name>
Tibero command 사용
$ export TB_SID= <AS1_Name>
$ tbboot
Remote other nodes
$ cmrctl start as --name <AS2_Name>--remote
<CM2_SID>@<Cluster_Name>
3
TAC
cmrctl 사용
$ cmrctl start db --name <DB1_Name>
Tibero command 사용
$ export TB_SID= <DB1_Name>
$ tbboot
Remote other nodes
$ cmrctl start db --name <DB2_Name>--remote
<CM2_SID>@<Cluster_Name>

 

Example
# Node1
# Common
root@edu1:/root> tbcm -b
CM Guard daemon started up.
import resources from '/home/tibero/tbdata/cm1_res.dat'...
TBCM 6.1.1 (Build 159159)
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero cluster manager started up.
Local node name is (cm1:6629).
root@edu1:/root> su - tibero
# Case 1 Using cmrctl command
tibero@edu1[tac1]:/home/tibero> cmrctl start as --name tas1
Listener port = 8029
Tibero 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).
BOOT SUCCESS! (MODE : NORMAL)
tibero@edu1[tac1]:/home/tibero> cmrctl start db --name tac1
Listener port = 8629
Tibero 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).
BOOT SUCCESS! (MODE : NORMAL)
# Case 2
tibero@edu1[tac1]:/home/tibero> export TB_SID=tas1
tibero@edu1[tas1]:/home/tibero> tbboot
Listener port = 8029
Tibero 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).
tibero@edu1[tas1]:/home/tibero> export TB_SID=tac1
tibero@edu1[tac1]:/home/tibero> tbboot
Listener port = 8629
Tibero 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).
# Case 3 Remote boot other nodes
tibero@edu1[tac1]:/home/tibero> cmrctl start as --name tas2 --remote cm2@cluster1
BOOT SUCCESS! (MODE : NORMAL)
tibero@edu1[tac1]:/home/tibero> cmrctl start db --name tac2 --remote cm2@cluster1
BOOT SUCCESS! (MODE : NORMAL)
# Node2
# Common
root@edu2:/root> tbcm -b
CM Guard daemon started up.
import resources from '/home/tibero/tbdata/cm2_res.dat'...
TBCM 6.1.1 (Build 159159)
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero cluster manager started up.
Local node name is (cm2:6629).
root@edu2:/root> su - tibero
# Case 1 Using cmrctl command
tibero@edu2[tas2]:/home/tibero> cmrctl start as --name tas2
Listener port = 8029
Tibero 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).
BOOT SUCCESS! (MODE : NORMAL)
tibero@edu2[tas2]:/home/tibero> cmrctl start db --name tac2
Listener port = 8629
Tibero 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).
BOOT SUCCESS! (MODE : NORMAL)
# Case 2
tibero@edu2[tac2]:/home/tibero> export TB_SID=tas2
tibero@edu2[tas2]:/home/tibero> tbboot
Listener port = 8029
Tibero 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).
tibero@edu2[tas2]:/home/tibero> export TB_SID=tac2
tibero@edu2[tac2]:/home/tibero> tbboot
Listener port = 8629
Tibero 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).

3.2.4. Shutdown with TAS

순서
케이스
Script
1
TAC
cmrctl 사용
$ cmrctl stop db --name <DB1_Name>
Tibero command 사용
$ export TB_SID= <DB1_Name>
$ tbdown immediate
Remote other nodes
$ cmrctl stop db --name <DB2_Name>--remote
<CM2_SID>@<Cluster_Name>
2
TAS
cmrctl 사용
$ cmrctl stop as --name <AS1_Name>
Tibero command 사용
$ export TB_SID= <AS1_Name>
$ tbdown immediate
Remote other nodes
$ cmrctl stop as --name <AS2_Name>--remote
<CM2_SID>@<Cluster_Name>
3
Cluster Manager
Common
$ tbcm –d

 

Example
# Node1
# Case 1 Using cmrctl command
tibero@edu1[tac1]:/home/tibero> cmrctl stop db --name tac1
SUCCESS!
tibero@edu1[tac1]:/home/tibero> cmrctl stop as --name tas1
SUCCESS!
# Case 2
tibero@edu1[tac1]:/home/tibero> export TB_SID=tac1
tibero@edu1[tac1]:/home/tibero> tbdown immediate
Tibero instance terminated (IMMEDIATE mode).
tibero@edu1[tac1]:/home/tibero> export TB_SID=tas1
tibero@edu1[tas1]:/home/tibero> tbdown immediate
Tibero instance terminated (IMMEDIATE mode).
# Case 3 Remote down other nodes
tibero@edu1[tac1]:/home/tibero> cmrctl stop db --name tac2 --remote cm2@cluster1
SUCCESS!
tibero@edu1[tac1]:/home/tibero> cmrctl stop as --name tas2 --remote cm2@cluster1
SUCCESS!
# Common
tibero@edu1[tas1]:/home/tibero> exit
logout
root@edu1:/root> tbcm -d
CM DOWN SUCCESS!
# Node2
# Case 1 Using cmrctl command
tibero@edu2[tac2]:/home/tibero> cmrctl stop db --name tac2
SUCCESS!
tibero@edu2[tac2]:/home/tibero> cmrctl stop as --name tas2
SUCCESS!
# Case 2
tibero@edu2[tac2]:/home/tibero> export TB_SID=tac2
tibero@edu2[tac2]:/home/tibero> tbdown immediate
Tibero instance terminated (IMMEDIATE mode).
tibero@edu2[tac2]:/home/tibero> export TB_SID=tas2
tibero@edu2[tas2]:/home/tibero> tbdown immediate
Tibero instance terminated (IMMEDIATE mode).
# Common
tibero@edu2[tas2]:/home/tibero> exit
logout
root@edu2:/root> tbcm -d
CM DOWN SUCCESS!