application-druid-syysy.yml 7.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168
  1. # 数据源配置
  2. spring:
  3. profiles:
  4. include: config-druid-syysy,common
  5. # redis 配置
  6. redis:
  7. host: 172.16.0.13
  8. port: 6379
  9. # 数据库索引
  10. database: 0
  11. # 密码
  12. password: Ylrz_tM8/oW6$pU9|tJ#&
  13. # 连接超时时间
  14. timeout: 10s
  15. lettuce:
  16. pool:
  17. # 连接池中的最小空闲连接
  18. min-idle: 0
  19. # 连接池中的最大空闲连接
  20. max-idle: 8
  21. # 连接池的最大数据库连接数
  22. max-active: 8
  23. # #连接池最大阻塞等待时间(使用负值表示没有限制)
  24. max-wait: -1ms
  25. datasource:
  26. # clickhouse:
  27. # type: com.alibaba.druid.pool.DruidDataSource
  28. # driverClassName: com.clickhouse.jdbc.ClickHouseDriver
  29. # url: jdbc:clickhouse://1.14.104.71:8123/sop_test?compress=0&use_server_time_zone=true&use_client_time_zone=false&timezone=Asia/Shanghai
  30. # username: rt_2024
  31. # password: Yzx_19860213
  32. # initialSize: 10
  33. # maxActive: 100
  34. # minIdle: 10
  35. # maxWait: 6000
  36. mysql:
  37. type: com.alibaba.druid.pool.DruidDataSource
  38. driverClassName: com.mysql.cj.jdbc.Driver
  39. druid:
  40. # 主库数据源
  41. master:
  42. url: jdbc:mysql://172.16.0.7:3306/fs_his?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
  43. username: root
  44. password: Ylrz_tM818782145I@
  45. # 从库数据源
  46. slave:
  47. # 从数据源开关/默认关闭
  48. url: jdbc:mysql://172.16.0.16:3306/fs_his?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
  49. username: root
  50. password: Ylrz_tM818782145I@
  51. # 初始连接数
  52. initialSize: 5
  53. # 最小连接池数量
  54. minIdle: 10
  55. # 最大连接池数量
  56. maxActive: 2000
  57. # 配置获取连接等待超时的时间
  58. maxWait: 60000
  59. # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
  60. timeBetweenEvictionRunsMillis: 60000
  61. # 配置一个连接在池中最小生存的时间,单位是毫秒
  62. minEvictableIdleTimeMillis: 300000
  63. # 配置一个连接在池中最大生存的时间,单位是毫秒
  64. maxEvictableIdleTimeMillis: 900000
  65. # 配置检测连接是否有效
  66. validationQuery: SELECT 1 FROM DUAL
  67. testWhileIdle: true
  68. testOnBorrow: false
  69. testOnReturn: false
  70. webStatFilter:
  71. enabled: true
  72. statViewServlet:
  73. enabled: true
  74. # 设置白名单,不填则允许所有访问
  75. allow:
  76. url-pattern: /druid/*
  77. # 控制台管理用户名和密码
  78. login-username: fs
  79. login-password: 123456
  80. filter:
  81. stat:
  82. enabled: true
  83. # 慢SQL记录
  84. log-slow-sql: true
  85. slow-sql-millis: 1000
  86. merge-sql: true
  87. wall:
  88. config:
  89. multi-statement-allow: true
  90. sop:
  91. type: com.alibaba.druid.pool.DruidDataSource
  92. driverClassName: com.mysql.cj.jdbc.Driver
  93. druid:
  94. # 主库数据源
  95. master:
  96. url: jdbc:mysql://172.16.0.7:3306/sop?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
  97. username: root
  98. password: Ylrz_tM818782145I@
  99. # 初始连接数
  100. initialSize: 5
  101. # 最小连接池数量
  102. minIdle: 10
  103. # 最大连接池数量
  104. maxActive: 200
  105. # 配置获取连接等待超时的时间
  106. maxWait: 60000
  107. # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
  108. timeBetweenEvictionRunsMillis: 60000
  109. # 配置一个连接在池中最小生存的时间,单位是毫秒
  110. minEvictableIdleTimeMillis: 300000
  111. # 配置一个连接在池中最大生存的时间,单位是毫秒
  112. maxEvictableIdleTimeMillis: 900000
  113. # 配置检测连接是否有效
  114. validationQuery: SELECT 1 FROM DUAL
  115. testWhileIdle: true
  116. testOnBorrow: false
  117. testOnReturn: false
  118. webStatFilter:
  119. enabled: true
  120. statViewServlet:
  121. enabled: true
  122. # 设置白名单,不填则允许所有访问
  123. allow:
  124. url-pattern: /druid/*
  125. # 控制台管理用户名和密码
  126. login-username: fs
  127. login-password: 123456
  128. filter:
  129. stat:
  130. enabled: true
  131. # 慢SQL记录
  132. log-slow-sql: true
  133. slow-sql-millis: 1000
  134. merge-sql: true
  135. wall:
  136. config:
  137. multi-statement-allow: true
  138. rocketmq:
  139. name-server: rmq-1243b25nj.rocketmq.gz.public.tencenttdmq.com:8080 # RocketMQ NameServer 地址
  140. producer:
  141. group: my-producer-group
  142. access-key: ak1243b25nj17d4b2dc1a03 # 替换为实际的 accessKey
  143. secret-key: sk08a7ea1f9f4b0237 # 替换为实际的 secretKey
  144. consumer:
  145. group: voice-group
  146. access-key: ak1243b25nj17d4b2dc1a03 # 替换为实际的 accessKey
  147. secret-key: sk08a7ea1f9f4b0237 # 替换为实际的 secretKey
  148. custom:
  149. token: "1o62d3YxvdHd4LEUiltnu7sK"
  150. encoding-aes-key: "UJfTQ5qKTKlegjkXtp1YuzJzxeHlUKvq5GyFbERN1iU"
  151. corp-id: "ww51717e2b71d5e2d3"
  152. secret: "6ODAmw-8W4t6h9mdzHh2Z4Apwj8mnsyRnjEDZOHdA7k"
  153. private-key-path: "privatekey.pem"
  154. webhook-url: "https://your-server.com/wecom/archive"
  155. # token配置
  156. token:
  157. # 令牌自定义标识
  158. header: Authorization
  159. # 令牌密钥
  160. secret: abcdefghijklmnopqrstuvwxyz
  161. # 令牌有效期(默认30分钟)
  162. expireTime: 180
  163. openIM:
  164. secret: openIM123
  165. userID: imAdmin
  166. url: https://web.im.ysya.top/api
  167. #是否为新商户,新商户不走mpOpenId
  168. isNewWxMerchant: true