Spring Boot配置

注意事项

行表达式标识符可以使用${...}或$->{...}，但前者与Spring本身的属性文件占位符冲突，因此在Spring环境中使用行表达式标识符建议使用$->{...}。

配置示例

数据分片

  1. spring.shardingsphere.datasource.names=ds0,ds1
  3. spring.shardingsphere.datasource.ds0.type=org.apache.commons.dbcp.BasicDataSource
  4. spring.shardingsphere.datasource.ds0.driver-class-name=com.mysql.jdbc.Driver
  5. spring.shardingsphere.datasource.ds0.url=jdbc:mysql://localhost:3306/ds0
  6. spring.shardingsphere.datasource.ds0.username=root
  7. spring.shardingsphere.datasource.ds0.password=
  9. spring.shardingsphere.datasource.ds1.type=org.apache.commons.dbcp.BasicDataSource
  10. spring.shardingsphere.datasource.ds1.driver-class-name=com.mysql.jdbc.Driver
  11. spring.shardingsphere.datasource.ds1.url=jdbc:mysql://localhost:3306/ds1
  12. spring.shardingsphere.datasource.ds1.username=root
  13. spring.shardingsphere.datasource.ds1.password=
  15. spring.shardingsphere.sharding.tables.t_order.actual-data-nodes=ds$->{0..1}.t_order$->{0..1}
  16. spring.shardingsphere.sharding.tables.t_order.table-strategy.inline.sharding-column=order_id
  17. spring.shardingsphere.sharding.tables.t_order.table-strategy.inline.algorithm-expression=t_order$->{order_id % 2}
  18. spring.shardingsphere.sharding.tables.t_order.key-generator.column=order_id
  19. spring.shardingsphere.sharding.tables.t_order.key-generator.type=SNOWFLAKE
  20. spring.shardingsphere.sharding.tables.t_order_item.actual-data-nodes=ds$->{0..1}.t_order_item$->{0..1}
  21. spring.shardingsphere.sharding.tables.t_order_item.table-strategy.inline.sharding-column=order_id
  22. spring.shardingsphere.sharding.tables.t_order_item.table-strategy.inline.algorithm-expression=t_order_item$->{order_id % 2}
  23. spring.shardingsphere.sharding.tables.t_order_item.key-generator.column=order_item_id
  24. spring.shardingsphere.sharding.tables.t_order_item.key-generator.type=SNOWFLAKE
  25. spring.shardingsphere.sharding.binding-tables=t_order,t_order_item
  26. spring.shardingsphere.sharding.broadcast-tables=t_config
  28. spring.shardingsphere.sharding.default-database-strategy.inline.sharding-column=user_id
  29. spring.shardingsphere.sharding.default-database-strategy.inline.algorithm-expression=ds$->{user_id % 2}

读写分离

  1. spring.shardingsphere.datasource.names=master,slave0,slave1
  3. spring.shardingsphere.datasource.master.type=org.apache.commons.dbcp.BasicDataSource
  4. spring.shardingsphere.datasource.master.driver-class-name=com.mysql.jdbc.Driver
  5. spring.shardingsphere.datasource.master.url=jdbc:mysql://localhost:3306/master
  6. spring.shardingsphere.datasource.master.username=root
  7. spring.shardingsphere.datasource.master.password=
  9. spring.shardingsphere.datasource.slave0.type=org.apache.commons.dbcp.BasicDataSource
  10. spring.shardingsphere.datasource.slave0.driver-class-name=com.mysql.jdbc.Driver
  11. spring.shardingsphere.datasource.slave0.url=jdbc:mysql://localhost:3306/slave0
  12. spring.shardingsphere.datasource.slave0.username=root
  13. spring.shardingsphere.datasource.slave0.password=
  15. spring.shardingsphere.datasource.slave1.type=org.apache.commons.dbcp.BasicDataSource
  16. spring.shardingsphere.datasource.slave1.driver-class-name=com.mysql.jdbc.Driver
  17. spring.shardingsphere.datasource.slave1.url=jdbc:mysql://localhost:3306/slave1
  18. spring.shardingsphere.datasource.slave1.username=root
  19. spring.shardingsphere.datasource.slave1.password=
  21. spring.shardingsphere.masterslave.load-balance-algorithm-type=round_robin
  22. spring.shardingsphere.masterslave.name=ms
  23. spring.shardingsphere.masterslave.master-data-source-name=master
  24. spring.shardingsphere.masterslave.slave-data-source-names=slave0,slave1
  26. spring.shardingsphere.props.sql.show=true

