#数据源配置 spring.datasource.type=com.alibaba.druid.pool.DruidDataSource spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver # 主库 #spring.datasource.druid.master.url=jdbc:mysql://172.16.29.45:3306/hhwmstestks?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8 #spring.datasource.druid.master.url=jdbc:mysql://172.16.2.8:3306/hhwms?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8 spring.datasource.druid.master.url=jdbc:mysql://172.16.2.8:3306/hhwms?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8&autoReconnect=true&failOverReadOnly=false&maxReconnects=9999&initialTimeout=30&rewriteBatchedStatements=true #spring.datasource.druid.master.url=jdbc:mysql://172.16.29.45:3306/huahengExample?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false #spring.datasource.druid.master.url=jdbc:mysql://117.62.222.186:3306/wms_v2?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8 spring.datasource.druid.master.username=softhuaheng spring.datasource.druid.master.password=HHrobot123. #spring.datasource.druid.master.username=root #spring.datasource.druid.master.password=hhsoftware #spring.datasource.druid.master.username=root #spring.datasource.druid.master.password=hhsoftware # 从库 #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.2.8:3306/kshuaheng?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2b8 spring.datasource.druid.wcs.username=softhuaheng spring.datasource.druid.wcs.password=HHrobot123. # 初始连接数 spring.datasource.druid.initial-size=10 # 最大连接池数量,以当前CPU核数加2 spring.datasource.druid.max-active=10 # 最小连接池数量 spring.datasource.druid.min-idle=8 # 配置获取连接等待超时的时间 spring.datasource.druid.max-wait=30000 # 打开PSCache,并且指定每个连接上PSCache的大小 spring.datasource.druid.pool-prepared-statements=true spring.datasource.druid.max-pool-prepared-statement-per-connection-size=20 # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 spring.datasource.druid.timeBetweenEvictionRunsMillis=30000 # 配置一个连接在池中最小生存的时间,单位是毫秒 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=debug logging.level.org.springframework=warn logging.level.spring.springboot.dao=DEBUG logger.path=D:\\home\\WMSlog