application-druid.properties
3.47 KB
#数据源配置spring.datasource.type=com.alibaba.druid.pool.DruidDataSourcespring.datasource.driverClassName=com.mysql.cj.jdbc.Driver# 主库#spring.datasource.druid.master.url=jdbc:mysql://127.0.0.1:3306/wms_guangxijianyi?useUnicode=true&charact1erEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8&autoReconnect=true&maxReconnects=9999&initialTimeout=30#spring.datasource.druid.master.url=jdbc:mysql://47.106.215.73:3001/wms_guangxijianyi?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8#spring.datasource.druid.master.url=jdbc:mysql://10.2.128.101:3306/wms_guangxijianyi?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8&autoReconnect=true&maxReconnects=9999&initialTimeout=30&rewriteBatchedStatements=truespring.datasource.druid.master.url=jdbc:mysql://ltyaxl.51vip.biz:11633/wms_guangxijianyi?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8#spring.datasource.druid.master.username=softhuaheng_wms#spring.datasource.druid.master.password=HHsoft123.spring.datasource.druid.master.username=rootspring.datasource.druid.master.password=HHrobot123.#spring.datasource.druid.master.username=root#spring.datasource.druid.master.password=HHrobot123.#spring.datasource.druid.master.username=root#spring.datasource.druid.master.password=HHsoft123.# 从库#spring.datasource.druid.slave.open = false#spring.datasource.druid.slave.url=jdbc:mysql://117.62.222.186:3306/wms_v2?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false#spring.datasource.druid.slave.username=softhuaheng#spring.datasource.druid.slave.password=HHrobot123.#WCS库spring.datasource.druid.wcs.url = jdbc:mysql://172.16.29.45:3306/huahengwcs3?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8spring.datasource.druid.wcs.username=softhuahengspring.datasource.druid.wcs.password=HHrobot123.# 初始连接数spring.datasource.druid.initial-size=10# 最大连接池数量,以当前CPU核数加2spring.datasource.druid.max-active=64# 最小连接池数量spring.datasource.druid.min-idle=8# 配置获取连接等待超时的时间spring.datasource.druid.max-wait=5000# 打开PSCache，并且指定每个连接上PSCache的大小spring.datasource.druid.pool-prepared-statements=truespring.datasource.druid.max-pool-prepared-statement-per-connection-size=20# 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒spring.datasource.druid.timeBetweenEvictionRunsMillis=30000# 配置一个连接在池中最小生存的时间，单位是毫秒spring.datasource.druid.min-evictable-idle-time-millis=300000spring.datasource.druid.validation-query=SELECT 1 FROM DUALspring.datasource.druid.test-while-idle=truespring.datasource.druid.test-on-borrow=falsespring.datasource.druid.test-on-return=falsespring.datasource.druid.stat-view-servlet.enabled=truespring.datasource.druid.stat-view-servlet.url-pattern=/monitor/druid/*spring.datasource.druid.filter.stat.log-slow-sql=truespring.datasource.druid.filter.stat.slow-sql-millis=1000spring.datasource.druid.filter.stat.merge-sql=falsespring.datasource.druid.filter.wall.config.multi-statement-allow=true#日志配置logging.level.com.huaheng=infologging.level.org.springframework=warnlogging.level.spring.springboot.dao=infologger.path=D:\\home\\WMSlog