zr-job-sit.yml
3.26 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
server:
port: 8004
mybatis-plus:
mapper-locations:
- classpath*:mapper/**/*Mapper.xml
type-aliases-package: com.chinagas.modules.job.entity
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
log-prefix: SQL
spring:
redis:
host: 172.17.56.37
port: 6379
database: 0
timeout: 300
quartz:
properties:
org:
quartz:
scheduler:
instanceName: ZrScheduler
instanceId: AUTO
threadPool:
class: org.quartz.simpl.SimpleThreadPool
threadCount: 20
threadPriority: 5
jobStore:
class: org.springframework.scheduling.quartz.LocalDataSourceJobStore
isClustered: true
clusterCheckInterval: 15000
maxMisfiresToHandleAtATime: 1
txIsolationLevelSerializable: true
misfireThreshold: 12000
tablePrefix: QRTZ_
scheduler-name: ZrSchedule
auto-startup: true
startup-delay: 1
wait-for-jobs-to-complete-on-shutdown: true
overwrite-existing-jobs: true
datasource:
url: "jdbc:mysql://172.17.56.104:3306/chinagas?useUnicode=true&characterEncoding=utf8&useSSL=false&allowPublicKeyRetrieval=true"
username: root
password: 123456
druid:
#初始化时建立的连接数
driverClassName: com.mysql.cj.jdbc.Driver
initialSize: 1
#最小连接池数量
minIdle: 1
#最大连接池数
maxActive: 20
# 配置获取连接等待超时的时间
maxWait: 60000
# 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
timeBetweenEvictionRunsMillis: 60000
# 配置一个连接在池中最小生存的时间，单位是毫秒
minEvictableIdleTimeMillis: 300000
# 配置一个连接在池中最大生存的时间，单位是毫秒
maxEvictableIdleTimeMillis: 900000
# 配置检测连接是否有效
validationQuery: SELECT 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
webStatFilter:
enabled: true
statViewServlet:
enabled: true
# 设置白名单，不填则允许所有访问
allow:
url-pattern: /druid/*
# 控制台管理用户名和密码
#login-username: root
#login-password: 7614
filter:
stat:
enabled: true
# 慢SQL记录
log-slow-sql: true
slow-sql-millis: 1000
merge-sql: true
#防御sql注入
wall:
config:
multi-statement-allow: true
feign:
sentinel:
enabled: true
okhttp:
enabled: true
httpclient:
enabled: false
client:
config:
remoteDepInfoService:
connectTimeout: 800000
readTimeout: 600000
remoteEmpInfoService:
connectTimeout: 8000000
readTimeout: 6000000
remoteDataSyncService:
connectTimeout: 8000000
readTimeout: 6000000
remoteMcsbService:
connectTimeout: 80000000
readTimeout: 60000000
default:
connectTimeout: 20000
readTimeout: 10000
compression:
request:
enabled: true
mime-types: text/xml,application/xml,application/json
min-request-size: 4096
response:
enabled: true