12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364 |
- datasource:
- system-master:
- # jdbc 所有参数配置参考 https://lionli.blog.csdn.net/article/details/122018562
- # rewriteBatchedStatements=true 批处理优化 大幅提升批量插入更新删除性能
- url: jdbc:kingbase8://39.98.79.140:54321/ykt_cloud?currentSchema=dbo&allowEncodingChanges=true&clientEncoding=UTF8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true
- username: root
- password: 852!@#258
- drivername: com.kingbase8.Driver
- gen:
- url: jdbc:kingbase8://39.98.79.140:54321/ykt_cloud?currentSchema=dbo&allowEncodingChanges=true&clientEncoding=UTF8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true
- username: root
- password: 852!@#258
- drivername: com.kingbase8.Driver
- job:
- url: jdbc:kingbase8://39.98.79.140:54321/ykt_job?currentSchema=dbo&allowEncodingChanges=true&clientEncoding=UTF8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true
- username: root
- password: 852!@#258
- drivername: com.kingbase8.Driver
- workflow:
- url: jdbc:kingbase8://39.98.79.140:54321/ykt_workflow?currentSchema=dbo&allowEncodingChanges=true&clientEncoding=UTF8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true
- username: root
- password: 852!@#258
- drivername: com.kingbase8.Driver
- storage:
- url: jdbc:kingbase8://39.98.79.140:54321/ykt_storage?currentSchema=dbo&allowEncodingChanges=true&clientEncoding=UTF8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true
- username: root
- password: 852!@#258
- drivername: com.kingbase8.Driver
- # system-oracle:
- # url: jdbc:oracle:thin:@//localhost:1521/XE
- # username: ROOT
- # password: password
- # system-postgres:
- # url: jdbc:postgresql://localhost:5432/postgres?useUnicode=true&characterEncoding=utf8&useSSL=true&autoReconnect=true&reWriteBatchedInserts=true
- # username: root
- # password: password
- spring:
- datasource:
- type: com.zaxxer.hikari.HikariDataSource
- # 动态数据源文档 https://www.kancloud.cn/tracy5546/dynamic-datasource/content
- dynamic:
- # 性能分析插件(有性能损耗 不建议生产环境使用)
- p6spy: true
- # 开启seata代理,开启后默认每个数据源都代理,如果某个不需要代理可单独关闭
- seata: ${seata.enabled}
- # 严格模式 匹配不到数据源则报错
- strict: true
- hikari:
- # 最大连接池数量
- maxPoolSize: 20
- # 最小空闲线程数量
- minIdle: 10
- # 配置获取连接等待超时的时间
- connectionTimeout: 30000
- # 校验超时时间
- validationTimeout: 5000
- # 空闲连接存活最大时间,默认10分钟
- idleTimeout: 600000
- # 此属性控制池中连接的最长生命周期,值0表示无限生命周期,默认30分钟
- maxLifetime: 1800000
- # 多久检查一次连接的活性
- keepaliveTime: 30000
|