Yaml配置

    读写分离

    2.   ds_master: !!org.apache.commons.dbcp.BasicDataSource
    3.     driverClassName: com.mysql.jdbc.Driver
    4.     url: jdbc:mysql://localhost:3306/ds_master
    5.     username: root
    6.     password: 
    7.   ds_slave0: !!org.apache.commons.dbcp.BasicDataSource
    8.     driverClassName: com.mysql.jdbc.Driver
    9.     url: jdbc:mysql://localhost:3306/ds_slave0
    10.     username: root
    11.     password: 
    12.   ds_slave1: !!org.apache.commons.dbcp.BasicDataSource
    13.     driverClassName: com.mysql.jdbc.Driver
    14.     url: jdbc:mysql://localhost:3306/ds_slave1
    15.     username: root
    16.     password: 
    18. masterSlaveRule:
    19.   name: ds_ms
    20.   masterDataSourceName: ds_master
    21.   slaveDataSourceNames: 
    22.     - ds_slave0
    23.     - ds_slave1
    25. props:
    26.     sql.show: true

    数据脱敏

    1. dataSource:  !!org.apache.commons.dbcp2.BasicDataSource
    2.   driverClassName: com.mysql.jdbc.Driver
    3.   url: jdbc:mysql://127.0.0.1:3306/encrypt?serverTimezone=UTC&useSSL=false
    4.   username: root
    5.   password:
    7. encryptRule:
    8.   encryptors:
    9.     encryptor_aes:
    10.       type: aes
    11.       props:
    12.         aes.key.value: 123456abc
    13.     encryptor_md5:
    14.       type: md5
    15.     t_encrypt:
    16.       columns:
    17.         user_id:
    18.           plainColumn: user_plain
    19.           cipherColumn: user_cipher
    20.           encryptor: encryptor_aes
    21.         order_id:
    22.           cipherColumn: order_cipher
    23.           encryptor: encryptor_md5
    25.   query.with.cipher.column: true #是否使用密文列查询

    数据分片 + 数据脱敏

    1. dataSources:
    2.   ds_0: !!com.zaxxer.hikari.HikariDataSource
    3.     driverClassName: com.mysql.jdbc.Driver
    4.     jdbcUrl: jdbc:mysql://localhost:3306/demo_ds_0
    5.     username: root
    6.     password:
    7.   ds_1: !!com.zaxxer.hikari.HikariDataSource
    8.     driverClassName: com.mysql.jdbc.Driver
    9.     jdbcUrl: jdbc:mysql://localhost:3306/demo_ds_1
    10.     username: root
    11.     password:
    13. shardingRule:
    14.   tables:
    15.     t_order: 
    16.       actualDataNodes: ds_${0..1}.t_order_${0..1}
    17.       databaseStrategy:
    18.         inline:
    19.           shardingColumn: user_id
    20.           algorithmExpression: ds_${user_id % 2}
    21.       tableStrategy: 
    22.         inline:
    23.           shardingColumn: order_id
    24.           algorithmExpression: t_order_${order_id % 2}
    25.       keyGenerator:
    26.         type: SNOWFLAKE
    27.         column: order_id
    28.     t_order_item:
    29.       actualDataNodes: ds_${0..1}.t_order_item_${0..1}
    30.       databaseStrategy:
    31.         inline:
    32.           shardingColumn: user_id
    33.           algorithmExpression: ds_${user_id % 2}
    34.       tableStrategy:
    35.         inline:
    36.           shardingColumn: order_id
    37.           algorithmExpression: t_order_item_${order_id % 2}
    38.   bindingTables:
    39.     - t_order,t_order_item 
    41.   defaultTableStrategy:
    42.     none:
    43.   encryptRule:
    44.     encryptors:
    45.       encryptor_aes:
    46.         type: aes
    47.         props:
    49.     tables:
    50.       t_order:
    51.         columns:
    52.           order_id:
    53.             plainColumn: order_plain
    54.             cipherColumn: order_cipher
    55.             encryptor: encryptor_aes
    57. props:
    58.   sql.show: true

    治理

    1. #省略数据分片、读写分离和数据脱敏配置
    3. orchestration:
    4.   name: orchestration_ds
    5.   overwrite: true
    6.   registry:
    7.     type: zookeeper
    8.     namespace: orchestration
    9.     serverLists: localhost:2181

    读写分离

    1. dataSources: #省略数据源配置，与数据分片一致
    3. masterSlaveRule:
    4.   name: #读写分离数据源名称
    5.   masterDataSourceName: #主库数据源名称
    6.   slaveDataSourceNames: #从库数据源名称列表
    7.     - <data_source_name1>
    8.     - <data_source_name2>
    9.     - <data_source_name_x>
    10.   loadBalanceAlgorithmType: #从库负载均衡算法类型，可选值：ROUND_ROBIN，RANDOM。若`loadBalanceAlgorithmClassName`存在则忽略该配置
    11.   props: #读写分离负载算法的属性配置
    12.     <property-name>: #属性值

    数据脱敏

    1. dataSource: #省略数据源配置
    3. encryptRule:
    4.   encryptors:
    5.     <encryptor-name>:
    6.       type: #加解密器类型，可自定义或选择内置类型：MD5/AES 
    7.       props: #属性配置, 注意：使用AES加密器，需要配置AES加密器的KEY属性：aes.key.value
    8.         aes.key.value: 
    9.   tables:
    10.     <table-name>:
    11.       columns:
    12.         <logic-column-name>:
    13.           plainColumn: #存储明文的字段
    14.           cipherColumn: #存储密文的字段
    15.           assistedQueryColumn: #辅助查询字段，针对ShardingQueryAssistedEncryptor类型的加解密器进行辅助查询
    16.           encryptor: #加密器名字