application-druid.properties
3.25 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
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
# server1
#spring.datasource.druid.master.url=jdbc:mysql://192.168.100.132:13366/wms?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8&autoReconnect=true&maxReconnects=9999&initialTimeout=30&rewriteBatchedStatements=true
#spring.datasource.druid.master.username=root
#spring.datasource.druid.master.password=HHsoft123.
# server2
#spring.datasource.druid.master.url=jdbc:mysql://192.168.100.134:13367/wms?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8&autoReconnect=true&maxReconnects=9999&initialTimeout=30&rewriteBatchedStatements=true
#spring.datasource.druid.master.username=root
#spring.datasource.druid.master.password=HHsoft123.
# server3
#spring.datasource.druid.master.url=jdbc:mysql://192.168.100.136:13368/wms?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8&autoReconnect=true&maxReconnects=9999&initialTimeout=30&rewriteBatchedStatements=true
#spring.datasource.druid.master.username=root
#spring.datasource.druid.master.password=HHsoft123.
#aliyun
#spring.datasource.druid.master.url=jdbc:mysql://110.41.55.145:3366/wms_shandonghaiwang2?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
#spring.datasource.druid.master.username=root
#spring.datasource.druid.master.password=qq123456
# local
spring.datasource.druid.master.url=jdbc:mysql://localhost:3306/wms_shandonghaiwang?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
spring.datasource.druid.master.username=root
spring.datasource.druid.master.password=123456
# test
#spring.datasource.druid.master.url=jdbc:mysql://localhost:3306/wms?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
#spring.datasource.druid.master.username=root
#spring.datasource.druid.master.password=123456
# config
spring.datasource.druid.initial-size=4
spring.datasource.druid.min-idle=4
spring.datasource.druid.max-active=10
spring.datasource.druid.max-wait=60000
spring.datasource.druid.pool-prepared-statements=true
spring.datasource.druid.max-pool-prepared-statement-per-connection-size=20
spring.datasource.druid.timeBetweenEvictionRunsMillis=60000
spring.datasource.druid.min-evictable-idle-time-millis=300000
spring.datasource.druid.validation-query=SELECT 1 FROM DUAL
spring.datasource.druid.test-while-idle=true
spring.datasource.druid.test-on-borrow=false
spring.datasource.druid.test-on-return=false
spring.datasource.druid.stat-view-servlet.enabled=true
spring.datasource.druid.stat-view-servlet.url-pattern=/monitor/druid/*
spring.datasource.druid.filter.stat.log-slow-sql=true
spring.datasource.druid.filter.stat.slow-sql-millis=1000
spring.datasource.druid.filter.stat.merge-sql=false
spring.datasource.druid.filter.wall.config.multi-statement-allow=true
logging.level.com.huaheng=INFO
logging.level.com.huaheng.pc=DEBUG
logging.level.org.springframework=ERROR
logging.level.spring.springboot.dao=ERROR
logging.level.com.huaheng.framework.aspectj=ERROR
logger.path=D:\\home\\WMSlog