数据脱敏

  1. spring.shardingsphere.datasource.name=ds
  3. spring.shardingsphere.datasource.ds.type=org.apache.commons.dbcp2.BasicDataSource
  4. spring.shardingsphere.datasource.ds.driver-class-name=com.mysql.jdbc.Driver
  5. spring.shardingsphere.datasource.ds.url=jdbc:mysql://127.0.0.1:3306/encrypt?serverTimezone=UTC&useSSL=false
  6. spring.shardingsphere.datasource.ds.username=root
  7. spring.shardingsphere.datasource.ds.password=
  8. spring.shardingsphere.datasource.ds.max-total=100
  10. spring.shardingsphere.encrypt.encryptors.encryptor_aes.type=aes
  11. spring.shardingsphere.encrypt.encryptors.encryptor_aes.props.aes.key.value=123456
  12. spring.shardingsphere.encrypt.tables.t_order.columns.user_id.plainColumn=user_decrypt
  13. spring.shardingsphere.encrypt.tables.t_order.columns.user_id.cipherColumn=user_encrypt
  14. spring.shardingsphere.encrypt.tables.t_order.columns.user_id.assistedQueryColumn=user_assisted
  15. spring.shardingsphere.encrypt.tables.t_order.columns.user_id.encryptor=encryptor_aes
  17. spring.shardingsphere.props.sql.show=true
  18. spring.shardingsphere.props.query.with.cipher.column=true

数据分片 + 读写分离

  1. spring.shardingsphere.datasource.names=master0,master1,master0slave0,master0slave1,master1slave0,master1slave1
  3. spring.shardingsphere.datasource.master0.type=org.apache.commons.dbcp.BasicDataSource
  4. spring.shardingsphere.datasource.master0.driver-class-name=com.mysql.jdbc.Driver
  5. spring.shardingsphere.datasource.master0.url=jdbc:mysql://localhost:3306/master0
  6. spring.shardingsphere.datasource.master0.username=root
  7. spring.shardingsphere.datasource.master0.password=
  9. spring.shardingsphere.datasource.master0slave0.type=org.apache.commons.dbcp.BasicDataSource
  10. spring.shardingsphere.datasource.master0slave0.driver-class-name=com.mysql.jdbc.Driver
  11. spring.shardingsphere.datasource.master0slave0.url=jdbc:mysql://localhost:3306/master0slave0
  12. spring.shardingsphere.datasource.master0slave0.username=root
  13. spring.shardingsphere.datasource.master0slave0.password=
  14. spring.shardingsphere.datasource.master0slave1.type=org.apache.commons.dbcp.BasicDataSource
  15. spring.shardingsphere.datasource.master0slave1.driver-class-name=com.mysql.jdbc.Driver
  16. spring.shardingsphere.datasource.master0slave1.url=jdbc:mysql://localhost:3306/master0slave1
  17. spring.shardingsphere.datasource.master0slave1.username=root
  18. spring.shardingsphere.datasource.master0slave1.password=
  20. spring.shardingsphere.datasource.master1.type=org.apache.commons.dbcp.BasicDataSource
  21. spring.shardingsphere.datasource.master1.driver-class-name=com.mysql.jdbc.Driver
  22. spring.shardingsphere.datasource.master1.url=jdbc:mysql://localhost:3306/master1
  23. spring.shardingsphere.datasource.master1.username=root
  24. spring.shardingsphere.datasource.master1.password=
  26. spring.shardingsphere.datasource.master1slave0.type=org.apache.commons.dbcp.BasicDataSource
  27. spring.shardingsphere.datasource.master1slave0.driver-class-name=com.mysql.jdbc.Driver
  28. spring.shardingsphere.datasource.master1slave0.url=jdbc:mysql://localhost:3306/master1slave0
  29. spring.shardingsphere.datasource.master1slave0.username=root
  30. spring.shardingsphere.datasource.master1slave0.password=
  31. spring.shardingsphere.datasource.master1slave1.type=org.apache.commons.dbcp.BasicDataSource
  32. spring.shardingsphere.datasource.master1slave1.driver-class-name=com.mysql.jdbc.Driver
  33. spring.shardingsphere.datasource.master1slave1.url=jdbc:mysql://localhost:3306/master1slave1
  34. spring.shardingsphere.datasource.master1slave1.username=root
  35. spring.shardingsphere.datasource.master1slave1.password=
  37. spring.shardingsphere.sharding.tables.t_order.actual-data-nodes=ds$->{0..1}.t_order$->{0..1}
  38. spring.shardingsphere.sharding.tables.t_order.table-strategy.inline.sharding-column=order_id
  39. spring.shardingsphere.sharding.tables.t_order.table-strategy.inline.algorithm-expression=t_order$->{order_id % 2}
  40. spring.shardingsphere.sharding.tables.t_order.key-generator.column=order_id
  41. spring.shardingsphere.sharding.tables.t_order.key-generator.type=SNOWFLAKE
  42. spring.shardingsphere.sharding.tables.t_order_item.actual-data-nodes=ds$->{0..1}.t_order_item$->{0..1}
  43. spring.shardingsphere.sharding.tables.t_order_item.table-strategy.inline.sharding-column=order_id
  44. spring.shardingsphere.sharding.tables.t_order_item.table-strategy.inline.algorithm-expression=t_order_item$->{order_id % 2}
  45. spring.shardingsphere.sharding.tables.t_order_item.key-generator.column=order_item_id
  46. spring.shardingsphere.sharding.tables.t_order_item.key-generator.type=SNOWFLAKE
  47. spring.shardingsphere.sharding.binding-tables=t_order,t_order_item
  48. spring.shardingsphere.sharding.broadcast-tables=t_config
  50. spring.shardingsphere.sharding.default-database-strategy.inline.sharding-column=user_id
  51. spring.shardingsphere.sharding.default-database-strategy.inline.algorithm-expression=master$->{user_id % 2}
  53. spring.shardingsphere.sharding.master-slave-rules.ds0.master-data-source-name=master0
  54. spring.shardingsphere.sharding.master-slave-rules.ds0.slave-data-source-names=master0slave0, master0slave1
  55. spring.shardingsphere.sharding.master-slave-rules.ds1.master-data-source-name=master1
  56. spring.shardingsphere.sharding.master-slave-rules.ds1.slave-data-source-names=master1slave0, master1slave1

