application-daoDev.yml 5.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149
  1. spring:
  2. datasource:
  3. druid:
  4. master:
  5. driver-class-name: com.mysql.cj.jdbc.Driver
  6. url: jdbc:mysql://123.60.19.203:5006/hitch-sb-demo?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8&autoReconnect=true&allowMultiQueries=true&removeAbandoned=true&removeAbandonedTimeout=60&logAbandoned=true
  7. username: root
  8. password: mysql?MYSQLmoniu123
  9. #url: jdbc:mysql://localhost:3306/hitch-sb?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&allowMultiQueries=true
  10. #username: root
  11. #password: 123456
  12. filters: wall,stat
  13. filter:
  14. stat:
  15. log-slow-sql: true
  16. #慢sql
  17. slow-sql-millis: 1000
  18. #初始化大小、最小、最大
  19. initial-size: 1
  20. max-active: 50
  21. max-pool-prepared-statement-per-connection-size: 20
  22. #获取连接等待超时的时间
  23. max-wait: 60000
  24. #一个连接在池中最小生存的时间,单位是毫秒
  25. min-evictable-idle-time-millis: 300000
  26. min-idle: 5
  27. #打开PSCache,并且指定每个连接上PSCache的大小
  28. #如果用Oracle,则把poolPreparedStatements配置为true,mysql可以配置为false。分库分表较多的数据库,建议配置为false。
  29. pool-prepared-statements: false
  30. test-on-borrow: true
  31. test-on-return: true
  32. test-while-idle: true
  33. #间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
  34. time-between-eviction-runs-millis: 60000
  35. validation-query: SELECT 'x'
  36. slave:
  37. driver-class-name: com.mysql.cj.jdbc.Driver
  38. url: jdbc:mysql://123.60.19.203:5006/hitch-sb?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&allowMultiQueries=true
  39. username: root
  40. password: mysql?MYSQLmoniu123
  41. #url: jdbc:mysql://localhost:3306/hitch-sb?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&allowMultiQueries=true
  42. #username: root
  43. #password: 123456
  44. filters: wall,stat
  45. filter:
  46. stat:
  47. log-slow-sql: true
  48. #慢sql
  49. slow-sql-millis: 1000
  50. #初始化大小、最小、最大
  51. initial-size: 1
  52. max-active: 50
  53. max-pool-prepared-statement-per-connection-size: 20
  54. #获取连接等待超时的时间
  55. max-wait: 60000
  56. #一个连接在池中最小生存的时间,单位是毫秒
  57. min-evictable-idle-time-millis: 300000
  58. min-idle: 5
  59. #打开PSCache,并且指定每个连接上PSCache的大小
  60. #如果用Oracle,则把poolPreparedStatements配置为true,mysql可以配置为false。分库分表较多的数据库,建议配置为false。
  61. pool-prepared-statements: false
  62. test-on-borrow: true
  63. test-on-return: true
  64. test-while-idle: true
  65. #间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
  66. time-between-eviction-runs-millis: 60000
  67. validation-query: SELECT 'x'
  68. qykh:
  69. driver-class-name: com.mysql.cj.jdbc.Driver
  70. url: jdbc:mysql://139.159.196.89:33306/qykh?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&allowMultiQueries=true
  71. username: qykh
  72. password: qykh@CQDWJS@!123
  73. filters: wall,stat
  74. filter:
  75. stat:
  76. log-slow-sql: true
  77. #慢sql
  78. slow-sql-millis: 1000
  79. #初始化大小、最小、最大
  80. initial-size: 1
  81. max-active: 50
  82. max-pool-prepared-statement-per-connection-size: 20
  83. #获取连接等待超时的时间
  84. max-wait: 60000
  85. #一个连接在池中最小生存的时间,单位是毫秒
  86. min-evictable-idle-time-millis: 300000
  87. min-idle: 5
  88. #打开PSCache,并且指定每个连接上PSCache的大小
  89. #如果用Oracle,则把poolPreparedStatements配置为true,mysql可以配置为false。分库分表较多的数据库,建议配置为false。
  90. pool-prepared-statements: false
  91. test-on-borrow: true
  92. test-on-return: true
  93. test-while-idle: true
  94. #间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
  95. time-between-eviction-runs-millis: 60000
  96. validation-query: SELECT 'x'
  97. stat-view-servlet:
  98. login-password: platform8888
  99. login-username: root
  100. stat-view-servlet:
  101. login-password: platform8888
  102. login-username: root
  103. jpa:
  104. properties:
  105. hibernate:
  106. temp:
  107. use_jdbc_metadata_defaults: false
  108. dialect: org.hibernate.dialect.MySQLDialect
  109. # mybaits配置 tk
  110. mybatis:
  111. mapper-locations: classpath:mapper/**/*.xml
  112. configuration:
  113. map-underscore-to-camel-case: true
  114. call-setters-on-nulls: true
  115. jdbc-type-for-null: NULL
  116. # mybaits配置 tk
  117. mapper:
  118. mappers:
  119. - com.platform.dao.config.MyMapper
  120. not-empty: false
  121. identity: MYSQL
  122. data:
  123. aspect:
  124. method:
  125. names: get,select
  126. quartz:
  127. datasource:
  128. quartzDataSource:
  129. driver: ${spring.datasource.druid.master.driver-class-name}
  130. url: ${spring.datasource.druid.master.url}
  131. user: ${spring.datasource.druid.master.username}
  132. password: ${spring.datasource.druid.master.password}
  133. maxConnections: 5
  134. validationQuery: select 0
  135. connection-provider:
  136. class: com.platform.dao.quartz.DruidConnectionProvider
  137. logging:
  138. level:
  139. com.platform.dao.mapper: DEBUG
  140. org.activiti: DEBUG
  141. influx:
  142. url: http://localhost:8086
  143. token: qEMI2lHel0NPscN32WgmZtuymxmYZZZv67hHeRGA2_VJ_gd5sHH_QTyZ34T_ThhcbwFaqx4Qs9Q5BQBNpfMLkg==