application-druid-myhk.yml 6.5 KB

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