123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122 |
- # 项目相关配置
- gyee:
- #实时数据库Url
- #baseurl: http://10.0.118.73:8011/ts
- baseurl: http://123.60.213.70:8011/ts
- #实时数据库选择
- realtimedataBase: mongodb #数据查询模式 golden、hwy
- initialcode: INITIAL
- server:
- port: 8162
- servlet:
- context-path: /
- management:
- health:
- redis:
- enabled: false
- mybatis-plus:
- configuration:
- map-underscore-to-camel-case: true
- auto-mapping-behavior: full
- log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
- mapper-locations: classpath*:mapper/**/*Mapper.xml
- global-config:
- # 逻辑删除配置
- db-config:
- id-type: auto
- # 删除前
- logic-not-delete-value: 1
- # 删除后
- logic-delete-value: 0
- spring:
- main:
- allow-bean-definition-overriding: true #当遇到同样名字的时候,是否允许覆盖注册
- autoconfigure:
- exclude: org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration,org.springframework.boot.autoconfigure.jdbc.DataSourceTransactionManagerAutoConfiguration
- datasource:
- type: com.alibaba.druid.pool.DruidDataSource
- # driverClassName: com.mysql.jdbc.Driver
- #druid连接池配置
- druid:
- #主库数据源
- master:
- # url: jdbc:mysql://localhost:3306/springbootv2?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&useSSL=false&serverTimezone=UTC&zeroDateTimeBehavior=convertToNull
- # username: root
- # password: 123456
- #url: jdbc:oracle:thin:@10.0.118.71:1521:gdsj
- url: jdbc:oracle:thin:@123.60.213.70:1521:gdnxfd
- # username: gdprod
- # password: gd123
- username: nxfdprod
- password: gdnxfd123
- driver-class-name: oracle.jdbc.driver.OracleDriver
- #备数据源 #关闭
- slave:
- enabled: false
- url: jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&useSSL=false&serverTimezone=UTC
- username: root
- password: 123456
- #两票数据源
- ticket:
- #url: jdbc:sqlserver://10.0.118.71:1433;DatabaseName=fdeamnew
- url: jdbc:sqlserver://123.60.213.70:1434;DatabaseName=fdeam
- username: sa
- # password: ibs
- #password: Gd!123456
- password: Gyee@321#!
- driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
- #配置初始化连接数大小
- initial-size: 10
- # 最大连接数
- max-active: 50
- #最小连接数
- min-idle: 10
- #获取连接等待超时时间
- max-wait: 5000
- pool-prepared-statements: true #是否缓存preparedStatement,也就是PSCache。PSCache对支持游标的数据库性能提升巨大,比如说oracle。在mysql下建议关闭。
- max-pool-prepared-statement-per-connection-size: 20
- validation-query: SELECT 1 FROM DUAL
- validation-query-timeout: 20000
- test-on-borrow: false #申请连接时执行validationQuery检测连接是否有效,做了这个配置会降低性能。
- test-on-return: false #归还连接时执行validationQuery检测连接是否有效,做了这个配置会降低性能。
- test-while-idle: true #建议配置为true,不影响性能,并且保证安全性。申请连接的时候检测,如果空闲时间大于timeBetweenEvictionRunsMillis,执行validationQuery检测连接是否有效。
- time-between-eviction-runs-millis: 60000 #配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
- min-evictable-idle-time-millis: 300000 #一个连接在池中最小生存的时间,单位是毫秒
- #StatViewServlet配置。(因为暴露的监控信息比较敏感,支持密码加密和访问ip限定)
- stat-view-servlet:
- enabled: true
- url-pattern: /druid/*
- #可以增加访问账号密码【去掉注释就可以】
- #login-username: admin
- #login-password: admin
- filter:
- stat:
- log-slow-sql: true
- slow-sql-millis: 1000
- merge-sql: false
- wall:
- config:
- multi-statement-allow: true
- servlet:
- multipart:
- # 开启 multipart 上传功能
- enabled: true
- # 文件写入磁盘的阈值
- file-size-threshold: 2KB
- # 最大文件大小
- max-file-size: 200MB
- # 最大请求大小
- max-request-size: 215MB
- logging:
- level:
- root: info
- com.example: debug
- edos:
- baseURL: http://10.0.118.73:8011/ts
|