ag-basic.yml 2.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  1. server:
  2. port: ${server.ag-basic-port}
  3. spring:
  4. datasource:
  5. driver-class-name: com.mysql.jdbc.Driver
  6. max-active: 50
  7. max-idle: 50 #最大空闲连接
  8. min-idle: 10 #最小空闲连接
  9. validation-query-timeout: 20
  10. log-validation-errors: true
  11. validation-interval: 60000 #避免过度验证,保证验证不超过这个频率——以毫秒为单位。如果一个连接应该被验证,但上次验证未达到指定间隔,将不再次验证。
  12. validation-query: SELECT 1 #SQL 查询, 用来验证从连接池取出的连接, 在将连接返回给调用者之前。 如果指定, 则查询必须是一个SQL SELECT 并且必须返回至少一行记录
  13. test-on-borrow: true #指明是否在从池中取出连接前进行检验, 如果检验失败, 则从池中去除连接并尝试取出另一个。注意: 设置为true 后如果要生效,validationQuery 参数必须设置为非空字符串
  14. test-on-return: true #指明是否在归还到池中前进行检验 注意: 设置为true 后如果要生效validationQuery 参数必须设置为非空字符串
  15. idle-timeout: 30000
  16. connection-test-query: SELECT 1
  17. num-tests-per-eviction-run: 50 #在每次空闲连接回收器线程(如果有)运行时检查的连接数量,最好和maxActive
  18. test-while-idle: true #指明连接是否被空闲连接回收器(如果有)进行检验,如果检测失败,则连接将被从池中去除
  19. min-evictable-idle-time-millis: 3600000 #连接池中连接,在时间段内一直空闲,被逐出连接池的时间(1000*60*60),以毫秒为单位
  20. time-between-eviction-runs-millis: 300000 #在空闲连接回收器线程运行期间休眠的时间值,以毫秒为单位,一般比minEvictableIdleTimeMillis小
  21. # sleuth:
  22. # sampler:
  23. # percentage: 1.0 #采用需要的请求的百分比 默认是0.1 即 10%
  24. zuul:
  25. config-priority: false
  26. ignored-services: '*'
  27. sensitive-headers:
  28. routes:
  29. svr-iot:
  30. path: /iot/**
  31. serviceId: svr-iot
  32. svr-base:
  33. path: /base/**
  34. serviceId: svr-base
  35. demo:
  36. path: /baidu/**
  37. url: https://www.baidu.com
  38. ---
  39. spring:
  40. profiles: jwdev
  41. datasource:
  42. url: jdbc:mysql://172.19.103.77/base?useUnicode:true&characterEncoding=utf-8&autoReconnect=true
  43. username: root
  44. password: 123456
  45. # zipkin:
  46. # base-url: http://localhost:9411 #日志追踪的地址
  47. ---
  48. spring:
  49. profiles: jwtest
  50. datasource:
  51. url: jdbc:mysql://172.19.103.77/base?useUnicode:true&characterEncoding=utf-8&autoReconnect=true
  52. username: root
  53. password: 123456
  54. # zipkin:
  55. # base-url: http://localhost:9411 #日志追踪的地址
  56. ---
  57. spring:
  58. profiles: jwprod
  59. datasource:
  60. url: jdbc:mysql://172.19.103.77/base?useUnicode:true&characterEncoding=utf-8&autoReconnect=true
  61. username: root
  62. password: 123456
  63. # zipkin:
  64. # base-url: http://localhost:9411 #日志追踪的地址