application.yml 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280
  1. server:
  2. port: 8081
  3. spring:
  4. datasource:
  5. primaryReadWrite:
  6. driver-class-name: com.mysql.jdbc.Driver
  7. max-active: 50
  8. max-idle: 50 #最大空闲连接
  9. min-idle: 10 #最小空闲连接
  10. validation-query-timeout: 20
  11. log-validation-errors: true
  12. validation-interval: 60000 #避免过度验证,保证验证不超过这个频率——以毫秒为单位。如果一个连接应该被验证,但上次验证未达到指定间隔,将不再次验证。
  13. validation-query: SELECT 1 #SQL 查询, 用来验证从连接池取出的连接, 在将连接返回给调用者之前。 如果指定, 则查询必须是一个SQL SELECT 并且必须返回至少一行记录
  14. test-on-borrow: true #指明是否在从池中取出连接前进行检验, 如果检验失败, 则从池中去除连接并尝试取出另一个。注意: 设置为true 后如果要生效,validationQuery 参数必须设置为非空字符串
  15. test-on-return: true #指明是否在归还到池中前进行检验 注意: 设置为true 后如果要生效validationQuery 参数必须设置为非空字符串
  16. idle-timeout: 30000
  17. connection-test-query: SELECT 1
  18. num-tests-per-eviction-run: 50 #在每次空闲连接回收器线程(如果有)运行时检查的连接数量,最好和maxActive
  19. test-while-idle: true #指明连接是否被空闲连接回收器(如果有)进行检验,如果检测失败,则连接将被从池中去除
  20. min-evictable-idle-time-millis: 3600000 #连接池中连接,在时间段内一直空闲,被逐出连接池的时间(1000*60*60),以毫秒为单位
  21. time-between-eviction-runs-millis: 300000 #在空闲连接回收器线程运行期间休眠的时间值,以毫秒为单位,一般比minEvictableIdleTimeMillis小
  22. primaryRead:
  23. driver-class-name: com.mysql.jdbc.Driver
  24. max-active: 50
  25. max-idle: 50 #最大空闲连接
  26. min-idle: 10 #最小空闲连接
  27. validation-query-timeout: 20
  28. log-validation-errors: true
  29. validation-interval: 60000 #避免过度验证,保证验证不超过这个频率——以毫秒为单位。如果一个连接应该被验证,但上次验证未达到指定间隔,将不再次验证。
  30. validation-query: SELECT 1 #SQL 查询, 用来验证从连接池取出的连接, 在将连接返回给调用者之前。 如果指定, 则查询必须是一个SQL SELECT 并且必须返回至少一行记录
  31. test-on-borrow: true #指明是否在从池中取出连接前进行检验, 如果检验失败, 则从池中去除连接并尝试取出另一个。注意: 设置为true 后如果要生效,validationQuery 参数必须设置为非空字符串
  32. test-on-return: true #指明是否在归还到池中前进行检验 注意: 设置为true 后如果要生效validationQuery 参数必须设置为非空字符串
  33. idle-timeout: 30000
  34. connection-test-query: SELECT 1
  35. num-tests-per-eviction-run: 50 #在每次空闲连接回收器线程(如果有)运行时检查的连接数量,最好和maxActive
  36. test-while-idle: true #指明连接是否被空闲连接回收器(如果有)进行检验,如果检测失败,则连接将被从池中去除
  37. min-evictable-idle-time-millis: 3600000 #连接池中连接,在时间段内一直空闲,被逐出连接池的时间(1000*60*60),以毫秒为单位
  38. time-between-eviction-runs-millis: 300000 #在空闲连接回收器线程运行期间休眠的时间值,以毫秒为单位,一般比minEvictableIdleTimeMillis小
  39. im:
  40. driver-class-name: com.mysql.jdbc.Driver
  41. max-active: 50
  42. max-idle: 50 #最大空闲连接
  43. min-idle: 10 #最小空闲连接
  44. validation-query-timeout: 20
  45. log-validation-errors: true
  46. validation-interval: 60000 #避免过度验证,保证验证不超过这个频率——以毫秒为单位。如果一个连接应该被验证,但上次验证未达到指定间隔,将不再次验证。
  47. validation-query: SELECT 1 #SQL 查询, 用来验证从连接池取出的连接, 在将连接返回给调用者之前。 如果指定, 则查询必须是一个SQL SELECT 并且必须返回至少一行记录
  48. test-on-borrow: true #指明是否在从池中取出连接前进行检验, 如果检验失败, 则从池中去除连接并尝试取出另一个。注意: 设置为true 后如果要生效,validationQuery 参数必须设置为非空字符串
  49. test-on-return: true #指明是否在归还到池中前进行检验 注意: 设置为true 后如果要生效validationQuery 参数必须设置为非空字符串
  50. idle-timeout: 30000
  51. connection-test-query: SELECT 1
  52. num-tests-per-eviction-run: 50 #在每次空闲连接回收器线程(如果有)运行时检查的连接数量,最好和maxActive
  53. test-while-idle: true #指明连接是否被空闲连接回收器(如果有)进行检验,如果检测失败,则连接将被从池中去除
  54. min-evictable-idle-time-millis: 3600000 #连接池中连接,在时间段内一直空闲,被逐出连接池的时间(1000*60*60),以毫秒为单位
  55. time-between-eviction-runs-millis: 300000 #在空闲连接回收器线程运行期间休眠的时间值,以毫秒为单位,一般比minEvictableIdleTimeMillis小
  56. # REDIS
  57. redis:
  58. database: 0 # Database index used by the connection factory.
  59. password: # Login password of the redis server.
  60. timeout: 0 # Connection timeout in milliseconds.
  61. #sentinel:
  62. # master: # Name of Redis server.
  63. # nodes: # Comma-separated list of host:port pairs.
  64. pool:
  65. max-active: 8 # Max number of connections that can be allocated by the pool at a given time. Use a negative value for no limit.
  66. max-idle: 8 # Max number of "idle" connections in the pool. Use a negative value to indicate an unlimited number of idle connections.
  67. max-wait: -1 # Maximum amount of time (in milliseconds) a connection allocation should block before throwing an exception when the pool is exhausted. Use a negative value to block indefinitely.
  68. min-idle: 1 # Target for the minimum number of idle connections to maintain in the pool. This setting only has an effect if it is positive.
  69. multipart:
  70. max-file-size: 100MB
  71. max-request-size: 100MB
  72. security:
  73. basic:
  74. username: jkzl
  75. password: jkzlehr
  76. logging:
  77. level:
  78. root: INFO
  79. redis:
  80. quota:
  81. current:
  82. expire: 24 #实时统计redis 的过期时间 默认是2小时
  83. ---
  84. spring:
  85. profiles: test
  86. datasource:
  87. primaryReadWrite:
  88. url: jdbc:mysql://172.19.103.85/data_for_stats?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  89. username: linzhou
  90. password: linzhou
  91. primaryRead:
  92. url: jdbc:mysql://172.19.103.85/data_for_stats?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  93. username: linzhou
  94. password: linzhou
  95. im: #im库
  96. url: jdbc:mysql://172.17.110.160/im_new?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  97. username: linzhou
  98. password: linzhou
  99. redis:
  100. host: 172.19.103.88 # Redis server host.
  101. port: 6379 # Redis server port.
  102. followupMessage:
  103. cron : 0 5 0 * * ?
  104. jobId : FOLLOWUP_PLAN_JOB
  105. fv:
  106. jdbc:
  107. driver: com.mysql.jdbc.Driver
  108. url: jdbc:mysql://172.17.110.160/fv?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  109. username: ssgg
  110. password: ssgg
  111. systemConfig:
  112. msg_push_server: http://127.0.0.1:3000
  113. es:
  114. index: wlyy_quota_test
  115. type: wlyy_quota_test
  116. host: 172.19.103.68
  117. port: 9200
  118. tPort: 9300
  119. clusterName: jkzl
  120. wlyy:
  121. im:
  122. databaseName: im_new
  123. ---
  124. spring:
  125. profiles: prod
  126. datasource:
  127. primaryReadWrite:
  128. url: jdbc:mysql://59.61.92.94:3306/wlyy?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  129. username: wlyy
  130. password: jkzlehr@123
  131. primaryRead:
  132. url: jdbc:mysql://59.61.92.94:8883/wlyy?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  133. username: wlyy
  134. password: jkzlehr@123
  135. im: #im库:
  136. url: jdbc:mysql://59.61.92.94/im?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  137. username: im
  138. password: im!)123
  139. redis:
  140. host: 120.41.253.95 # Redis server host.
  141. port: 6380 # Redis server port.
  142. password: jkzl_ehr
  143. followupMessage:
  144. cron : 0 5 0 * * ?
  145. jobId : FOLLOWUP_PLAN_JOB
  146. fv:
  147. jdbc:
  148. driver: com.mysql.jdbc.Driver
  149. url: jdbc:mysql://59.61.92.94:8883/fv?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  150. username: wlyy
  151. password: jkzlehr@123
  152. systemConfig:
  153. msg_push_server: http://127.0.0.1:3000
  154. es:
  155. host: 192.168.1.1
  156. wlyy:
  157. im:
  158. databaseName: im
  159. ---
  160. spring:
  161. profiles: dev
  162. datasource:
  163. primaryReadWrite: #只读库 主库
  164. url: jdbc:mysql://172.19.103.77/wlyy?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  165. username: root
  166. password: 123456
  167. # url: jdbc:mysql://172.19.103.85/wlyy?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  168. # username: linzhou
  169. # password: linzhou
  170. primaryRead: #只读库 从库
  171. url: jdbc:mysql://172.19.103.77/wlyy?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  172. username: root
  173. password: 123456
  174. # url: jdbc:mysql://172.19.103.85/wlyy?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  175. # username: linzhou
  176. # password: linzhou
  177. im: #im库
  178. url: jdbc:mysql://172.19.103.77/ichat?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  179. username: root
  180. password: 123456
  181. redis:
  182. host: 172.19.103.88 # Redis server host.
  183. port: 6379 # Redis server port.
  184. followupMessage:
  185. cron : 0 5 0 * * ?
  186. jobId : FOLLOWUP_PLAN_JOB
  187. fv:
  188. jdbc:
  189. driver: com.mysql.jdbc.Driver
  190. url: jdbc:mysql://172.19.103.77/fv?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  191. username: root
  192. password: 123456
  193. systemConfig:
  194. msg_push_server: http://172.19.103.76:3000
  195. es:
  196. index: wlyy_quota_dev
  197. type: wlyy_quota_dev
  198. host: 172.19.103.68:9200
  199. wlyy:
  200. im:
  201. databaseName: im_new
  202. ---
  203. spring:
  204. profiles: lxx
  205. datasource:
  206. primaryReadWrite: #只读库 主库
  207. url: jdbc:mysql://172.19.103.77/wlyy?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  208. username: root
  209. password: 123456
  210. primaryRead: #只读库 从库
  211. url: jdbc:mysql://172.19.103.77/wlyy?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  212. username: root
  213. password: 123456
  214. im: #im库
  215. url: jdbc:mysql://172.19.103.77/ichat?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  216. username: root
  217. password: 123456
  218. redis:
  219. host: 172.19.103.88 # Redis server host.
  220. port: 6379 # Redis server port.
  221. followupMessage:
  222. cron : 0 5 0 * * ?
  223. jobId : FOLLOWUP_PLAN_JOB
  224. fv:
  225. jdbc:
  226. driver: com.mysql.jdbc.Driver
  227. url: jdbc:mysql://172.19.103.77/fv?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
  228. username: root
  229. password: 123456
  230. systemConfig:
  231. msg_push_server: http://172.19.103.76:3000