数据分片 + 数据脱敏

  1. spring.shardingsphere.datasource.names=ds_0,ds_1
  3. spring.shardingsphere.datasource.ds_0.type=com.zaxxer.hikari.HikariDataSource
  4. spring.shardingsphere.datasource.ds_0.driver-class-name=com.mysql.jdbc.Driver
  5. spring.shardingsphere.datasource.ds_0.jdbc-url=jdbc:mysql://localhost:3306/demo_ds_0
  6. spring.shardingsphere.datasource.ds_0.username=root
  7. spring.shardingsphere.datasource.ds_0.password=
  9. spring.shardingsphere.datasource.ds_1.type=com.zaxxer.hikari.HikariDataSource
  10. spring.shardingsphere.datasource.ds_1.driver-class-name=com.mysql.jdbc.Driver
  11. spring.shardingsphere.datasource.ds_1.jdbc-url=jdbc:mysql://localhost:3306/demo_ds_1
  12. spring.shardingsphere.datasource.ds_1.username=root
  13. spring.shardingsphere.datasource.ds_1.password=
  15. spring.shardingsphere.sharding.default-database-strategy.inline.sharding-column=user_id
  16. spring.shardingsphere.sharding.default-database-strategy.inline.algorithm-expression=ds_$->{user_id % 2}
  18. spring.shardingsphere.sharding.tables.t_order.actual-data-nodes=ds_$->{0..1}.t_order_$->{0..1}
  19. spring.shardingsphere.sharding.tables.t_order.table-strategy.inline.sharding-column=order_id
  20. spring.shardingsphere.sharding.tables.t_order.table-strategy.inline.algorithm-expression=t_order_$->{order_id % 2}
  21. spring.shardingsphere.sharding.tables.t_order.key-generator.column=order_id
  22. spring.shardingsphere.sharding.tables.t_order.key-generator.type=SNOWFLAKE
  23. spring.shardingsphere.sharding.tables.t_order_item.actual-data-nodes=ds_$->{0..1}.t_order_item_$->{0..1}
  24. spring.shardingsphere.sharding.tables.t_order_item.table-strategy.inline.sharding-column=order_id
  25. spring.shardingsphere.sharding.tables.t_order_item.table-strategy.inline.algorithm-expression=t_order_item_$->{order_id % 2}
  26. spring.shardingsphere.sharding.tables.t_order_item.key-generator.column=order_item_id
  27. spring.shardingsphere.sharding.tables.t_order_item.key-generator.type=SNOWFLAKE
  28. spring.shardingsphere.sharding.encrypt-rule.encryptors.encryptor_aes.type=aes
  29. spring.shardingsphere.sharding.encrypt-rule.encryptors.encryptor_aes.props.aes.key.value=123456
  30. spring.shardingsphere.sharding.encrypt-rule.tables.t_order.columns.user_id.plainColumn=user_decrypt
  31. spring.shardingsphere.sharding.encrypt-rule.tables.t_order.columns.user_id.cipherColumn=user_encrypt
  32. spring.shardingsphere.sharding.encrypt-rule.tables.t_order.columns.user_id.assistedQueryColumn=user_assisted
  33. spring.shardingsphere.sharding.encrypt-rule.tables.t_order.columns.user_id.encryptor=encryptor_aes

