application-druid-myhk.yml 6.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161
  1. # 数据源配置
  2. spring:
  3. profiles:
  4. include: config-myhk,common
  5. # redis 配置
  6. redis:
  7. host: 172.27.0.6
  8. port: 6379
  9. # 数据库索引
  10. database: 0
  11. # 密码
  12. password: myhk888777666.
  13. # 连接超时时间
  14. timeout: 10s
  15. lettuce:
  16. pool:
  17. # 连接池中的最小空闲连接
  18. min-idle: 0
  19. # 连接池中的最大空闲连接
  20. max-idle: 8
  21. # 连接池的最大数据库连接数
  22. max-active: 100
  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.27.0.17:3306/fs_his?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
  43. username: root
  44. password: myhk888777666.
  45. # 从库数据源
  46. slave:
  47. # 从数据源开关/默认关闭
  48. url: jdbc:mysql://172.27.0.38:3306/fs_his?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
  49. username: root
  50. password: myhk888777666.
  51. # 初始连接数
  52. initialSize: 5
  53. # 最小连接池数量
  54. minIdle: 10
  55. # 最大连接池数量
  56. maxActive: 20
  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.27.0.17:3306/fs_his_sop?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
  97. username: root
  98. password: myhk888777666.
  99. read:
  100. url: jdbc:mysql://172.27.0.38:3306/fs_his_sop?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
  101. username: root
  102. password: myhk888777666.
  103. # 初始连接数
  104. initialSize: 5
  105. # 最小连接池数量
  106. minIdle: 10
  107. # 最大连接池数量
  108. maxActive: 20
  109. # 配置获取连接等待超时的时间
  110. maxWait: 60000
  111. # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
  112. timeBetweenEvictionRunsMillis: 60000
  113. # 配置一个连接在池中最小生存的时间,单位是毫秒
  114. minEvictableIdleTimeMillis: 300000
  115. # 配置一个连接在池中最大生存的时间,单位是毫秒
  116. maxEvictableIdleTimeMillis: 900000
  117. # 配置检测连接是否有效
  118. validationQuery: SELECT 1 FROM DUAL
  119. testWhileIdle: true
  120. testOnBorrow: false
  121. testOnReturn: false
  122. webStatFilter:
  123. enabled: true
  124. statViewServlet:
  125. enabled: true
  126. # 设置白名单,不填则允许所有访问
  127. allow:
  128. url-pattern: /druid/*
  129. # 控制台管理用户名和密码
  130. login-username: fs
  131. login-password: 123456
  132. filter:
  133. stat:
  134. enabled: true
  135. # 慢SQL记录
  136. log-slow-sql: true
  137. slow-sql-millis: 1000
  138. merge-sql: true
  139. wall:
  140. config:
  141. multi-statement-allow: true
  142. rocketmq:
  143. name-server: rmq-16xj8o92zp.rocketmq.cd.qcloud.tencenttdmq.com:8080
  144. producer:
  145. group: my-producer-group
  146. access-key: ak16xj8o92zp984557f83ba2 # 替换为实际的 accessKey
  147. secret-key: sk2ff1c6b15b74b888 # 替换为实际的 secretKey
  148. consumer:
  149. group: common-group
  150. access-key: ak16xj8o92zp984557f83ba2 # 替换为实际的 accessKey
  151. secret-key: sk2ff1c6b15b74b888 # 替换为实际的 secretKey
  152. openIM:
  153. secret: openIM123
  154. userID: imAdmin
  155. url: https://im.muyi88.com/api
  156. #是否使用新im
  157. im:
  158. type: OPENIM
  159. #是否为新商户,新商户不走mpOpenId
  160. isNewWxMerchant: true