V7standby配置参数
V7standby配置参数
- 主库ip为192.168.174.111
- 备库ip为192.168.174.112
- 浮动ip为192.168.174.113
主库配置
[standby]
#this resource managed by the standby or not
#此资源是否由备用服务器管理
managed = false
#debug the system, if it's true, will output
#more information to the standby log file.
#调试系统,如果为真,将输出
#有关备用日志文件的详细信息。
is_debug = false
#if it's true the log message will have
#the timestamp at it's head.
#如果这是真的,日志消息将具有
#头部的时间戳。
log_timestamp = true
#the standby listenning port.
#备用侦听端口。
local_server_port = 54322
#remote server's IP address
#远程服务器的IP地址
remote_server_ip = 192.168.174.112 -- 对方ip
#remote standby port
#远程备用端口
remote_server_port = 54322
#standby log directory
#备用日志目录
log_dir = '/home/kingbase/ES/log'
#standby log file name pattern.
#备用日志文件名模式。
standby_log = "standby-%w.log"
#servermode primary standby
#服务器模式主备用
server_mode = primary
#how many times let ha switch, 0 indicate that
#do not use this property.
#让ha切换多少次,0表示
#不要使用此属性。
kingbase_fault_num = 0
# true : enable float ip,false : disable float ip
# true:启用浮点ip,false:禁用浮点ip
enable_float_ip = true
#example : floatip_readonly_addcmd =
#"/sbin/ifconfig eth0:0 192.168.4.230 netmask 255.255.240.0"
#example : floatip_readonly_delcmd =
#"/sbin/ifconfig eth0:0 down"
#for standby server
#示例:floatip\u readonly\u addcmd=
#“/sbin/ifconfig eth0:0 192.168.4.230网络掩码255.255.240.0”
#示例:floatip\u readonly\u delcmd=
#“/sbin/ifconfig eth0:0向下”
#用于备用服务器
floatip_readonly_addcmd = ""
floatip_readonly_delcmd = ""
#for primary server
#对于主服务器
floatip_readwrite_addcmd = "/home/kingbase/ES/V7/config/ifconfigadd.sh eno16777736:0 192.168.174.113 255.255.255.0" -- 浮动ip
floatip_readwrite_delcmd = "/home/kingbase/ES/V7/config/ifconfigdown.sh eno16777736:0"
#the special resource kingbase
#特种资源基地
[kingbase]
#this resource managed by the standby or not
#此资源是否由备用服务器管理
managed = false
#for check the network
#用于检查网络
lifecheck_interval = 2
#kingbase log file name pattern.
#kingbase日志文件名模式。
kingbase_log = "kingbase-%w.log"
#kingbase binary directory
#kingbase二进制目录
bin_dir = '/home/kingbase/ES/V7/bin'
#kingbase data directory
#kingbase数据目录
data_dir = '/home/kingbase/ES/V7/data'
#for kingbase to store the archive log
#供kingbase存储归档日志
log_archive_dest = "/home/kingbase/archive"
#ip address & port of primary kingbase
#example : primary_conninfo = "host=127.0.0.1 port=1234"
#主kingbase的ip地址和端口
#示例:primary_conninfo=“主机=127.0.0.1端口=1234”
primary_conninfo = "host=192.168.174.112 port=54321" -- 对方ip
#parallel recovering threads numbers
#并行恢复线程数
parallel_recover_threads = 1
#the local kingbase listenning port to communicate
#standby server.
#要通信的本地kingbase侦听端口
#备用服务器。
local_kingbase_cmdport = 54323
#protection_mode maxperformance
#保护模式最大性能
protection_mode = maxprotection
#if it's true when the primary server change it's
#mode, the standby server will send the log which
#primary hadn't send.
#如果主服务器更改时为true,则
#模式下,备用服务器将发送以下日志:
#主还没发。
send_taillog = true
#when the kingbase broken down, standby retry
#how many times
#当kingbase出现故障时,请待机重试
#多少次
retrytimes = 0
#one normal config resource managed by standby
#一个由备用服务器管理的正常配置资源
[network]
#this resource managed by the standby or not
#此资源是否由备用服务器管理
managed = true
#resource start level, it's 0~99, 0 is highest
#资源起始级别,为0~99,最高为0
startlevel = 99
#resource stop level, it's 0~99, 0 is highest
资源停止级别,为0~99,0为最高
stoplevel = 0
#the cmd check the resource live or not
#命令检查资源是否处于活动状态
checkalive = "touch /home/kingbase/kingbase.txt && ping -c 1 -w 1 192.168.174.1 1>/dev/null 2>/dev/null" -- 网关
#the time between two check action, unit is second
#两次检查动作之间的时间,单位为秒
checkinterval = 5
#how much times the check fails then we judge the resource down
#检查失败多少次,然后我们判断资源是否已关闭
checkfails = 3
#the resource standby must work when the primay works
#当主服务器工作时,资源备用服务器必须工作
hotstandby = false
#the cmd that start the resource
#启动资源的cmd
startcmd = ""
#the command that stop the resource
#停止资源的命令
stopcmd = ""
#the resource fails need swtich or not
#资源失败,是否需要切换
needswitch = true
#when the resource down, how many times restart it before judge it down
#当资源关闭时,在判断它是否关闭之前重启多少次
retrytimes = 0
#the cmd to restart the resouce
#命令重新启动资源
retrycmd = ""
#one normal config resource managed by standby
#一个由备用服务器管理的正常配置资源
[klogminer]
#this resource managed by the standby or not
#此资源是否由备用服务器管理
managed = false
#resource start level, it's 0~99, 0 is highest
#资源起始级别,为0~99,最高为0
startlevel = 99
#resource stop level, it's 0~99, 0 is highest
#资源停止级别,为0~99,0为最高
stoplevel = 0
#the cmd check the resource alive or not
#命令检查资源是否处于活动状态
checkalive = "kdb_logminerd status"
#the time between two check action, unit is second
#两次检查动作之间的时间,单位为秒
checkinterval = 3
#how much times the check fails then we judge the resource down
#检查失败多少次,然后我们判断资源是否已关闭
checkfails = 1
#the resource standby must work when the primay works
#当主服务器工作时,资源备用服务器必须工作
hotstandby = false
#the cmd that start the resource
#启动资源的cmd
startcmd = "kdb_logminerd start $MODE$"
#the command that stop the resource
#停止资源的命令
stopcmd = "kdb_logminerd stop $PID$"
#the resource fails need swtich or not
#资源失败,是否需要切换
needswitch = true
#when the resource down, how many times restart it before judge it down
#当资源关闭时,在判断它是否关闭之前重启多少次
retrytimes = 0
#the cmd to restart the resouce
#命令重新启动资源
retrycmd = "kdb_logminerd restart $FAILEDTIMES$"
备库配置
# 备库配置
[standby]
managed = false
is_debug = false
log_timestamp = true
local_server_port = 54322
remote_server_ip = 192.168.174.111 -- 对方ip
remote_server_port = 54322
log_dir = '/home/kingbase/ES/log'
standby_log = "standby-%w.log"
server_mode = primary
kingbase_fault_num = 0
enable_float_ip = true
floatip_readonly_addcmd = ""
floatip_readonly_delcmd = ""
floatip_readwrite_addcmd = "/home/kingbase/ES/V7/config/ifconfigadd.sh eno16777736:0 192.168.174.113 255.255.255.0"
floatip_readwrite_delcmd = "/home/kingbase/ES/V7/config/ifconfigdown.sh eno16777736:0"
[kingbase]
managed = false
lifecheck_interval = 2
kingbase_log = "kingbase-%w.log"
bin_dir = '/home/kingbase/ES/V7/bin'
data_dir = '/home/kingbase/ES/V7/data'
log_archive_dest = "/home/kingbase/archive"
primary_conninfo = "host=192.168.174.111 port=54321"
parallel_recover_threads = 1
local_kingbase_cmdport = 54323
protection_mode = maxprotection
send_taillog = true
retrytimes = 0
[network]
managed = true
startlevel = 99
资源停止级别,为0~99,0为最高
stoplevel = 0
checkalive = "touch /home/kingbase/kingbase.txt && ping -c 1 -w 1 192.168.174.1 1>/dev/null 2>/dev/null"
checkinterval = 5
checkfails = 3
hotstandby = false
startcmd = ""
stopcmd = ""
needswitch = true
retrytimes = 0
retrycmd = ""
[klogminer]
managed = false
startlevel = 99
stoplevel = 0
checkalive = "kdb_logminerd status"
checkinterval = 3
checkfails = 1
hotstandby = false
startcmd = "kdb_logminerd start $MODE$"
stopcmd = "kdb_logminerd stop $PID$"
needswitch = true
retrytimes = 0
retrycmd = "kdb_logminerd restart $FAILEDTIMES$"