user-service-pro.yml 3.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113
  1. server:
  2. port: 8762
  3. # 驱动配置信息
  4. spring:
  5. datasource:
  6. druid:
  7. driver-class-name: com.mysql.cj.jdbc.Driver
  8. platform: mysql
  9. url: jdbc:mysql://192.168.2.236:3306/sys-user?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&useSSL=false
  10. username: root
  11. password: lantone
  12. # 连接池的配置信息
  13. # 初始化大小,最小,最大
  14. initialSize: 5
  15. minIdle: 5
  16. maxActive: 20
  17. # 配置获取连接等待超时的时间
  18. maxWait: 60000
  19. # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
  20. timeBetweenEvictionRunsMillis: 60000
  21. # 配置一个连接在池中最小生存的时间,单位是毫秒
  22. minEvictableIdleTimeMillis: 300000
  23. validationQuery: SELECT 1 FROM DUAL
  24. testWhileIdle: true
  25. testOnBorrow: false
  26. testOnReturn: false
  27. # 打开PSCache,并且指定每个连接上PSCache的大小
  28. poolPreparedStatements: true
  29. maxPoolPreparedStatementPerConnectionSize: 20
  30. # 配置监控统计拦截的filters,去掉后监控界面sql无法统计,'wall'用于防火墙
  31. filters.commons-log.connection-logger-name: stat,wall,log4j
  32. filter.stat.log-slow-sql: true
  33. filter.stat.slow-sql-millis: 2000
  34. #监控配置
  35. web-stat-filter:
  36. enabled: true
  37. url-pattern: /*
  38. exclusions: '*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*'
  39. # StatViewServlet配置,说明请参考Druid Wiki,配置_StatViewServlet配置
  40. stat-view-servlet:
  41. enabled: true
  42. url-pattern: /druid/*
  43. reset-enable: false
  44. login-username: root
  45. login-password: root
  46. cloud:
  47. stream:
  48. bindings:
  49. outputLog:
  50. destination: myLog
  51. # contentType: text/plain # 实体 json string 在传递的类型装换 查看 http://docs.spring
  52. #mq
  53. rabbitmq:
  54. host: 192.168.2.236
  55. port: 5672
  56. username: lantone
  57. password: lantone
  58. publisher-confirms: true
  59. virtual-host: /
  60. #redis
  61. redis:
  62. database:
  63. cache: 0 # Redis缓存索引
  64. idc: 1 # 不可见ID索引
  65. sms: 2 # Redis短信索引
  66. img: 3 # Redis图片验证码索引
  67. token: 4 # Token索引
  68. host: 192.168.2.236 #Redis服务器地址
  69. port: 6379 # Redis服务器连接端口
  70. password: lantone # Redis服务器连接密码(默认为空)
  71. lettuce:
  72. pool:
  73. max-active: 8 # 连接池最大连接数(使用负值表示没有限制)
  74. max-idle: 5 # 连接池中的最大空闲连接
  75. max-wait: -1 # 连接池最大阻塞等待时间(使用负值表示没有限制)
  76. min-idle: 0 # 连接池中的最小空闲连接
  77. timeout: 20000 # 连接超时时间(毫秒)
  78. #mybatis
  79. mybatis-plus:
  80. mapper-locations: classpath:/mapper/*Mapper.xml
  81. #实体扫描,多个package用逗号或者分号分隔
  82. typeAliasesPackage: com.diagbot.entity
  83. global-config:
  84. #刷新mapper 调试神器
  85. db-config:
  86. #主键类型 0:"数据库ID自增", 1:"用户输入ID",2:"全局唯一ID (数字类型唯一ID)", 3:"全局唯一ID UUID";
  87. id-type: id_worker
  88. #字段策略 0:"忽略判断",1:"非 NULL 判断"),2:"非空判断"
  89. field-strategy: not_empty
  90. #驼峰下划线转换
  91. column-underline: true
  92. #数据库大写下划线转换
  93. #capital-mode: true
  94. #刷新mapper 调试神器
  95. refresh-mapper: true
  96. #逻辑删除配置
  97. logic-delete-value: 0
  98. logic-not-delete-value: 1
  99. #自定义填充策略接口实现
  100. #meta-object-handler: com.baomidou.springboot.xxx
  101. #自定义SQL注入器
  102. #sql-injector: com.baomidou.springboot.xxx
  103. configuration:
  104. map-underscore-to-camel-case: true
  105. cache-enabled: false
  106. foo: foo version 1