| 123456789101112131415161718192021222324252627282930313233343536373839404142434445 |
- dataSources:
- ds0: !!com.alibaba.druid.pool.DruidDataSource
- driverClassName: com.mysql.cj.jdbc.Driver
- url: jdbc:mysql://dev.db.java110.com:3306/TT?useUnicode=true&characterEncoding=utf-8
- username: TT
- password: TT@12345678
- minIdle: 5
- validationQuery: SELECT 1 FROM DUAL
- initialSize: 5
- maxWait: 60000
- filters: stat,wall,log4j
- poolPreparedStatements: true
- shardingRule:
- tables:
- business_xxx:
- actualDataNodes: ds${0..1}.business_community
- databaseStrategy:
- inline:
- shardingColumn: community_id
- algorithmExpression: ds${Long.parseLong(community_id) % 2}
- bindingTables:
- - business_xxx
- defaultDataSourceName: ds0
- defaultDatabaseStrategy:
- none:
- defaultTableStrategy:
- none:
- # masterSlaveRules:
- # ms_ds0:
- # masterDataSourceName: ds0
- # slaveDataSourceNames:
- # - ds0_slave0
- # loadBalanceAlgorithmType: ROUND_ROBIN
- # ms_ds1:
- # masterDataSourceName: ds1
- # slaveDataSourceNames:
- # - ds1_slave0
- # loadBalanceAlgorithmType: ROUND_ROBIN
- props:
- sql.show: true
|
