| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356 |
- dataSources:
- vbdsm_2023: !!com.alibaba.druid.pool.DruidDataSource
- driverClassName: com.mysql.jdbc.Driver
- url: jdbc:mysql://47.112.30.247:13306/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:13306/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:13306/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:13306/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
- vbdsm: !!com.alibaba.druid.pool.DruidDataSource
- driverClassName: com.mysql.jdbc.Driver
- url: jdbc:mysql://47.112.30.247:13306/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
- shardingRule:
- tables:
- t_online_warn:
- actualDataNodes: vbdsm_${2023..2024}.t_online_warn
- databaseStrategy:
- standard:
- shardingColumn: upload_date
- preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
- tableStrategy:
- none:
- t_sys_settings:
- actualDataNodes: vbdsm_sysbase.t_sys_settings
- databaseStrategy:
- none:
- tableStrategy:
- none:
- t_direct_transaction:
- actualDataNodes: vbdsm_powergov.t_direct_transaction
- databaseStrategy:
- none:
- tableStrategy:
- none:
- t_sys_industry:
- actualDataNodes: vbdsm_sysbase.t_sys_industry
- databaseStrategy:
- none:
- tableStrategy:
- none:
- t_city:
- actualDataNodes: vbdsm_sysbase.t_city
- databaseStrategy:
- none:
- tableStrategy:
- none:
- t_product_output:
- actualDataNodes: vbdsm_powergov.t_product_output
- databaseStrategy:
- none:
- tableStrategy:
- none:
- t_site:
- actualDataNodes: vbdsm_sysbase.t_site
- databaseStrategy:
- none:
- tableStrategy:
- none:
- t_org:
- actualDataNodes: vbdsm_sysbase.t_org
- databaseStrategy:
- none:
- tableStrategy:
- none:
- t_poweruser:
- actualDataNodes: vbdsm_sysbase.t_poweruser
- databaseStrategy:
- none:
- tableStrategy:
- none:
- t_company_online:
- actualDataNodes: vbdsm_powergov.t_company_online
- databaseStrategy:
- none:
- tableStrategy:
- none:
- sys_dictionary:
- actualDataNodes: vbdsm_sysbase.sys_dictionary
- databaseStrategy:
- none:
- tableStrategy:
- none:
- t_online_warn_handle_result:
- actualDataNodes: vbdsm_sysbase.t_online_warn_handle_result
- databaseStrategy:
- none:
- tableStrategy:
- none:
- t_sys_basecode:
- actualDataNodes: vbdsm_sysbase.t_sys_basecode
- real_time_alarm_params:
- actualDataNodes: vbdsm_sysbase.real_time_alarm_params
- databaseStrategy:
- none:
- 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: upload_date
- preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
- tableStrategy:
- standard:
- shardingColumn: upload_date
- preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseTableShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeTableShardingAlgorithm
- 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.db.sharding.PreciseDatabaseShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
- tableStrategy:
- standard:
- shardingColumn: upload_date
- preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseTableShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeTableShardingAlgorithm
- 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_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:
- analysis_output_date:
- actualDataNodes: vbdsm_${2023..2024}.analysis_output_date
- databaseStrategy:
- standard:
- shardingColumn: upload_date
- preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
- tableStrategy:
- none:
- analysis_output_month:
- actualDataNodes: vbdsm_${2023..2024}.analysis_output_month
- databaseStrategy:
- standard:
- shardingColumn: upload_date
- preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
- tableStrategy:
- none:
- analysis_yield_date:
- actualDataNodes: vbdsm_${2023..2024}.analysis_yield_date
- databaseStrategy:
- standard:
- shardingColumn: upload_date
- preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
- tableStrategy:
- none:
- analysis_yield_month:
- actualDataNodes: vbdsm_${2023..2024}.analysis_yield_month
- databaseStrategy:
- standard:
- shardingColumn: upload_date
- preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
- tableStrategy:
- none:
- company_output_date:
- actualDataNodes: vbdsm_${2023..2024}.company_output_date
- databaseStrategy:
- standard:
- shardingColumn: upload_date
- preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
- tableStrategy:
- none:
- company_output_month:
- actualDataNodes: vbdsm_${2023..2024}.company_output_month
- databaseStrategy:
- standard:
- shardingColumn: upload_date
- preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
- tableStrategy:
- none:
- company_yield_date:
- actualDataNodes: vbdsm_${2023..2024}.company_yield_date
- databaseStrategy:
- standard:
- shardingColumn: upload_date
- preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
- tableStrategy:
- none:
- company_yield_month:
- actualDataNodes: vbdsm_${2023..2024}.company_yield_month
- databaseStrategy:
- standard:
- shardingColumn: upload_date
- preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
- tableStrategy:
- none:
- parks_output_date:
- actualDataNodes: vbdsm_${2023..2024}.parks_output_date
- databaseStrategy:
- standard:
- shardingColumn: upload_date
- preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
- tableStrategy:
- none:
- parks_output_month:
- actualDataNodes: vbdsm_${2023..2024}.parks_output_month
- databaseStrategy:
- standard:
- shardingColumn: upload_date
- preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
- tableStrategy:
- none:
- parks_yield_date:
- actualDataNodes: vbdsm_${2023..2024}.parks_yield_date
- databaseStrategy:
- standard:
- shardingColumn: upload_date
- preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
- tableStrategy:
- none:
- parks_yield_month:
- actualDataNodes: vbdsm_${2023..2024}.parks_yield_month
- databaseStrategy:
- standard:
- shardingColumn: upload_date
- preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
- tableStrategy:
- none:
- t_monitor:
- actualDataNodes: vbdsm.t_monitor
- databaseStrategy:
- none:
- tableStrategy:
- none:
- area_increasing_speed:
- actualDataNodes: vbdsm_sysbase.area_increasing_speed
- databaseStrategy:
- standard:
- none:
- tableStrategy:
- none:
- t_sys_product:
- actualDataNodes: vbdsm_sysbase.t_sys_product
- databaseStrategy:
- standard:
- none:
- tableStrategy:
- none:
- industry_increasing_speed:
- actualDataNodes: vbdsm_sysbase.industry_increasing_speed
- databaseStrategy:
- standard:
- none:
- tableStrategy:
- none:
- t_province_date_info:
- actualDataNodes: vbdsm_powergov.t_province_date_info
- databaseStrategy:
- standard:
- none:
- tableStrategy:
- none:
- t_province_generating_capacity:
- actualDataNodes: vbdsm_powergov.t_province_generating_capacity
- defaultDatabaseStrategy:
- standard:
- shardingColumn: upload_date
- preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
- rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
- defaultTableStrategy:
- none:
- props:
- sql.show: true
|
