| 123456789101112131415161718192021222324252627282930313233343536373839404142434445 |
- datasource:
- system-master:
- # jdbc 所有参数配置参考 https://lionli.blog.csdn.net/article/details/122018562
- # rewriteBatchedStatements=true 批处理优化 大幅提升批量插入更新删除性能
- url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&rewriteBatchedStatements=true
- username: root
- password: password
- gen:
- url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&rewriteBatchedStatements=true
- username: root
- password: password
- job:
- url: jdbc:mysql://localhost:3306/ry-job?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&rewriteBatchedStatements=true
- username: root
- password: password
- spring:
- datasource:
- type: com.alibaba.druid.pool.DruidDataSource
- # 动态数据源文档 https://www.kancloud.cn/tracy5546/dynamic-datasource/content
- dynamic:
- # 性能分析插件(有性能损耗 不建议生产环境使用)
- p6spy: true
- # 开启seata代理，开启后默认每个数据源都代理，如果某个不需要代理可单独关闭
- seata: true
- druid:
- initial-size: 5
- min-idle: 5
- maxActive: 20
- maxWait: 60000
- timeBetweenEvictionRunsMillis: 60000
- minEvictableIdleTimeMillis: 300000
- validationQuery: SELECT 1 FROM DUAL
- testWhileIdle: true
- testOnBorrow: false
- testOnReturn: false
- poolPreparedStatements: true
- maxPoolPreparedStatementPerConnectionSize: 20
- filters: stat,slf4j
- connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000
- # seata配置
- seata:
- # 关闭自动代理
- enable-auto-data-source-proxy: false
|
