Mixed Rules

The overlay between rule items in a mixed configuration is associated by the data source name and the table name.

If the previous rule is aggregation-oriented, the next rule needs to use the aggregated logical data source name configured by the previous rule when configuring the data source. Similarly, if the previous rule is table aggregation-oriented, the next rule needs to use the aggregated logical table name configured by the previous rule when configuring the table.

Configuration Item Explanation

  1. dataSources: # Configure the real data source name.
  2.   write_ds:
  3.     # ...Omit specific configuration.
  4.   read_ds_0:
  5.     # ...Omit specific configuration.
  6.   read_ds_1:
  7.     # ...Omit specific configuration.
  9. rules:
  10.   - !SHARDING # Configure data sharding rules.
  11.     tables:
  12.       t_user:
  13.         actualDataNodes: ds.t_user_${0..1} # Data source name 'ds' uses the logical data source name of the readwrite-splitting configuration.
  14.         tableStrategy:
  15.           standard:
  16.             shardingColumn: user_id
  17.             shardingAlgorithmName: t_user_inline
  18.     shardingAlgorithms:
  19.       t_user_inline:
  20.         type: INLINE
  21.         props:
  22.           algorithm-expression: t_user_${user_id % 2}
  24.   - !ENCRYPT # Configure data encryption rules.
  25.     tables:
  26.       t_user: # Table `t_user` is the name of the logical table that uses the data sharding configuration.
  27.         columns:
  28.           pwd:
  29.             plainColumn: plain_pwd
  30.             cipherColumn: cipher_pwd
  31.             encryptorName: encryptor_aes
  32.     encryptors:
  33.       encryptor_aes:
  34.         type: aes
  35.         props:
  36.           aes-key-value: 123456abc
  38.   - !READWRITE_SPLITTING # Configure readwrite-splitting rules.
  39.     dataSources:
  40.       ds: # The logical data source name 'ds' for readwrite-splitting is used in data sharding.
  41.         writeDataSourceName: write_ds # Use the real data source name 'write_ds'.
  42.         readDataSourceNames:
  43.           - read_ds_0 # Use the real data source name 'read_ds_0'.
  44.           - read_ds_1 # Use the real data source name 'read_ds_1'.
  45.         loadBalancerName: roundRobin
  46.     loadBalancers:
  47.       roundRobin:
  48.         type: ROUND_ROBIN
  50. props:
  51.   sql-show: true