tmrgo/新建文本文档.txt

[canal]
# MySQL host
host = mariadb
# MySQL port
port = 3306
# MySQL user, must have replication privilege
user = root
# MySQL password
password = root
# Flavor: mysql or mariadb
flavor = mariadb
# Unique Server ID
serverID = 101
# mysqldump execution path
mysqldump = mysqldump
# dump tables, seperated by comma, will overwrite dbs
tables = ftdetaildate,feedtemplet,feed,barfeedremain,barmilk,templetdry,downloadedplan,downloadplandtl1,downloadplandtl1_exec,downloadplandtl2
# ,recweight
# database for dump tables, seperated by comma, will overwrite dbs
tableDB = tmrwatch2
# ignore tables, must be database.table format, separated by comma
ignoreTables = 
# start sync from binlog name
startName = 
# start sync from binlog position of
startPos = 
# master heartbeat period(*time.Second)
heartbeatPeriod = 60
# connection read timeout(*time.Second)
readTimeout = 90
# nodename  key name intpastureid
nodename = pasturecode
# nodevalue value
nodevalue = lymy_czly
# showlog
showlog = 0
onetimerows = 50

[kafka]
# enable kafka
kafkaEnable = false
Offset = 
kafka_host = www.kptyun.com
kafka_port = 9092
kafka_topic = tmrwatch_uploaddata_
saslEnable = false
username = root
saslpassword = root
tlsEnable = false
clientcert = 
clientkey = 
cacert = 

[mqtt]
# enable kafka
mqttEnable = true
topic = TMR/LYMY/kptmqtt/lymy_czly/czly
qos = 1
CleanSession = true
host = mq.heatwatch.cn
port = 1983
path = 
#host = auuhfh5e8d294-ats.iot.us-east-2.amazonaws.com
#port = 8883
#path = /MyIotThing
saslEnable = true
username = kptmqtt
saslpassword = kepaiteng
tlsEnable = false
clientcert = pem/bbbc7ee0f6-certificate.pem.crt
clientkey = pem/bbbc7ee0f6-private.pem.key
cacert = 

[Service]
ServiceName = KPTCanalService
ServiceDisplayName = KPTCanalService
ServiceDescription = ����������ͬ������



[barfeedremain]
barname = ztFeedpName
deleteField = pastureid,operatetime,emp,pid,times,dry


[barmilk]
barname = feedpbname
deleteField = pastureid,avgmonthage,bw,dayw,fetal,dayspre,pro,lactose,tem,cowsum,cowclass,cowclassid,bigcowclass,emp



[downloadedplan]
deleteField = pastureid,plantime,outitems,ptstempid,ptstempletname,thoweight,fpweight,lweight,iweight,oweight,tversion,ptversion,enable,isUse,completedtime,oldtmrid,artificial,driverId
,remark
 

[downloadplandtl1]
flpid = FPointID
dryfeed = Dry
pricefeed = UPrice
deleteField = pastureid,begintime,optdevice,outweight,date,deviation,xxwFeedCode



[downloadplandtl1_exec]
deleteField = pastureid,flpid,begintime,optdevice,date,deviation,xxwFeedCode,type
,surplus

[downloadplandtl2]
allowratio = feedpallowratio
deleteField = pastureid,lweighthis,remainleftw,allowrw,begintime,begintag,endtag,optdevice,bigcowname,priceweight,fpid,useinbartype,date,type

[recweight]
deleteField = pastureid

[feedtemplet]
deleteField = issueversion,issueid,backup1,backup2,cattle,volume,is_modify,group_data_id,group_version,autozone,surplus

[feed]
deleteField = is_surplus