SDS 主备不能自动切换
环境:Linux 2.6.18 + IBM Informix Dynamic Server Version 11.50.UC8 + Vmware workstation
主备节点配置:
DRAUTO 2
DRINTERVAL -1
DRTIMEOUT 5
HA_ALIAS
DRLOSTFOUND $INFORMIXDIR/etc/dr.lostfound
DRIDXAUTO 0
LOG_INDEX_BUILDS
SDS_ENABLE 1
SDS_TIMEOUT 5
SDS_TEMPDBS sds_tempdbs1,/opt/informix/chunks/sds_tempdbs1,4,0,2000000
SDS_TEMPDBS sds_tempdbs2,/opt/informix/chunks/sds_tempdbs2,4,0,2000000
SDS_PAGING /opt/informix/chunks/sdspage1,/opt/informix/chunks/sdspage2
UPDATABLE_SECONDARY 1
FAILOVER_CALLBACK
TEMPTAB_NOLOG 0
DELAY_APPLY 0
STOP_APPLY 0
LOG_STAGING_DIR
RSS_FLOW_CONTROL 0
手动停止主库后,备库一直处于 -- Updates Blocked (SDS) 状态,不能自动切换为主服务器,不知道还需要什么配置。
备库online日志:
07:01:27 Wed Jul 4 - loguniq 2, logpos 0x14018, timestamp: 0x3b434 Interval: 46
07:01:27 Maximum server connections 0
07:02:00 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 0
07:02:00 Checkpoint Completed: duration was 0 seconds.
07:02:00 Wed Jul 4 - loguniq 2, logpos 0x17018, timestamp: 0x3b43d Interval: 46
07:02:00 Maximum server connections 0
07:02:01 SMX thread is exiting because of network error code -25582
07:02:01 SMX thread is exiting because of network error code -25582
07:02:02 Updates from secondary currently not allowed
07:02:02 Updates from secondary currently not allowed
07:02:02 SDS: Lost connection to testdb_pri
如果手动重启主库,备库会自动停止,需要重新启动。
之前有测试HDR,可以自动切换,不知道SDS为什么不行。
顺便问一下SDS如果主备机时间不一致,会有问题吗,尤其是在备机也能update的情况下。