Shadow DB

    For details, see list of built-in shadow algorithms

    1. Configure the shadow library rules in the SpringBoot file, including configuration items such as data sources, shadow rules, and global properties.
    2. Start the SpringBoot program, the configuration will be loaded automatically, and the ShardingSphereDataSource will be initialized.
    3. spring.shardingsphere.datasource.ds.jdbc-url=jdbc:mysql://localhost:3306/ds?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
    4. spring.shardingsphere.datasource.ds.type=com.zaxxer.hikari.HikariDataSource
    5. spring.shardingsphere.datasource.ds.driver-class-name=com.mysql.jdbc.Driver
    6. spring.shardingsphere.datasource.ds.password=
    8. spring.shardingsphere.datasource.shadow-ds.jdbc-url=jdbc:mysql://localhost:3306/shadow_ds?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
    10. spring.shardingsphere.datasource.shadow-ds.driver-class-name=com.mysql.jdbc.Driver
    11. spring.shardingsphere.datasource.shadow-ds.username=root
    12. spring.shardingsphere.datasource.shadow-ds.password=
    14. spring.shardingsphere.rules.shadow.data-sources.shadow-data-source.production-data-source-name=ds
    15. spring.shardingsphere.rules.shadow.data-sources.shadow-data-source.shadow-data-source-name=shadow-ds
    17. spring.shardingsphere.rules.shadow.tables.t_user.data-source-names=shadow-data-source
    19. spring.shardingsphere.rules.shadow.shadow-algorithms.user-id-insert-match-algorithm.type=VALUE_MATCH
    20. spring.shardingsphere.rules.shadow.shadow-algorithms.user-id-insert-match-algorithm.props.operation=insert
    21. spring.shardingsphere.rules.shadow.shadow-algorithms.user-id-insert-match-algorithm.props.column=user_id
    22. spring.shardingsphere.rules.shadow.shadow-algorithms.user-id-insert-match-algorithm.props.value=1
    24. spring.shardingsphere.rules.shadow.shadow-algorithms.simple-hint-algorithm.type=SIMPLE_HINT
    25. spring.shardingsphere.rules.shadow.shadow-algorithms.simple-hint-algorithm.props.shadow=true