Shadow DB

    1. Configure shadow DB rules in the YAML file, including data sources, shadow library rules, global properties and other configuration items;
    2. Call the method of the YamlShardingSphereDataSourceFactory object to create a ShardingSphereDataSource based on the configuration information in the YAML file.
    1. dataSources:
    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.       minPoolSize: 1
    11.       url: jdbc:mysql://127.0.0.1:3306/shadow_ds?serverTimezone=UTC&useSSL=false
    12.       username: root
    14.       connectionTimeoutMilliseconds: 30000
    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.   tables:
    27.     t_order:
    28.         - shadowDataSource
    29.       shadowAlgorithmNames: 
    30.         - user_id_insert_match_algorithm
    31.         - simple_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.     simple_hint_algorithm:
    40.       type: SIMPLE_HINT
    41.       props: