application-druid-myhk-test.yml 6.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153
  1. # 数据源配置
  2. spring:
  3. profiles:
  4. include: config-druid-myhk,common
  5. # redis 配置
  6. redis:
  7. # host: 172.27.0.6
  8. host: 127.0.0.1
  9. port: 6379
  10. # 数据库索引
  11. database: 0
  12. # 密码
  13. # password: myhk888777666.
  14. password:
  15. # 连接超时时间
  16. timeout: 10s
  17. lettuce:
  18. pool:
  19. # 连接池中的最小空闲连接
  20. min-idle: 0
  21. # 连接池中的最大空闲连接
  22. max-idle: 8
  23. # 连接池的最大数据库连接数
  24. max-active: 100
  25. # #连接池最大阻塞等待时间(使用负值表示没有限制)
  26. max-wait: -1ms
  27. datasource:
  28. # clickhouse:
  29. # type: com.alibaba.druid.pool.DruidDataSource
  30. # driverClassName: com.clickhouse.jdbc.ClickHouseDriver
  31. # 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
  32. # username: rt_2024
  33. # password: Yzx_19860213
  34. # initialSize: 10
  35. # maxActive: 100
  36. # minIdle: 10
  37. # maxWait: 6000
  38. mysql:
  39. type: com.alibaba.druid.pool.DruidDataSource
  40. driverClassName: com.mysql.cj.jdbc.Driver
  41. druid:
  42. # 主库数据源
  43. master:
  44. url: jdbc:mysql://cd-cdb-5vtn8yte.sql.tencentcdb.com:22680/fs_his?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
  45. # url: jdbc:mysql://172.27.0.17:3306/fs_his?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
  46. username: root
  47. password: myhk888777666.
  48. # 从库数据源
  49. slave:
  50. # 从数据源开关/默认关闭
  51. enabled: false
  52. url:
  53. username:
  54. password:
  55. # 初始连接数
  56. initialSize: 5
  57. # 最小连接池数量
  58. minIdle: 10
  59. # 最大连接池数量
  60. maxActive: 20
  61. # 配置获取连接等待超时的时间
  62. maxWait: 60000
  63. # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
  64. timeBetweenEvictionRunsMillis: 60000
  65. # 配置一个连接在池中最小生存的时间,单位是毫秒
  66. minEvictableIdleTimeMillis: 300000
  67. # 配置一个连接在池中最大生存的时间,单位是毫秒
  68. maxEvictableIdleTimeMillis: 900000
  69. # 配置检测连接是否有效
  70. validationQuery: SELECT 1 FROM DUAL
  71. testWhileIdle: true
  72. testOnBorrow: false
  73. testOnReturn: false
  74. webStatFilter:
  75. enabled: true
  76. statViewServlet:
  77. enabled: true
  78. # 设置白名单,不填则允许所有访问
  79. allow:
  80. url-pattern: /druid/*
  81. # 控制台管理用户名和密码
  82. login-username: fs
  83. login-password: 123456
  84. filter:
  85. stat:
  86. enabled: true
  87. # 慢SQL记录
  88. log-slow-sql: true
  89. slow-sql-millis: 1000
  90. merge-sql: true
  91. wall:
  92. config:
  93. multi-statement-allow: true
  94. sop:
  95. type: com.alibaba.druid.pool.DruidDataSource
  96. driverClassName: com.mysql.cj.jdbc.Driver
  97. druid:
  98. # 主库数据源
  99. master:
  100. url: jdbc:mysql://cd-cdb-5vtn8yte.sql.tencentcdb.com:22680/fs_his_sop?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
  101. # url: jdbc:mysql://172.27.0.17:3306/fs_his_sop?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
  102. username: root
  103. password: myhk888777666.
  104. # 初始连接数
  105. initialSize: 5
  106. # 最小连接池数量
  107. minIdle: 10
  108. # 最大连接池数量
  109. maxActive: 20
  110. # 配置获取连接等待超时的时间
  111. maxWait: 60000
  112. # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
  113. timeBetweenEvictionRunsMillis: 60000
  114. # 配置一个连接在池中最小生存的时间,单位是毫秒
  115. minEvictableIdleTimeMillis: 300000
  116. # 配置一个连接在池中最大生存的时间,单位是毫秒
  117. maxEvictableIdleTimeMillis: 900000
  118. # 配置检测连接是否有效
  119. validationQuery: SELECT 1 FROM DUAL
  120. testWhileIdle: true
  121. testOnBorrow: false
  122. testOnReturn: false
  123. webStatFilter:
  124. enabled: true
  125. statViewServlet:
  126. enabled: true
  127. # 设置白名单,不填则允许所有访问
  128. allow:
  129. url-pattern: /druid/*
  130. # 控制台管理用户名和密码
  131. login-username: fs
  132. login-password: 123456
  133. filter:
  134. stat:
  135. enabled: true
  136. # 慢SQL记录
  137. log-slow-sql: true
  138. slow-sql-millis: 1000
  139. merge-sql: true
  140. wall:
  141. config:
  142. multi-statement-allow: true
  143. rocketmq:
  144. name-server: rmq-1243b25nj.rocketmq.gz.public.tencenttdmq.com:8080 # RocketMQ NameServer 地址
  145. producer:
  146. group: my-producer-group
  147. access-key: ak1243b25nj17d4b2dc1a03 # 替换为实际的 accessKey
  148. secret-key: sk08a7ea1f9f4b0237 # 替换为实际的 secretKey
  149. consumer:
  150. group: voice-group
  151. access-key: ak1243b25nj17d4b2dc1a03 # 替换为实际的 accessKey
  152. secret-key: sk08a7ea1f9f4b0237 # 替换为实际的 secretKey