dataSources:
|
ds0: !!com.alibaba.druid.pool.DruidDataSource
|
driverClassName: com.mysql.jdbc.Driver
|
url: jdbc:mysql://dev.db.java110.com:3306/hc_community?useUnicode=true&characterEncoding=utf-8
|
username: hc_community
|
password: hc_community@12345678
|
minIdle: 5
|
validationQuery: SELECT 1 FROM DUAL
|
initialSize: 5
|
maxWait: 60000
|
filters: stat,wall,log4j
|
poolPreparedStatements: true
|
# ds0_slave0: !!com.alibaba.druid.pool.DruidDataSource
|
# driverClassName: com.mysql.jdbc.Driver
|
# url: jdbc:mysql://dev.db.java110.com:3306/TT?useUnicode=true&characterEncoding=utf-8
|
# username: TT
|
# password: TT@12345678
|
# connectionTimeoutMilliseconds: 30000
|
# idleTimeoutMilliseconds: 60000
|
# maxPoolSize: 50
|
# minPoolSize: 1
|
# maintenanceIntervalMilliseconds: 30000
|
ds1: !!com.alibaba.druid.pool.DruidDataSource
|
driverClassName: com.mysql.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
|
# ds1_slave0: !!com.alibaba.druid.pool.DruidDataSource
|
# driverClassName: com.mysql.jdbc.Driver
|
# url: jdbc:mysql://dev.db.java110.com:3306/TT?useUnicode=true&characterEncoding=utf-8
|
# username: TT
|
# password: TT@12345678
|
# connectionTimeoutMilliseconds: 30000
|
# idleTimeoutMilliseconds: 60000
|
# maxPoolSize: 50
|
# minPoolSize: 1
|
# maintenanceIntervalMilliseconds: 30000
|
|
shardingRule:
|
tables:
|
business_community:
|
actualDataNodes: ds${0..1}.business_community
|
tableStrategy:
|
inline:
|
shardingColumn: community_id
|
algorithmExpression: business_community${business_community % 2}
|
community:
|
actualDataNodes: ds${0..1}.community
|
tableStrategy:
|
inline:
|
shardingColumn: community_id
|
algorithmExpression: community${community_id % 2}
|
bindingTables:
|
- business_community,community
|
|
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
|
