Mixed Rules

    2. - !SHARDING
    3.   tables:
    4.     t_order:
    5.       actualDataNodes: replica_ds_${0..1}.t_order_${0..1}
    6.       tableStrategy:
    7.         standard:
    8.           shardingColumn: order_id
    9.           shardingAlgorithmName: t_order_inline
    10.       keyGenerateStrategy:
    11.         column: order_id
    12.         keyGeneratorName: snowflake
    13.   defaultDatabaseStrategy:
    14.     standard:
    15.       shardingColumn: user_id
    16.       shardingAlgorithmName: database_inline
    17.   shardingAlgorithms:
    18.     database_inline:
    19.       type: INLINE
    20.       props:
    21.         algorithm-expression: replica_ds_${user_id % 2}
    22.     t_order_inline:
    23.       type: INLINE
    24.       props:
    25.         algorithm-expression: t_order_${order_id % 2}
    26.     t_order_item_inline:
    27.       type: INLINE
    28.         algorithm-expression: t_order_item_${order_id % 2}
    29.   keyGenerators:
    31.       type: SNOWFLAKE
    32. - !READWRITE_SPLITTING
    33.   dataSources:
    34.     replica_ds_0:
    35.       dynamicStrategy:
    36.         autoAwareDataSourceName: readwrite_ds_0
    37.     replica_ds_1:
    38.       dynamicStrategy:
    39.         autoAwareDataSourceName: readwrite_ds_1
    40. - !DB_DISCOVERY
    41.   dataSources:
    42.     readwrite_ds_0:
    43.       dataSourceNames:
    44.         - ds_0
    45.         - ds_1
    46.         - ds_2
    47.       discoveryHeartbeatName: mgr_heartbeat
    48.       discoveryTypeName: mgr
    49.     readwrite_ds_1:
    50.       dataSourceNames:
    51.         - ds_3
    52.         - ds_4
    53.         - ds_5
    54.       discoveryHeartbeatName: mgr_heartbeat
    55.       discoveryTypeName: mgr
    56.   discoveryHeartbeats:
    57.     mgr_heartbeat:
    58.         keep-alive-cron: '0/5 * * * * ?'
    60.     mgr:
    61.       type: MySQL.MGR
    62.       props:
    63.         group-name: 558edd3c-02ec-11ea-9bb3-080027e39bd2
    64. - !ENCRYPT
    65.   encryptors:
    66.     aes_encryptor:
    67.       type: AES
    68.       props:
    69.         aes-key-value: 123456abc
    70.     md5_encryptor:
    71.       type: MD5
    72.     like_encryptor:
    73.       type: CHAR_DIGEST_LIKE
    74.   tables:
    75.     t_encrypt:
    76.       columns:
    77.         user_id:
    78.           plainColumn: user_plain
    79.           cipherColumn: user_cipher
    80.           encryptorName: aes_encryptor
    81.           assistedQueryColumn: assisted_query_user
    82.           assistedQueryEncryptorName: aes_encryptor
    83.           likeQueryColumn: like_query_user
    84.           likeQueryEncryptorName: like_encryptor
    85.         order_id:
    86.           cipherColumn: order_cipher
    87.           encryptorName: md5_encryptor