informix HDR基本管理

1.测试下如何主服务器宕机

$ onstat -c|grep DRAUTO
# DRAUTO            – Controls automatic failover of primary
DRAUTO 0 -手工切换

$onmode -ky
观察sercondary服务器状态
onstat -
IBM Informix Dynamic Server Version 11.70.UC1IE — Updates Blocked (Sec) — Up 00:20:14 — 152348 Kbytes

$onstat -m

IBM Informix Dynamic Server Version 11.70.UC1IE — Updates Blocked (Sec) — Up 00:21:16 — 152348 Kbytes

Message Log File: /opt/IBM/informix/informix.log
11:04:33  Fri Jun  3 – loguniq 22, logpos 0×90018, timestamp: 0xd0612 Interval: 527

11:04:33  Maximum server connections 0
11:04:33  Checkpoint Statistics – Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 19, Llog used 0

11:05:40  Checkpoint Completed:  duration was 0 seconds.
11:05:40  Fri Jun  3 – loguniq 22, logpos 0×92018, timestamp: 0xd0618 Interval: 528

11:05:40  Maximum server connections 0
11:05:40  Checkpoint Statistics – Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 0

11:05:41  SMX thread is exiting because of network error code -25582
11:05:41  SMX thread is exiting because of network error code -25582
11:05:41  DR: Receive error
11:05:41  ASF Echo-Thread Server: asfcode = -25582: oserr = 0: errstr = : Network connection is broken.

11:05:41  DR_ERR set to -1
11:05:42  DR: Turned off on secondary server
11:05:42  Updates from secondary currently not allowed
11:05:42  Updates from secondary currently not allowed

开启primary服务器：
$oninit
$onstat -
IBM Informix Dynamic Server Version 11.70.UC1IE — On-Line (Prim) — Up 00:00:41 — 144156 Kbytes

观察secondary状态：
$onstat -
IBM Informix Dynamic Server Version 11.70.UC1IE — Updatable (Sec) — Up 00:23:55 — 152348 Kbytes

可以看到，主服务器恢复以后仍能保持主服务器的地位

2.添加chunk或者创建dbspace

HDR对中，当需要添加/删除chunks/dbspace时，需要注意的是：
操作只能在主服务器进行
操作可以由HDR主服务器自动同步到辅助服务器
主辅服务器需要预先创建相应的文件或者link
如：
先在主备库均创建好chunk文件：
$touch /opt/IBM/informix/dbspaces/testdbs
$chmod 660 /opt/IBM/informix/dbspaces/testdbs
然后回到primary服务器操作：
$ onspaces -c -d testdbs -p /opt/IBM/informix/dbspaces/testdbs -o 0 -s 1000
Verifying physical disk space, please wait …
Space successfully added.

** WARNING **  A level 0 archive of Root DBSpace will need to be done.
这样就创建成功。

3.手工切换主备

刚才我们看到DRAUTO设置为0 ，所以采用手工切换方式，如何手工切换呢？也就是主机切换为备机，备机切换成主机。
关闭原来primary服务器上：
$onmode -ky
切换secondary服务器角色：
$onmode -d standard
$onmode -d primary shanghai（备机的数据库服务器名）
开启primary服务器并切换角色:
$onmode -ky
$oninit -PHY
$onmode -d secondary  beijing（主机的数据库服务器名）