application-druid.properties
4.34 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
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
# server
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.
spring.datasource.druid.slave1.open=true
spring.datasource.druid.slave1.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.slave1.username=root
spring.datasource.druid.slave1.password=HHsoft123.
spring.datasource.druid.slave2.open=true
spring.datasource.druid.slave2.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.slave2.username=root
spring.datasource.druid.slave2.password=HHsoft123.
# aliyun
#spring.datasource.druid.master.url=jdbc:mysql://110.41.55.145:3366/wms_shandonghaiwang?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
#spring.datasource.druid.master.username=root
#spring.datasource.druid.master.password=qq123456
#
#spring.datasource.druid.slave1.open=true
#spring.datasource.druid.slave1.url=jdbc:mysql://110.41.55.145:3366/wms_shandonghaiwang2?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
#spring.datasource.druid.slave1.username=root
#spring.datasource.druid.slave1.password=qq123456
#
#spring.datasource.druid.slave2.open=true
#spring.datasource.druid.slave2.url=jdbc:mysql://110.41.55.145:3366/wms_shandonghaiwang3?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
#spring.datasource.druid.slave2.username=root
#spring.datasource.druid.slave2.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
#
#spring.datasource.druid.slave1.open=true
#spring.datasource.druid.slave1.url=jdbc:mysql://localhost:3306/wms_shandonghaiwang2?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
#spring.datasource.druid.slave1.username=root
#spring.datasource.druid.slave1.password=123456
#
#spring.datasource.druid.slave2.open=true
#spring.datasource.druid.slave2.url=jdbc:mysql://localhost:3306/wms_shandonghaiwang3?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8
#spring.datasource.druid.slave2.username=root
#spring.datasource.druid.slave2.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