Mixed Rules

Configuration Item Explanation

  1. # data source configuration
  2. spring.shardingsphere.datasource.names= write-ds0,write-ds1,write-ds0-read0,write-ds1-read0
  4. spring.shardingsphere.datasource.write-ds0.url= # Database URL connection
  5. spring.shardingsphere.datasource.write-ds0.type=  # Database connection pool type name
  6. spring.shardingsphere.datasource.write-ds0.driver-class-name= # Database driver class name
  7. spring.shardingsphere.datasource.write-ds0.username= # Database username
  8. spring.shardingsphere.datasource.write-ds0.password= # Database password
  9. spring.shardingsphere.datasource.write-ds0.xxx=  # Other properties of database connection pool
  11. spring.shardingsphere.datasource.write-ds1.url= # Database URL connection
  12. # ...Omit specific configuration.
  14. spring.shardingsphere.datasource.write-ds0-read0.url= # Database URL connection
  15. # ...Omit specific configuration.
  17. spring.shardingsphere.datasource.write-ds1-read0.url= # Database URL connection
  18. # ...Omit specific configuration.
  20. # Sharding rules configuration
  21. # Databases sharding strategy
  22. spring.shardingsphere.rules.sharding.default-database-strategy.standard.sharding-column=user_id
  23. spring.shardingsphere.rules.sharding.default-database-strategy.standard.sharding-algorithm-name=default-database-strategy-inline
  24. # Binding table rules configuration ,and multiple groups of binding-tables configured with arrays
  25. spring.shardingsphere.rules.sharding.binding-tables[0]=t_user,t_user_detail
  26. spring.shardingsphere.rules.sharding.binding-tables[1]= # Binding table names,multiple table name are separated by commas
  27. spring.shardingsphere.rules.sharding.binding-tables[x]= # Binding table names,multiple table name are separated by commas
  28. # Broadcast table rules configuration
  29. spring.shardingsphere.rules.sharding.broadcast-tables= # Broadcast table names,multiple table name are separated by commas
  31. # Table sharding strategy
  32. # The enumeration value of `ds_$->{0..1}` is the name of the logical data source configured with readwrite-splitting
  33. spring.shardingsphere.rules.sharding.tables.t_user.actual-data-nodes=ds_$->{0..1}.t_user_$->{0..1}
  34. spring.shardingsphere.rules.sharding.tables.t_user.table-strategy.standard.sharding-column=user_id
  35. spring.shardingsphere.rules.sharding.tables.t_user.table-strategy.standard.sharding-algorithm-name=user-table-strategy-inline
  37. # Data encrypt configuration
  38. # Table `t_user` is the name of the logical table that uses for data sharding configuration.
  39. spring.shardingsphere.rules.encrypt.tables.t_user.columns.user_name.cipher-column=user_name
  40. spring.shardingsphere.rules.encrypt.tables.t_user.columns.user_name.encryptor-name=name-encryptor
  41. spring.shardingsphere.rules.encrypt.tables.t_user.columns.pwd.cipher-column=pwd
  42. spring.shardingsphere.rules.encrypt.tables.t_user.columns.pwd.encryptor-name=pwd-encryptor
  44. # Data encrypt algorithm configuration
  45. spring.shardingsphere.rules.encrypt.encryptors.name-encryptor.type=AES
  46. spring.shardingsphere.rules.encrypt.encryptors.name-encryptor.props.aes-key-value=123456abc
  47. spring.shardingsphere.rules.encrypt.encryptors.pwd-encryptor.type=AES
  48. spring.shardingsphere.rules.encrypt.encryptors.pwd-encryptor.props.aes-key-value=123456abc
  50. # Key generate strategy configuration
  51. spring.shardingsphere.rules.sharding.tables.t_user.key-generate-strategy.column=user_id
  52. spring.shardingsphere.rules.sharding.tables.t_user.key-generate-strategy.key-generator-name=snowflake
  54. # Sharding algorithm configuration
  55. spring.shardingsphere.rules.sharding.sharding-algorithms.default-database-strategy-inline.type=INLINE
  56. # The enumeration value of `ds_$->{user_id % 2}` is the name of the logical data source configured with readwrite-splitting
  57. spring.shardingsphere.rules.sharding.sharding-algorithms.default-database-strategy-inline.algorithm-expression=ds$->{user_id % 2}
  58. spring.shardingsphere.rules.sharding.sharding-algorithms.user-table-strategy-inline.type=INLINE
  59. spring.shardingsphere.rules.sharding.sharding-algorithms.user-table-strategy-inline.algorithm-expression=t_user_$->{user_id % 2}
  61. # Key generate algorithm configuration
  62. spring.shardingsphere.rules.sharding.key-generators.snowflake.type=SNOWFLAKE
  63. spring.shardingsphere.rules.sharding.key-generators.snowflake.props.worker-id=123
  65. # read query configuration
  66. # ds_0,ds_1 is the logical data source name of the readwrite-splitting
  67. spring.shardingsphere.rules.readwrite-splitting.data-sources.ds_0.write-data-source-name=write-ds0
  68. spring.shardingsphere.rules.readwrite-splitting.data-sources.ds_0.read-data-source-names=write-ds0-read0
  69. spring.shardingsphere.rules.readwrite-splitting.data-sources.ds_0.load-balancer-name=read-random
  70. spring.shardingsphere.rules.readwrite-splitting.data-sources.ds_1.write-data-source-name=write-ds1
  71. spring.shardingsphere.rules.readwrite-splitting.data-sources.ds_1.read-data-source-names=write-ds1-read0
  72. spring.shardingsphere.rules.readwrite-splitting.data-sources.ds_1.load-balancer-name=read-random
  74. # Load balance algorithm configuration
  75. spring.shardingsphere.rules.readwrite-splitting.load-balancers.read-random.type=RANDOM