datasource-mysql.yml 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. --- # 数据源配置
  2. spring:
  3. datasource:
  4. type: com.zaxxer.hikari.HikariDataSource
  5. mybatis-flex:
  6. # sql审计
  7. audit_enable: false
  8. # sql打印
  9. sql_print: true
  10. # 数据源
  11. datasource:
  12. # 数据源1
  13. ds1:
  14. type: ${spring.datasource.type}
  15. # MySql
  16. driver-class-name: com.mysql.cj.jdbc.Driver
  17. url: jdbc:mysql://localhost:3306/eco-boot?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true
  18. username: root
  19. password: root123
  20. #DM8数据库
  21. # driver-class-name: dm.jdbc.driver.DmDriver
  22. # url: jdbc:dm://127.0.0.1:5236?schema=eco-boot&useUnicode=true&characterEncoding=utf8&useSSL=true&autoReconnect=true&reWriteBatchedInserts=true
  23. # username: SYSDBA
  24. # password: SYSdba123
  25. # 最大连接池数量
  26. maximum-pool-size: 20
  27. # 最小空闲线程数量
  28. minimum-idle: 10
  29. # 配置获取连接等待超时的时间
  30. connectionTimeout: 60000
  31. # 校验超时时间
  32. validationTimeout: 5000
  33. # 空闲连接存活最大时间,默认10分钟
  34. idleTimeout: 600000
  35. # 此属性控制池中连接的最长生命周期,值0表示无限生命周期,默认30分钟
  36. maxLifetime: 1800000
  37. # 多久检查一次连接的活性
  38. keepaliveTime: 30000
  39. # 数据源2
  40. # ds2:
  41. # url: jdbc:mysql://127.0.0.1:3306/eco1
  42. # username: root
  43. # password: root123