개요
Tibero 7.2.2 버전에서 CM (Cluster Manager) Resource의 자동 재시작(Auto restart) 설정 방법을 다룹니다. (resource 전체가 아닌 일부 내용을 다룹니다.)
방법
CM 기동
# tbcm -b
CM Guard daemon started up.
import resources from '/cm/cmresource'...
TBCM 7.1.1 (Build 277758)TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.Tibero cluster manager started up.
Local node name is (cm1:18629).
SQL
복사
CM Service Auto Restart 활성화 - Service Auto start mode on
[root] # cmrctl act service --name [as service name]
Auto-boot mode is activated (tas)
[root] # cmrctl act service --name [db service name]
Auto-boot mode is activated (tac)
[root] # # cmrctl show
Resource List of Node cm1
=====================================================================
CLUSTER TYPE NAME STATUS DETAIL
----------- -------- -------------- -------- ------------------------
COMMON network pub1 UP (public) ens160
COMMON network int1 UP (private) 192.168.37.100/19629
COMMON cluster cls UP inc: int1, pub: pub1
cls file cls:0 UP +0
cls file cls:1 UP +1
cls file cls:2 UP +2
cls service tas UP Active Storage, Active Cluster (auto-restart: ON)
cls service tac UP Database, Active Cluster (auto-restart: ON)
cls as tas1 UP(NRML) tas, /db/tibero7, failed retry cnt: 0
cls db tac1 UP(NRML) tac, /db/tibero7, failed retry cnt: 0
cls vip vip1 UP tac, 192.168.56.11/255.255.255.0/192.168.56.255 (1)
failed retry cnt: 0
cls vip vip2 UP(R) tac, 192.168.56.21/255.255.255.0/192.168.56.255 (2)
failed retry cnt: 0
=====================================================================
SQL
복사
Service 확인
[root] # cmrctl show service --name [as service name]
Service Resource Info
=================================================
Service name : tas
Service type : Active Storage
Service mode : Active Cluster
Cluster : cls
Inst. Auto Start: ON
Interrupt Status: COMMITTED
Incarnation No. : 2 / 2 (CUR / COMMIT)
=================================================
| INSTANCE LIST |
|-----------------------------------------------|
| NID NAME Status Intr Stat ACK No. Sched |
| --- -------- -------- --------- ------- ----- |
| 1 cm1 UP(NRML) COMMITTED 2 Y |
| 2 cm2 UP(NRML) COMMITTED 2 Y |
=================================================
[root] # cmrctl show service --name [db service name]
Service Resource Info
=================================================
Service name : tac
Service type : Database
Service mode : Active Cluster
Cluster : cls
Inst. Auto Start: ON
Interrupt Status: COMMITTED
Incarnation No. : 2 / 2 (CUR / COMMIT)
=================================================
| INSTANCE LIST |
|-----------------------------------------------|
| NID NAME Status Intr Stat ACK No. Sched |
| --- -------- -------- --------- ------- ----- |
| 1 cm1 UP(NRML) COMMITTED 2 Y |
| 2 cm2 UP(NRML) COMMITTED 2 Y |
=================================================
SQL
복사
테스트 방법
TAS / TAC Process kill 또는 TAS / TAC Instance down 등 Instance down 후 cmrctl show 로 STATUS BOOTING → UP 되는지 확인하는 방법은 아래와 같습니다.
[root] # kill -9 ps -ef|grep tbsvr_MGWP |grep -v grep|awk '{print $2}'
SQL
복사
참고
CM에서 RESOURCE STOP시 아래와 같은 문구가 출력됩니다.
[root] # cmrctl stop db --name tac1
Cannot stop instance of service 'tac' manually (Auto-start mode is on)
SQL
복사