影子库

    详情请参见内置影子算法列表

    1. 在 YAML 文件中配置影子库规则，包含数据源、影子库规则、全局属性等配置项；
    2. 调用 YamlShardingSphereDataSourceFactory 对象的 createDataSource 方法，根据 YAML 文件中的配置信息创建 ShardingSphereDataSource。
    2.    ds:
    3.       url: jdbc:mysql://127.0.0.1:3306/ds?serverTimezone=UTC&useSSL=false
    4.       username: root
    5.       password:
    6.       connectionTimeoutMilliseconds: 30000
    7.       idleTimeoutMilliseconds: 60000
    8.       maxLifetimeMilliseconds: 1800000
    9.       maxPoolSize: 50
    10.    shadow_ds:
    11.       url: jdbc:mysql://127.0.0.1:3306/shadow_ds?serverTimezone=UTC&useSSL=false
    12.       username: root
    13.       password:
    15.       idleTimeoutMilliseconds: 60000
    16.       maxLifetimeMilliseconds: 1800000
    17.       maxPoolSize: 50
    18.       minPoolSize: 1
    20. rules:
    21. - !SHADOW
    22.   dataSources:
    23.     shadowDataSource:
    24.       productionDataSourceName: ds
    25.       shadowDataSourceName: shadow_ds
    26.     t_order:
    28.         - shadowDataSource
    29.       shadowAlgorithmNames: 
    30.         - user_id_insert_match_algorithm
    31.         - sql_hint_algorithm
    32.   shadowAlgorithms:
    33.     user_id_insert_match_algorithm:
    34.       type: REGEX_MATCH
    35.       props:
    36.         operation: insert
    37.         column: user_id
    38.         regex: "[1]"
    39.     sql_hint_algorithm:
    40.       type: SQL_HINT