治理

  1. spring.shardingsphere.datasource.names=ds,ds0,ds1
  2. spring.shardingsphere.datasource.ds.type=org.apache.commons.dbcp.BasicDataSource
  3. spring.shardingsphere.datasource.ds.driver-class-name=org.h2.Driver
  4. spring.shardingsphere.datasource.ds.url=jdbc:mysql://localhost:3306/ds
  5. spring.shardingsphere.datasource.ds.username=root
  6. spring.shardingsphere.datasource.ds.password=
  8. spring.shardingsphere.datasource.ds0.type=org.apache.commons.dbcp.BasicDataSource
  9. spring.shardingsphere.datasource.ds0.driver-class-name=com.mysql.jdbc.Driver
  10. spring.shardingsphere.datasource.ds0.url=jdbc:mysql://localhost:3306/ds0
  11. spring.shardingsphere.datasource.ds0.username=root
  12. spring.shardingsphere.datasource.ds0.password=
  14. spring.shardingsphere.datasource.ds1.type=org.apache.commons.dbcp.BasicDataSource
  15. spring.shardingsphere.datasource.ds1.driver-class-name=com.mysql.jdbc.Driver
  16. spring.shardingsphere.datasource.ds1.url=jdbc:mysql://localhost:3306/ds1
  17. spring.shardingsphere.datasource.ds1.username=root
  18. spring.shardingsphere.datasource.ds1.password=
  20. spring.shardingsphere.sharding.default-data-source-name=ds
  21. spring.shardingsphere.sharding.default-database-strategy.inline.sharding-column=user_id
  22. spring.shardingsphere.sharding.default-database-strategy.inline.algorithm-expression=ds$->{user_id % 2}
  23. spring.shardingsphere.sharding.tables.t_order.actual-data-nodes=ds$->{0..1}.t_order$->{0..1}
  24. spring.shardingsphere.sharding.tables.t_order.table-strategy.inline.sharding-column=order_id
  25. spring.shardingsphere.sharding.tables.t_order.table-strategy.inline.algorithm-expression=t_order$->{order_id % 2}
  26. spring.shardingsphere.sharding.tables.t_order.key-generator.column=order_id
  27. spring.shardingsphere.sharding.tables.t_order_item.actual-data-nodes=ds$->{0..1}.t_order_item$->{0..1}
  28. spring.shardingsphere.sharding.tables.t_order_item.table-strategy.inline.sharding-column=order_id
  29. spring.shardingsphere.sharding.tables.t_order_item.table-strategy.inline.algorithm-expression=t_order_item$->{order_id % 2}
  30. spring.shardingsphere.sharding.tables.t_order_item.key-generator.column=order_item_id
  31. spring.shardingsphere.sharding.binding-tables=t_order,t_order_item
  32. spring.shardingsphere.sharding.broadcast-tables=t_config
  34. spring.shardingsphere.orchestration.spring_boot_ds_sharding.orchestration-type=registry_center,config_center
  35. spring.shardingsphere.orchestration.spring_boot_ds_sharding.instance-type=zookeeper
  36. spring.shardingsphere.orchestration.spring_boot_ds_sharding.server-lists=localhost:2181
  37. spring.shardingsphere.orchestration.spring_boot_ds_sharding.namespace=orchestration-spring-boot-sharding-test
  38. spring.shardingsphere.orchestration.spring_boot_ds_sharding.props.overwrite=true

