Blame view

service-report/src/main/resources/dataSource-dynamic.yml 1.11 KB
88e030b7   王彪总   init project
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
  dataSources:
    ds0: !!com.alibaba.druid.pool.DruidDataSource
      driverClassName: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://dev.db.java110.com:${mysqlport}/${dbttname}?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
      username: ${dbttuser}
      password: ${mysqlpwd}
      minIdle: 5
      validationQuery: SELECT 1 FROM DUAL
      initialSize: 5
      maxWait: 60000
      filters: stat,wall,log4j
      poolPreparedStatements: true
  
  shardingRule:
    tables:
      business_xxx:
        actualDataNodes: ds0.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