要设置连接管理器,您必须创建连接管理器配置文件。
# *** HEADER ***
NAME connection_manager_instance_name
# Optional Parameters
MACRO name_1=server_list_1
MACRO name_2=server_list_2
MACRO name_n=server_list_n
.
.
.
LOCAL_IP ip_list
LOG value
LOGFILE path_and_filename
DEBUG value
CM_TIMEOUT seconds
EVENT_TIMEOUT seconds
SECONDARY_EVENT_TIMEOUT seconds
SQLHOSTS value
# *** BODY ***
# Connection Unit 1
unit_type unit_name_1
{
INFORMIXSERVER server_list
SLA sla_name_1 DBSERVERS=value \
\
\ #Optional SLA Attributes
MODE=value \
USEALIASES=value \
POLICY=value \
WORKERS=number_of_threads \
HOST=host_name \
NETTYPE=network_protocol \
SERVICE=service_name \
SQLHOSTSOPT=options
SLA sla_name_2 DBSERVERS=value ...
SLA sla_name_n DBSERVERS=value ...
.
.
.
#Optional Failover Parameter and Attributes
FOC ORDER=value \
PRIORITY=value \
TIMEOUT=seconds \
RETRY=attempts
#Optional Failover Alarm Parameter
CMALARMPROGRAM path_and_filename
}
# Connection Unit 2
unit_type unit_name_2
{
INFORMIXSERVER server_list
SLA sla_name_1 DBSERVERS=value ...
SLA sla_name_2 DBSERVERS=value ...
SLA sla_name_n DBSERVERS=value ...
FOC ORDER=value ...
CMALARMPROGRAM path_and_filename
}
.
.
.
# Connection Unit n
unit_type unit_name_n
{
INFORMIXSERVER server_list
SLA sla_name_1 DBSERVERS=value ...
SLA sla_name_2 DBSERVERS=value ...
SLA sla_name_n DBSERVERS=value ...
FOC ORDER=value ...
CMALARMPROGRAM path_and_filename
}
MACRO srvlist=node1,node2,node3,node4, \
node5,node6,node7,node8, \
node9,node10,node11,node12, \
node13,node14,node15
配置文件的组成部分 | 必需参数 | 可选参数 |
---|---|---|
头配置文件参数 | ||
用于高可用性集群的主体 | ||
用于网格、复制集或服务器集的主体 |
NAME cm1
LOG 1
LOGFILE ${INFORMIXDIR}/tmp/cm1.log
CLUSTER west
{
INFORMIXSERVER ids_w1,ids_w2
SLA oltp DBSERVERS=primary
SLA report DBSERVERS=HDR,SDS
FOC ORDER=ENABLED \
TIMEOUT=5 \
RETRY=2
CMALARMPROGRAM ${INFORMIXDIR}/etc/CMALARMPROGRAM.sh
}
此示例针对高可用性集群配置了连接管理器,并定义了两个 SLA。
NAME cm2
MACRO NY=(ny1,ny2,ny3)
MACRO CA=(ca1,ca2,ca3)
LOG 1
LOGFILE ${INFORMIXDIR}/tmp/cm2.log
CLUSTER west
{
INFORMIXSERVER ids_w1,ids_w2
SLA oltpw DBSERVERS=primary
SLA reportw DBSERVERS=(HDR,SDS)
FOC ORDER=ENABLED \
TIMEOUT=5 \
RETRY=1
CMALARMPROGRAM /etc/CMALARMPROGRAM.sh
}
CLUSTER east
{
INFORMIXSERVER ids_e1,ids_e2
SLA oltpe DBSERVERS=primary
SLA reporte DBSERVERS=RSS,HDR
FOC ORDER=ENABLED \
TIMEOUT=5 \
RETRY=1
CMALARMPROGRAM ${INFORMIXDIR}/etc/CMALARMPROGRAM.sh
}
REPLSET erset
{
INFORMIXSERVER g_er1,g_er2
SLA repl1_any DBSERVERS=ANY
SLA repl1_ca DBSERVERS=${CA} \
POLICY=WORKLOAD
SLA repl1_ny DBSERVERS=${NY}
}
GRID grid1
{
INFORMIXSERVER node1,node2,node3
SLA grid1_any DBSERVERS=ANY \
POLICY=LATENCY
SLA grid1_avail DBSERVERS=${NY},${CA}
}
GRID grid2
{
INFORMIXSERVER node4,node5
SLA grid2_any DBSERVERS=ANY \
POLICY=LATENCY
SLA grid2_avail DBSERVERS=${CA},${NY}
}
SERVERSET ss
{
INFORMIXSERVER ids1,ids2,ids3
SLA ssavail DBSERVERS=ids1,ids2,ids3 \
HOST=apollo \
SERVICE=9600 \
NETTYPE=onsoctcp
SLA ssany DBSERVERS=(ids1,ids2,ids3) \
HOST=apollo \
SERVICE=9610 \
NETTYPE=onsoctcp
}
此示例将连接管理器配置为支持两个高可用性集群、一个复制集、两个网格和一个服务器集。
配置文件主体定义了用于六个连接单元的服务级别协议和故障转移处理选项。配置文件头中定义的宏在某些 SLA 中使用。