JNDI

以上配置示例中，所有数据源配置均可使用JNDI代替，如对于数据分片:

  1. spring.shardingsphere.datasource.names=ds0,ds1
  3. spring.shardingsphere.datasource.ds0.jndi-name=java:comp/env/jdbc/ds0
  4. spring.shardingsphere.datasource.ds1.jndi-name=jdbc/ds1
  6. spring.shardingsphere.sharding.tables.t_order.actual-data-nodes=ds$->{0..1}.t_order$->{0..1}
  7. spring.shardingsphere.sharding.tables.t_order.table-strategy.inline.sharding-column=order_id
  8. spring.shardingsphere.sharding.tables.t_order.table-strategy.inline.algorithm-expression=t_order$->{order_id % 2}
  9. spring.shardingsphere.sharding.tables.t_order.key-generator.column=order_id
  10. spring.shardingsphere.sharding.tables.t_order.key-generator.type=SNOWFLAKE
  11. spring.shardingsphere.sharding.tables.t_order_item.actual-data-nodes=ds$->{0..1}.t_order_item$->{0..1}
  12. spring.shardingsphere.sharding.tables.t_order_item.table-strategy.inline.sharding-column=order_id
  13. spring.shardingsphere.sharding.tables.t_order_item.table-strategy.inline.algorithm-expression=t_order_item$->{order_id % 2}
  14. spring.shardingsphere.sharding.tables.t_order_item.key-generator.column=order_item_id
  15. spring.shardingsphere.sharding.tables.t_order_item.key-generator.type=SNOWFLAKE
  16. spring.shardingsphere.sharding.binding-tables=t_order,t_order_item
  17. spring.shardingsphere.sharding.broadcast-tables=t_config
  19. spring.shardingsphere.sharding.default-database-strategy.inline.sharding-column=user_id
  20. spring.shardingsphere.sharding.default-database-strategy.inline.algorithm-expression=ds$->{user_id % 2}

配置项说明

