application.yml
3.8 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
# 服务配置
server:
port: 9999
# spring 配置
spring:
application:
name: dispatch-system
profiles:
active: dev
security:
user:
name: admin
password: 123456
# 链路追踪配置
zipkin:
base-url: http://192.168.1.63:9411
sleuth:
sampler:
probability: 1
# 数据库信息配置
datasource:
druid:
driver-class-name: com.mysql.cj.jdbc.Driver
username: 110
password: QAHqCJf2kFYCLirM
url: jdbc:mysql://118.31.66.166:3306/dispatch_sys?characterEncoding=utf8&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true
initial-size: 10
max-active: 50
min-idle: 5
max-wait: 60000
# \u5F00\u542F\u7F13\u5B58preparedStatement(PSCache)
pool-prepared-statements: true
# \u542F\u7528PSCache\u540E\uFF0C\u6307\u5B9A\u6BCF\u4E2A\u8FDE\u63A5\u4E0APSCache\u7684\u5927\u5C0F
max-pool-prepared-statement-per-connection-size: 20
# \u7528\u6765\u68C0\u6D4B\u8FDE\u63A5\u662F\u5426\u6709\u6548\u7684sql
validation-query: select 'x'
# \u7533\u8BF7\u8FDE\u63A5\u65F6\u4E0D\u68C0\u6D4B\u8FDE\u63A5\u662F\u5426\u6709\u6548
test-on-borrow: false
# \u5F52\u8FD8\u8FDE\u63A5\u65F6\u4E0D\u68C0\u6D4B\u8FDE\u63A5\u662F\u5426\u6709\u6548
test-on-return: false
# \u7533\u8BF7\u8FDE\u63A5\u65F6\u68C0\u6D4B\uFF0C\u5982\u679C\u7A7A\u95F2\u65F6\u95F4\u5927\u4E8EtimeBetweenEvictionRunsMillis\uFF0C\u6267\u884CvalidationQuery\u68C0\u6D4B\u8FDE\u63A5\u662F\u5426\u6709\u6548\uFF08\u4E0D\u5F71\u54CD\u6027\u80FD\uFF09
test-while-idle: true
# \u68C0\u6D4B\u8FDE\u63A5\u7684\u95F4\u9694\u65F6\u95F4\uFF0C\u82E5\u8FDE\u63A5\u7A7A\u95F2\u65F6\u95F4 >= minEvictableIdleTimeMillis\uFF0C\u5219\u5173\u95ED\u7269\u7406\u8FDE\u63A5
time-between-eviction-runs-millis: 60000
# \u8FDE\u63A5\u4FDD\u6301\u7A7A\u95F2\u800C\u4E0D\u88AB\u9A71\u9010\u7684\u6700\u5C0F\u65F6\u95F4(ms)
min-evictable-idle-time-millis: 300000
# \u914D\u7F6E\u76D1\u63A7\u7EDF\u8BA1\u62E6\u622A\u7684filters\uFF08\u4E0D\u914D\u7F6E\u5219\u76D1\u63A7\u754C\u9762sql\u65E0\u6CD5\u7EDF\u8BA1\uFF09\uFF0C\u76D1\u63A7\u7EDF\u8BA1filter:stat\uFF0C\u65E5\u5FD7filter:log4j\uFF0C\u9632\u5FA1sql\u6CE8\u5165filter:wall
filters: stat,wall
# \u652F\u6301\u5408\u5E76\u591A\u4E2ADruidDataSource\u7684\u76D1\u63A7\u6570\u636E
use-global-data-source-stat: true
# \u901A\u8FC7connectProperties\u5C5E\u6027\u6765\u6253\u5F00mergeSql(Sql\u5408\u5E76)\u529F\u80FD\uFF1B\u6162SQL\u8BB0\u5F55(\u914D\u7F6E\u8D85\u8FC75\u79D2\u5C31\u662F\u6162\uFF0C\u9ED8\u8BA4\u662F3\u79D2)
connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
type: com.alibaba.druid.pool.DruidDataSource
# json\u65F6\u95F4\u683C\u5F0F\u8BBE\u7F6E \u51FA\u6E2F\u7406\u8D27\u88C5\u5378\u65F6\u95F4\u62A5\u9519
# jackson:
# time-zone: GMT+8
# date-format: YYYY-MM-dd HH:mm:ss
# mybatis配置
mybatis:
mapper-locations: classpath:mapper/*.xml
type-aliases-package: com.sunyo.wlpt.dispatch.domain
# 日志打印
logging:
config: config/logback-dev.xml
logback:
appname: dispatch-system
logdir: ./log
#eureka client
eureka:
instance:
status-page-url: http://${eureka.instance.hostname}:${server.port}/index
prefer-ip-address: true
instance-id: ${spring.cloud.client.ip-address}:${server.port}
hostname: ${spring.cloud.client.ip-address}
metadata-map:
user:
name: "admin"
passwoed: "123456"
client:
healthcheck:
enabled: true
service-url:
defaultZone: http://192.168.1.53:12345/eureka/
feign:
hystrix:
enabled: true
# boot admin
management:
endpoints:
enabled-by-default: true
web:
exposure:
include: ["*"]
endpoint:
health:
show-details: always
shutdown:
enabled: true