Mixed Rules

    Below, you will find the parameters’ explanation and configuration samples based on SpringBoot Starter.

    2. spring.shardingsphere.rules.sharding.tables.t_order.actual-data-nodes=replica-ds-$->{0..1}.t_order_$->{0..1}
    3. spring.shardingsphere.rules.sharding.tables.t_order.table-strategy.standard.sharding-column=order_id
    4. spring.shardingsphere.rules.sharding.tables.t_order.table-strategy.standard.sharding-algorithm-name=t-order-inline
    5. spring.shardingsphere.rules.sharding.tables.t_order.key-generate-strategy.column=order_id
    6. spring.shardingsphere.rules.sharding.tables.t_order.key-generate-strategy.key-generator-name=snowflake
    7. spring.shardingsphere.rules.sharding.tables.t_order_item.actual-data-nodes=replica-ds-$->{0..1}.t_order_item_$->{0..1}
    8. spring.shardingsphere.rules.sharding.tables.t_order_item.table-strategy.standard.sharding-column=order_id
    9. spring.shardingsphere.rules.sharding.sharding-algorithms.database-inline.type=INLINE
    10. spring.shardingsphere.rules.sharding.sharding-algorithms.t-order-inline.type=INLINE
    11. spring.shardingsphere.rules.sharding.sharding-algorithms.t-order-inline.props.algorithm-expression=t_order_$->{order_id % 2}
    13. # Dynamic read/write splitting configuration
    14. spring.shardingsphere.rules.readwrite-splitting.data-sources.replica-ds-0.dynamic-strategy.auto-aware-data-source-name=readwrite-ds-0
    15. spring.shardingsphere.rules.readwrite-splitting.data-sources.replica-ds-1.dynamic-strategy.auto-aware-data-source-name=readwrite-ds-1
    16. # Database discovery configuration
    17. spring.shardingsphere.rules.database-discovery.data-sources.readwrite-ds-0.data-source-names=ds-0, ds-1, ds-2
    18. spring.shardingsphere.rules.database-discovery.data-sources.readwrite-ds-0.discovery-heartbeat-name=mgr-heartbeat
    19. spring.shardingsphere.rules.database-discovery.data-sources.readwrite-ds-0.discovery-type-name=mgr
    20. spring.shardingsphere.rules.database-discovery.data-sources.readwrite-ds-1.data-source-names=ds-3, ds-4, ds-5
    21. spring.shardingsphere.rules.database-discovery.data-sources.readwrite-ds-1.discovery-heartbeat-name=mgr-heartbeat
    22. spring.shardingsphere.rules.database-discovery.discovery-heartbeats.mgr-heartbeat.props.keep-alive-cron=0/5 * * * * ?
    24. spring.shardingsphere.rules.database-discovery.discovery-types.mgr.props.groupName=b13df29e-90b6-11e8-8d1b-525400fc3996
    25. # Data decryption
    26. spring.shardingsphere.rules.encrypt.encryptors.name-encryptor.type=AES
    27. spring.shardingsphere.rules.encrypt.encryptors.name-encryptor.props.aes-key-value=123456abc
    28. spring.shardingsphere.rules.encrypt.encryptors.pwd-encryptor.type=AES
    29. spring.shardingsphere.rules.encrypt.encryptors.pwd-encryptor.props.aes-key-value=123456abc
    30. spring.shardingsphere.rules.encrypt.tables.t_user.columns.username.cipher-column=username
    31. spring.shardingsphere.rules.encrypt.tables.t_user.columns.username.encryptor-name=name-encryptor
    32. spring.shardingsphere.rules.encrypt.tables.t_user.columns.pwd.cipher-column=pwd
    33. spring.shardingsphere.rules.encrypt.tables.t_user.columns.pwd.encryptor-name=pwd-encryptor