数据分片

  1. spring.shardingsphere.datasource.names= #数据源名称，多数据源以逗号分隔
  3. spring.shardingsphere.datasource.<data-source-name>.type= #数据库连接池类名称
  4. spring.shardingsphere.datasource.<data-source-name>.driver-class-name= #数据库驱动类名
  5. spring.shardingsphere.datasource.<data-source-name>.url= #数据库url连接
  6. spring.shardingsphere.datasource.<data-source-name>.username= #数据库用户名
  7. spring.shardingsphere.datasource.<data-source-name>.password= #数据库密码
  8. spring.shardingsphere.datasource.<data-source-name>.xxx= #数据库连接池的其它属性
  10. spring.shardingsphere.sharding.tables.<logic-table-name>.actual-data-nodes= #由数据源名 + 表名组成，以小数点分隔。多个表以逗号分隔，支持inline表达式。缺省表示使用已知数据源与逻辑表名称生成数据节点，用于广播表（即每个库中都需要一个同样的表用于关联查询，多为字典表）或只分库不分表且所有库的表结构完全一致的情况
  12. #分库策略，缺省表示使用默认分库策略，以下的分片策略只能选其一
  14. #用于单分片键的标准分片场景
  15. spring.shardingsphere.sharding.tables.<logic-table-name>.database-strategy.standard.sharding-column= #分片列名称
  16. spring.shardingsphere.sharding.tables.<logic-table-name>.database-strategy.standard.precise-algorithm-class-name= #精确分片算法类名称，用于=和IN。该类需实现PreciseShardingAlgorithm接口并提供无参数的构造器
  17. spring.shardingsphere.sharding.tables.<logic-table-name>.database-strategy.standard.range-algorithm-class-name= #范围分片算法类名称，用于BETWEEN，可选。该类需实现RangeShardingAlgorithm接口并提供无参数的构造器
  19. #用于多分片键的复合分片场景
  20. spring.shardingsphere.sharding.tables.<logic-table-name>.database-strategy.complex.sharding-columns= #分片列名称，多个列以逗号分隔
  21. spring.shardingsphere.sharding.tables.<logic-table-name>.database-strategy.complex.algorithm-class-name= #复合分片算法类名称。该类需实现ComplexKeysShardingAlgorithm接口并提供无参数的构造器
  23. #行表达式分片策略
  24. spring.shardingsphere.sharding.tables.<logic-table-name>.database-strategy.inline.sharding-column= #分片列名称
  25. spring.shardingsphere.sharding.tables.<logic-table-name>.database-strategy.inline.algorithm-expression= #分片算法行表达式，需符合groovy语法
  27. #Hint分片策略
  28. spring.shardingsphere.sharding.tables.<logic-table-name>.database-strategy.hint.algorithm-class-name= #Hint分片算法类名称。该类需实现HintShardingAlgorithm接口并提供无参数的构造器
  30. #分表策略，同分库策略
  31. spring.shardingsphere.sharding.tables.<logic-table-name>.table-strategy.xxx= #省略
  33. spring.shardingsphere.sharding.tables.<logic-table-name>.key-generator.column= #自增列名称，缺省表示不使用自增主键生成器
  34. spring.shardingsphere.sharding.tables.<logic-table-name>.key-generator.type= #自增列值生成器类型，缺省表示使用默认自增列值生成器。可使用用户自定义的列值生成器或选择内置类型：SNOWFLAKE/UUID
  35. spring.shardingsphere.sharding.tables.<logic-table-name>.key-generator.props.<property-name>= #属性配置, 注意：使用SNOWFLAKE算法，需要配置worker.id与max.tolerate.time.difference.milliseconds属性。若使用此算法生成值作分片值，建议配置max.vibration.offset属性
  37. spring.shardingsphere.sharding.binding-tables[0]= #绑定表规则列表
  38. spring.shardingsphere.sharding.binding-tables[1]= #绑定表规则列表
  39. spring.shardingsphere.sharding.binding-tables[x]= #绑定表规则列表
  41. spring.shardingsphere.sharding.broadcast-tables[0]= #广播表规则列表
  42. spring.shardingsphere.sharding.broadcast-tables[1]= #广播表规则列表
  43. spring.shardingsphere.sharding.broadcast-tables[x]= #广播表规则列表
  45. spring.shardingsphere.sharding.default-data-source-name= #未配置分片规则的表将通过默认数据源定位
  46. spring.shardingsphere.sharding.default-database-strategy.xxx= #默认数据库分片策略，同分库策略
  47. spring.shardingsphere.sharding.default-table-strategy.xxx= #默认表分片策略，同分表策略
  48. spring.shardingsphere.sharding.default-key-generator.type= #默认自增列值生成器类型，缺省将使用org.apache.shardingsphere.core.keygen.generator.impl.SnowflakeKeyGenerator。可使用用户自定义的列值生成器或选择内置类型：SNOWFLAKE/UUID
  49. spring.shardingsphere.sharding.default-key-generator.props.<property-name>= #自增列值生成器属性配置, 比如SNOWFLAKE算法的worker.id与max.tolerate.time.difference.milliseconds
  51. spring.shardingsphere.sharding.master-slave-rules.<master-slave-data-source-name>.master-data-source-name= #详见读写分离部分
  52. spring.shardingsphere.sharding.master-slave-rules.<master-slave-data-source-name>.slave-data-source-names[0]= #详见读写分离部分
  53. spring.shardingsphere.sharding.master-slave-rules.<master-slave-data-source-name>.slave-data-source-names[1]= #详见读写分离部分
  54. spring.shardingsphere.sharding.master-slave-rules.<master-slave-data-source-name>.slave-data-source-names[x]= #详见读写分离部分
  55. spring.shardingsphere.sharding.master-slave-rules.<master-slave-data-source-name>.load-balance-algorithm-class-name= #详见读写分离部分
  56. spring.shardingsphere.sharding.master-slave-rules.<master-slave-data-source-name>.load-balance-algorithm-type= #详见读写分离部分
  58. spring.shardingsphere.props.sql.show= #是否开启SQL显示，默认值: false
  59. spring.shardingsphere.props.executor.size= #工作线程数量，默认值: CPU核数

