# 数据源
|
dataSources:
|
sharding:
|
dataSourceClassName: com.alibaba.druid.pool.DruidDataSource
|
driverClassName: com.mysql.cj.jdbc.Driver
|
url: jdbc:mysql://192.168.2.29:7006/hazmat_manage?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
|
username: root
|
password: 2farwL3yPXfbH2AP
|
maxTotal: 100
|
# ds_1:
|
# dataSourceClassName: com.alibaba.druid.pool.DruidDataSource
|
# driverClassName: com.mysql.cj.jdbc.Driver
|
# url: jdbc:mysql://localhost:3306/ry-order2?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
|
# username: root
|
# password: root
|
# maxTotal: 100
|
rules:
|
- !SHARDING
|
tables:
|
hz_hazmat:
|
actualDataNodes: sharding.hz_hazmat_$->{0..19}
|
tableStrategy:
|
standard:
|
shardingColumn: company_id
|
shardingAlgorithmName: hz_hazmat_inline
|
hz_hazmat_flow:
|
actualDataNodes: sharding.hz_hazmat_flow_$->{0..19}
|
tableStrategy:
|
standard:
|
shardingColumn: company_id
|
shardingAlgorithmName: hz_hazmat_flow_inline
|
hz_product:
|
actualDataNodes: sharding.hz_product_$->{0..19}
|
tableStrategy:
|
standard:
|
shardingColumn: company_id
|
shardingAlgorithmName: hz_product_inline
|
hz_product_flow:
|
actualDataNodes: sharding.hz_product_flow_$->{0..19}
|
tableStrategy:
|
standard:
|
shardingColumn: company_id
|
shardingAlgorithmName: hz_product_flow_inline
|
shardingAlgorithms:
|
hz_hazmat_inline:
|
type: INLINE
|
props:
|
algorithm-expression: hz_hazmat_$->{company_id % 20}
|
hz_hazmat_flow_inline:
|
type: INLINE
|
props:
|
algorithm-expression: hz_hazmat_flow_$->{company_id % 20}
|
hz_product_inline:
|
type: INLINE
|
props:
|
algorithm-expression: hz_product_$->{company_id % 20}
|
hz_product_flow_inline:
|
type: INLINE
|
props:
|
algorithm-expression: hz_product_flow_$->{company_id % 20}
|
keyGenerators:
|
snowflake:
|
type: SNOWFLAKE
|
props:
|
sql-show: true # 是否打印sql
|
