Server/VB_DSM_V2.1/vbdsm-statistics/vbdsm-statistic/src/main/resources/config/sharding-prod.yml

dataSources:
  vbdsm: !!com.alibaba.druid.pool.DruidDataSource
    driverClassName: com.mysql.jdbc.Driver
    url: jdbc:mysql://47.112.30.247:23306/vbdsm?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&useSSL=false
    username: root
    password: 123456
    filters: stat
    maxActive: 30
    initialSize: 5
    minIdle: 10
    maxWait: 60000
    validationQuery: SELECT 1
    testWhileIdle: true
    poolPreparedStatements: true
  vbdsm_2023: !!com.alibaba.druid.pool.DruidDataSource
    driverClassName: com.mysql.jdbc.Driver
    url: jdbc:mysql://47.112.30.247:23306/vbdsm_2023?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&useSSL=false
    username: root
    password: 123456
    filters: stat
    maxActive: 30
    initialSize: 5
    minIdle: 10
    maxWait: 60000
    validationQuery: SELECT 1
    testWhileIdle: true
    poolPreparedStatements: true
    maxOpenPreparedStatements: 100
  vbdsm_2024: !!com.alibaba.druid.pool.DruidDataSource
    driverClassName: com.mysql.jdbc.Driver
    url: jdbc:mysql://47.112.30.247:23306/vbdsm_2024?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&useSSL=false
    username: root
    password: 123456
    filters: stat
    maxActive: 30
    initialSize: 5
    minIdle: 10
    maxWait: 60000
    validationQuery: SELECT 1
    testWhileIdle: true
    poolPreparedStatements: true
    maxOpenPreparedStatements: 100
  vbdsm_sysbase: !!com.alibaba.druid.pool.DruidDataSource
    driverClassName: com.mysql.jdbc.Driver
    url: jdbc:mysql://47.112.30.247:23306/vbdsm_sysbase?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&useSSL=false
    username: root
    password: 123456
    filters: stat
    maxActive: 30
    initialSize: 5
    minIdle: 10
    maxWait: 60000
    validationQuery: SELECT 1
    testWhileIdle: true
    poolPreparedStatements: true
    maxOpenPreparedStatements: 100
  vbdsm_powergov: !!com.alibaba.druid.pool.DruidDataSource
    driverClassName: com.mysql.jdbc.Driver
    url: jdbc:mysql://47.112.30.247:23306/vbdsm_powergov?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&useSSL=false
    username: root
    password: 123456
    filters: stat
    maxActive: 30
    initialSize: 5
    minIdle: 10
    maxWait: 60000
    validationQuery: SELECT 1
    testWhileIdle: true
    poolPreparedStatements: true
    maxOpenPreparedStatements: 100
shardingRule:
  tables:
    online_data_water:
      actualDataNodes: vbdsm_${2023..2024}.online_data_water_0${1..9},vbdsm_${2023..2024}.online_data_water_${10..12}
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseTableShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeTableShardingAlgorithm
    t_online_warn:
      actualDataNodes: vbdsm_${2023..2024}.t_online_warn
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    analysis_output_date:
      actualDataNodes: vbdsm_${2023..2024}.analysis_output_date
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    analysis_output_month:
      actualDataNodes: vbdsm_${2023..2024}.analysis_output_month
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    analysis_yield_date:
      actualDataNodes: vbdsm_${2023..2024}.analysis_yield_date
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    analysis_yield_month:
      actualDataNodes: vbdsm_${2023..2024}.analysis_yield_month
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    company_output_date:
      actualDataNodes: vbdsm_${2023..2024}.company_output_date
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    company_output_month:
      actualDataNodes: vbdsm_${2023..2024}.company_output_month
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    company_yield_date:
      actualDataNodes: vbdsm_${2023..2024}.company_yield_date
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    company_yield_month:
      actualDataNodes: vbdsm_${2023..2024}.company_yield_month
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    parks_output_date:
      actualDataNodes: vbdsm_${2023..2024}.parks_output_date
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    parks_output_month:
      actualDataNodes: vbdsm_${2023..2024}.parks_output_month
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    parks_yield_date:
      actualDataNodes: vbdsm_${2023..2024}.parks_yield_date
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    parks_yield_month:
      actualDataNodes: vbdsm_${2023..2024}.parks_yield_month
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    t_industry_product:
      actualDataNodes: vbdsm_powergov.t_industry_product
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_industry_price:
      actualDataNodes: vbdsm_powergov.t_industry_price
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_org:
      actualDataNodes: vbdsm_sysbase.t_org
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_sys_industry:
      actualDataNodes: vbdsm_sysbase.t_sys_industry
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_poweruser_product:
      actualDataNodes: vbdsm_sysbase.t_poweruser_product
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_poweruser:
      actualDataNodes: vbdsm_sysbase.t_poweruser
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_company_fgp:
      actualDataNodes: vbdsm_powergov.t_company_fgp
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_industry_date:
      actualDataNodes: vbdsm_powergov.t_industry_date
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_industry_month:
      actualDataNodes: vbdsm_powergov.t_industry_month
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_monitor:
      actualDataNodes: vbdsm.t_monitor
      databaseStrategy:
        none:
      tableStrategy:
        none:
    real_time_alarm_params:
      actualDataNodes: vbdsm_sysbase.real_time_alarm_params
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_sys_product:
      actualDataNodes: vbdsm_sysbase.t_sys_product
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_anal_date_avg:
      actualDataNodes: vbdsm_${2023..2024}.t_anal_date_avg
      databaseStrategy:
        standard:
          shardingColumn: getDate
          preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    t_online_data_power:
      actualDataNodes: vbdsm_${2023..2024}.t_online_data_power_0${1..9},vbdsm_${2023..2024}.t_online_data_power_${10..12}
      databaseStrategy:
        standard:
          shardingColumn: getTime
          preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
  defaultDatabaseStrategy:
    standard:
      shardingColumn: upload_date
      preciseAlgorithmClassName: cn.vbdsm.statistic.db.sharding.PreciseDatabaseShardingAlgorithm
      rangeAlgorithmClassName: cn.vbdsm.statistic.db.sharding.RangeDatabaseShardingAlgorithm
  defaultTableStrategy:
    none:
  props:
    sql.show: true