读写分离

  1. #省略数据源配置，与数据分片一致
  3. spring.shardingsphere.sharding.master-slave-rules.<master-slave-data-source-name>.master-data-source-name= #主库数据源名称
  4. spring.shardingsphere.sharding.master-slave-rules.<master-slave-data-source-name>.slave-data-source-names[0]= #从库数据源名称列表
  5. spring.shardingsphere.sharding.master-slave-rules.<master-slave-data-source-name>.slave-data-source-names[1]= #从库数据源名称列表
  6. spring.shardingsphere.sharding.master-slave-rules.<master-slave-data-source-name>.slave-data-source-names[x]= #从库数据源名称列表
  7. spring.shardingsphere.sharding.master-slave-rules.<master-slave-data-source-name>.load-balance-algorithm-class-name= #从库负载均衡算法类名称。该类需实现MasterSlaveLoadBalanceAlgorithm接口且提供无参数构造器
  8. spring.shardingsphere.sharding.master-slave-rules.<master-slave-data-source-name>.load-balance-algorithm-type= #从库负载均衡算法类型，可选值：ROUND_ROBIN，RANDOM。若`load-balance-algorithm-class-name`存在则忽略该配置
  10. spring.shardingsphere.props.sql.show= #是否开启SQL显示，默认值: false
  11. spring.shardingsphere.props.executor.size= #工作线程数量，默认值: CPU核数
  12. spring.shardingsphere.props.check.table.metadata.enabled= #是否在启动时检查分表元数据一致性，默认值: false

数据脱敏

  1. #省略数据源配置，与数据分片一致
  3. spring.shardingsphere.encrypt.encryptors.<encryptor-name>.type= #加解密器类型，可自定义或选择内置类型：MD5/AES 
  4. spring.shardingsphere.encrypt.encryptors.<encryptor-name>.props.<property-name>= #属性配置, 注意：使用AES加密器，需要配置AES加密器的KEY属性：aes.key.value
  5. spring.shardingsphere.encrypt.tables.<table-name>.columns.<logic-column-name>.plainColumn= #存储明文的字段
  6. spring.shardingsphere.encrypt.tables.<table-name>.columns.<logic-column-name>.cipherColumn= #存储密文的字段
  7. spring.shardingsphere.encrypt.tables.<table-name>.columns.<logic-column-name>.assistedQueryColumn= #辅助查询字段，针对ShardingQueryAssistedEncryptor类型的加解密器进行辅助查询
  8. spring.shardingsphere.encrypt.tables.<table-name>.columns.<logic-column-name>.encryptor= #加密器名字

治理

  1. #省略数据源、数据分片、读写分离和数据脱敏配置
  3. spring.shardingsphere.orchestration.spring_boot_ds_sharding.orchestration-type= #配置/注册中心的类型，例如config_center/registry_center
  4. spring.shardingsphere.orchestration.spring_boot_ds_sharding.instance-type= #配置/注册中心类型。如：zookeeper
  5. spring.shardingsphere.orchestration.spring_boot_ds_sharding.server-lists= #连接配置/注册中心服务器的列表。包括IP地址和端口号。多个地址用逗号分隔。如: host1:2181,host2:2181
  6. spring.shardingsphere.orchestration.spring_boot_ds_sharding.namespace= #配置/注册中心的命名空间
  7. spring.shardingsphere.orchestration.spring_boot_ds_sharding.props.overwrite= #本地配置是否覆盖配置中心配置。如果可覆盖，每次启动都以本地配置为准
  8. spring.shardingsphere.orchestration.spring_boot_ds_sharding.props.digest= #连接配置/注册中心的权限令牌。缺省为不需要权限验证
  9. spring.shardingsphere.orchestration.spring_boot_ds_sharding.props.operation-timeout-milliseconds= #操作超时的毫秒数，默认500毫秒
  10. spring.shardingsphere.orchestration.spring_boot_ds_sharding.props.max-retries= #连接失败后的最大重试次数，默认3次
  11. spring.shardingsphere.orchestration.spring_boot_ds_sharding.props.retry-interval-milliseconds= #重试间隔毫秒数，默认500毫秒
  12. spring.shardingsphere.orchestration.spring_boot_ds_sharding.props.time-to-live-seconds= #临时节点存活秒数，默认60秒