YAML configuration

5.0.0-alpha

Data Sharding

Configuration Item Explanation

  1. dataSources: # Omit the data source configuration, please refer to the usage
  3. rules:
  4. - !SHARDING
  5.   tables: # Sharding table configuration
  6.     <logic-table-name> (+): # Logic table name
  7.       actualDataNodes (?): # Describe data source names and actual tables (refer to Inline syntax rules)
  8.       databaseStrategy (?): # Databases sharding strategy, use default databases sharding strategy if absent. sharding strategy below can choose only one.
  9.         standard: # For single sharding column scenario
  10.           shardingColumn: # Sharding column name
  11.           shardingAlgorithmName: # Sharding algorithm name
  12.         complex: # For multiple sharding columns scenario
  13.           shardingColumns: # Sharding column names, multiple columns separated with comma
  14.           shardingAlgorithmName: # Sharding algorithm name
  15.         hint: # Sharding by hint
  16.           shardingAlgorithmName: # Sharding algorithm name
  17.         none: # Do not sharding
  18.       tableStrategy: # Tables sharding strategy, same as database sharding strategy
  19.       keyGenerateStrategy: # Key generator strategy
  20.         column: # Column name of key generator
  21.         keyGeneratorName: # Key generator name
  22.   autoTables: # Auto Sharding table configuration
  23.     t_order_auto: # Logic table name
  24.       actualDataSources (?): # Data source names
  25.       shardingStrategy: # Sharding strategy
  26.         standard: # For single sharding column scenario
  27.           shardingColumn: # Sharding column name
  28.           shardingAlgorithmName: # Auto sharding algorithm name
  29.   bindingTables (+): # Binding tables
  30.     - <logic_table_name_1, logic_table_name_2, ...> 
  31.     - <logic_table_name_1, logic_table_name_2, ...> 
  32.   broadcastTables (+): # Broadcast tables
  33.     - <table-name>
  34.     - <table-name>
  35.   defaultDatabaseStrategy: # Default strategy for database sharding
  36.   defaultTableStrategy: # Default strategy for table sharding
  37.   defaultKeyGenerateStrategy: # Default Key generator strategy
  39.   # Sharding algorithm configuration
  40.   shardingAlgorithms:
  41.     <sharding-algorithm-name> (+): # Sharding algorithm name
  42.       type: # Sharding algorithm type
  43.       props: # Sharding algorithm properties
  44.       # ...
  46.   # Key generate algorithm configuration
  47.   keyGenerators:
  48.     <key-generate-algorithm-name> (+): # Key generate algorithm name
  49.       type: # Key generate algorithm type
  50.       props: # Key generate algorithm properties
  51.       # ...
  53. props:
  54.   # ...

Replica Query

Configuration Item Explanation

  1. dataSources: # Omit the data source configuration, please refer to the usage
  3. rules:
  4. - !REPLICA_QUERY
  5.   dataSources:
  6.     <data-source-name> (+): # Logic data source name of replica query
  7.       primaryDataSourceName: # Primary data source name
  8.       replicaDataSourceNames: 
  9.         - <replica-data_source-name> (+) # Replica data source name
  10.       loadBalancerName: # Load balance algorithm name
  12.   # Load balance algorithm configuration
  13.   loadBalancers:
  14.     <load-balancer-name> (+): # Load balance algorithm name
  15.       type: # Load balance algorithm type
  16.       props: # Load balance algorithm properties
  17.         # ...
  19. props:
  20.   # ...

Please refer to Built-in Load Balance Algorithm List for more details about type of algorithm.

Encryption

Configuration Item Explanation

  1. dataSource: # Omit the data source configuration, please refer to the usage
  3. rules:
  4. - !ENCRYPT
  5.   tables:
  6.     <table-name> (+): # Encrypt table name
  7.       columns:
  8.         <column-name> (+): # Encrypt logic column name
  9.           cipherColumn: # Cipher column name
  10.           assistedQueryColumn (?):  # Assisted query column name
  11.           plainColumn (?): # Plain column name
  12.           encryptorName: # Encrypt algorithm name
  14.   # Encrypt algorithm configuration
  15.   encryptors:
  16.     <encrypt-algorithm-name> (+): # Encrypt algorithm name
  17.       type: # Encrypt algorithm type
  18.       props: # Encrypt algorithm properties
  19.         # ...
  21.   queryWithCipherColumn: # Whether query with cipher column for data encrypt. User you can use plaintext to query if have

Please refer to Built-in Encrypt Algorithm List for more details about type of algorithm.

Shadow DB

Configuration Item Explanation

  1. dataSources: # Omit the data source configuration, please refer to the usage
  3. rules:
  4. - !SHADOW
  5.   column: # Shadow column name
  6.   sourceDataSourceNames: # Source Data Source names
  7.      # ...
  8.   shadowDataSourceNames: # Shadow Data Source names
  9.      # ... 
  11. props:
  12.   # ...

Governance

Configuration Item Explanation

  1. governance:
  2.   name: # Governance name
  3.   registryCenter: # Registry center
  4.     type: # Governance instance type. Example:Zookeeper, etcd
  5.     serverLists: # The list of servers that connect to governance instance, including IP and port number; use commas to separate 
  6.   overwrite: # Whether to overwrite local configurations with config center configurations; if it can, each initialization should refer to local configurations

ShardingSphere-4.x

Data Sharding

Configuration Item Explanation

  1. dataSources: # Data sources configuration, multiple `data_source_name` available
  2.   <data_source_name>: # <!!Data source pool implementation class> `!!` means class instantiation
  3.     driverClassName: # Class name of database driver
  4.     url: # Database URL
  5.     username: # Database username
  6.     password: # Database password
  7.     # ... Other properties for data source pool
  9. shardingRule:
  10.   tables: # Sharding rule configuration, multiple `logic_table_name` available
  11.     <logic_table_name>: # Name of logic table
  12.       actualDataNodes: # Describe data source names and actual tables, delimiter as point, multiple data nodes separated with comma, support inline expression. Absent means sharding databases only. Example: ds${0..7}.tbl${0..7}
  14.       databaseStrategy: # Databases sharding strategy, use default databases sharding strategy if absent. sharding strategy below can choose only one
  15.         standard: # Standard sharding scenario for single sharding column
  16.           shardingColumn: # Name of sharding column
  17.             preciseAlgorithmClassName: # Precise algorithm class name used for `=` and `IN`. This class need to implements PreciseShardingAlgorithm, and require a no argument constructor
  18.             rangeAlgorithmClassName: # Range algorithm class name used for `BETWEEN`. This class need to implements RangeShardingAlgorithm, and require a no argument constructor
  19.           complex: # Complex sharding scenario for multiple sharding columns
  20.             shardingColumns: # Names of sharding columns. Multiple columns separated with comma
  21.             algorithmClassName: # Complex sharding algorithm class name. This class need to implements ComplexKeysShardingAlgorithm, and require a no argument constructor
  22.           inline: # Inline expression sharding scenario for single sharding column
  23.             shardingColumn: # Name of sharding column
  24.             algorithmInlineExpression: # Inline expression for sharding algorithm
  25.           hint: # Hint sharding strategy
  26.             algorithmClassName: # Hint sharding algorithm class name. This class need to implements HintShardingAlgorithm, and require a no argument constructor
  27.             none: # Do not sharding
  28.       tableStrategy: # Tables sharding strategy, Same as databases sharding strategy
  29.       keyGenerator:
  30.         column: # Column name of key generator
  31.         type: # Type of key generator, use default key generator if absent, and there are three types to choose, that is, SNOWFLAKE/UUID
  32.         props: # Properties, Notice: when use SNOWFLAKE, `worker.id` and `max.tolerate.time.difference.milliseconds` for `SNOWFLAKE` need to be set. To use the generated value of this algorithm as sharding value, it is recommended to configure `max.vibration.offset`         
  34.   bindingTables: # Binding table rule configurations
  35.     - <logic_table_name1, logic_table_name2, ...>
  36.     - <logic_table_name3, logic_table_name4, ...>
  37.     - <logic_table_name_x, logic_table_name_y, ...>
  38.   broadcastTables: # Broadcast table rule configurations
  39.     - table_name1
  40.     - table_name2
  41.     - table_name_x
  43.   defaultDataSourceName: # If table not configure at table rule, will route to defaultDataSourceName  
  44.   defaultDatabaseStrategy: # Default strategy for sharding databases, same as databases sharding strategy
  45.   defaultTableStrategy: # Default strategy for sharding tables, same as tables sharding strategy
  46.   defaultKeyGenerator:
  47.     type: # Type of default key generator, use user-defined ones or built-in ones, e.g. SNOWFLAKE, UUID. Default key generator is `org.apache.shardingsphere.core.keygen.generator.impl.SnowflakeKeyGenerator`
  48.     column: # Column name of default key generator
  49.     props: # Properties of default key generator, e.g. `worker.id` and `max.tolerate.time.difference.milliseconds` for `SNOWFLAKE` 
  51.   masterSlaveRules: # Read-write splitting rule configuration, more details can reference Read-write splitting part
  52.     <data_source_name>: # Data sources configuration, need consist with data source map, multiple `data_source_name` available
  53.       masterDataSourceName: # more details can reference Read-write splitting part
  54.       slaveDataSourceNames: # more details can reference Read-write splitting part
  55.       loadBalanceAlgorithmType: # more details can reference Read-write splitting part
  56.       props: # Properties configuration of load balance algorithm
  57.         <property-name>: # property key value pair
  59. props: # Properties
  60.   sql.show: # To show SQLS or not, default value: false
  61.   executor.size: # The number of working threads, default value: CPU count
  62.   check.table.metadata.enabled: # To check the metadata consistency of all the tables or not, default value : false
  63.   max.connections.size.per.query: # The maximum connection number allocated by each query of each physical database. default value: 1

Read-Write Split

Configuration Item Explanation

  1. dataSources: # Omit data source configurations; keep it consistent with data sharding
  3. masterSlaveRule:
  4.   name: # Read-write split data source name
  5.   masterDataSourceName: # Master data source name
  6.   slaveDataSourceNames: # Slave data source name
  7.     - <data_source_name1>
  8.     - <data_source_name2>
  9.     - <data_source_name_x>
  10.   loadBalanceAlgorithmType: # Slave database load balance algorithm type; optional value, ROUND_ROBIN and RANDOM, can be omitted if `loadBalanceAlgorithmClassName` exists
  11.   props: # Properties configuration of load balance algorithm
  12.     <property-name>: # property key value pair
  14. props: # Property configuration
  15.   sql.show: # Show SQL or not; default value: false
  16.   executor.size: # Executing thread number; default value: CPU core number
  17.   check.table.metadata.enabled: # Whether to check table metadata consistency when it initializes; default value: false
  18.   max.connections.size.per.query: # The maximum connection number allocated by each query of each physical database. default value: 1

Create a DataSource through the YamlMasterSlaveDataSourceFactory factory class:

  1. DataSource dataSource = YamlMasterSlaveDataSourceFactory.createDataSource(yamlFile);

Data Masking

Configuration Item Explanation

  1. dataSource: # Ignore data sources configuration
  3. encryptRule:
  4.   encryptors:
  5.     <encryptor-name>:
  6.       type: # Encryptor type
  7.       props: # Properties, e.g. `aes.key.value` for AES encryptor
  8.         aes.key.value:
  9.   tables:
  10.     <table-name>:
  11.       columns:
  12.         <logic-column-name>:
  13.           plainColumn: # Plaintext column name
  14.           cipherColumn: # Ciphertext column name
  15.           assistedQueryColumn: # AssistedColumns for query，when use ShardingQueryAssistedEncryptor, it can help query encrypted data
  16.           encryptor: # Encrypt name

Orchestration

Configuration Item Explanation

  1. dataSources: # Omit data source configurations
  2. shardingRule: # Omit sharding rule configurations
  3. masterSlaveRule: # Omit read-write split rule configurations
  4. encryptRule: # Omit encrypt rule configurations
  6. orchestration:
  7.   name: # Orchestration instance name
  8.   overwrite: # Whether to overwrite local configurations with registry center configurations; if it can, each initialization should refer to local configurations
  9.   registry: # Registry center configuration
  10.     type: # Registry center type. Example:zookeeper
  11.     serverLists: # The list of servers that connect to registry center, including IP and port number; use commas to seperate addresses, such as: host1:2181,host2:2181
  12.     namespace: # Registry center namespace
  13.     digest: # The token that connects to the registry center; default means there is no need for authentication
  14.     operationTimeoutMilliseconds: # Default value: 500 milliseconds
  15.     maxRetries: # Maximum retry time after failing; default value: 3 times
  16.     retryIntervalMilliseconds: # Interval time to retry; default value: 500 milliseconds
  17.     timeToLiveSeconds: # Living time of temporary nodes; default value: 60 seconds

ShardingSphere-3.x

Data Sharding

Configuration Item Explanation

  1. dataSources: # Data sources configuration, multiple `data_source_name` available
  2.   <data_source_name>: # <!!Data source pool implementation class> `!!` means class instantiation
  3.     driverClassName: # Class name of database driver
  4.     url: # Database URL
  5.     username: # Database username
  6.     password: # Database password
  7.     # ... Other properties for data source pool
  9. shardingRule:
  10.   tables: # Sharding rule configuration, multiple `logic_table_name` available
  11.     <logic_table_name>: # Name of logic table
  12.       actualDataNodes: # Describe data source names and actual tables, delimiter as point, multiple data nodes separated with comma, support inline expression. Absent means sharding databases only. Example: ds${0..7}.tbl${0..7}
  14.       databaseStrategy: # Databases sharding strategy, use default databases sharding strategy if absent. sharding strategy below can choose only one
  15.         standard: # Standard sharding scenario for single sharding column
  16.           shardingColumn: # Name of sharding column
  17.             preciseAlgorithmClassName: # Precise algorithm class name used for `=` and `IN`. This class need to implements PreciseShardingAlgorithm, and require a no argument constructor
  18.             rangeAlgorithmClassName: # Range algorithm class name used for `BETWEEN`. This class need to implements RangeShardingAlgorithm, and require a no argument constructor
  19.           complex: # Complex sharding scenario for multiple sharding columns
  20.             shardingColumns: # Names of sharding columns. Multiple columns separated with comma
  21.             algorithmClassName: # Complex sharding algorithm class name. This class need to implements ComplexKeysShardingAlgorithm, and require a no argument constructor
  22.           inline: # Inline expression sharding scenario for single sharding column
  23.             shardingColumn: # Name of sharding column
  24.             algorithmInlineExpression: # Inline expression for sharding algorithm
  25.           hint: # Hint sharding strategy
  26.             algorithmClassName: # Hint sharding algorithm class name. This class need to implements HintShardingAlgorithm, and require a no argument constructor
  27.             none: # Do not sharding
  28.       tableStrategy: # Tables sharding strategy, Same as databases sharding strategy
  30.       keyGeneratorColumnName: # Column name of key generator, do not use Key generator if absent
  31.       keyGeneratorClassName: # Key generator, use default key generator if absent. This class need to implements KeyGenerator, and require a no argument constructor
  33.       logicIndex: # Name if logic index. If use `DROP INDEX XXX` SQL in Oracle/PostgreSQL, This property needs to be set for finding the actual tables
  34.   bindingTables: # Binding table rule configurations
  35.     - <logic_table_name1, logic_table_name2, ...>
  36.     - <logic_table_name3, logic_table_name4, ...>
  37.     - <logic_table_name_x, logic_table_name_y, ...>
  38.   bindingTables: # Broadcast table rule configurations
  39.     - table_name1
  40.     - table_name2
  41.     - table_name_x
  43.   defaultDataSourceName: # If table not configure at table rule, will route to defaultDataSourceName  
  44.   defaultDatabaseStrategy: # Default strategy for sharding databases, same as databases sharding strategy
  45.   defaultTableStrategy: # Default strategy for sharding tables, same as tables sharding strategy
  46.   defaultKeyGeneratorClassName: # Default key generator class name, default value is `io.shardingsphere.core.keygen.DefaultKeyGenerator`. This class need to implements KeyGenerator, and require a no argument constructor
  48.   masterSlaveRules: # Read-write splitting rule configuration, more details can reference Read-write splitting part
  49.     <data_source_name>: # Data sources configuration, need consist with data source map, multiple `data_source_name` available
  50.       masterDataSourceName: # more details can reference Read-write splitting part
  51.       slaveDataSourceNames: # more details can reference Read-write splitting part
  52.       loadBalanceAlgorithmType: # more details can reference Read-write splitting part
  53.       loadBalanceAlgorithmClassName: # more details can reference Read-write splitting part
  54.       configMap: # User-defined arguments
  55.         key1: value1
  56.         key2: value2
  57.         keyx: valuex
  59. props: # Properties
  60.   sql.show: # To show SQLS or not, default value: false
  61.   executor.size: # The number of working threads, default value: CPU count
  62.   check.table.metadata.enabled: #T o check the metadata consistency of all the tables or not, default value : false
  64. configMap: # User-defined arguments
  65.   key1: value1
  66.   key2: value2
  67.   keyx: valuex

Read-Write Split

Configuration Item Explanation

  1. dataSources: # Ignore data sources configuration, same as sharding
  3. masterSlaveRule:
  4.   name: # Name of master slave data source
  5.   masterDataSourceName: # Name of master data source
  6.   slaveDataSourceNames: # Names of Slave data sources
  7.     - <data_source_name1>
  8.     - <data_source_name2>
  9.     - <data_source_name_x>
  10.   loadBalanceAlgorithmClassName: # Load balance algorithm class name. This class need to implements MasterSlaveLoadBalanceAlgorithm, and require a no argument constructor
  11.   loadBalanceAlgorithmType: # Load balance algorithm type, values should be: `ROUND_ROBIN` or `RANDOM`. Ignore if `loadBalanceAlgorithmClassName` is present
  13. props: # Properties
  14.   sql.show: # To show SQLS or not, default value: false
  15.   executor.size: # The number of working threads, default value: CPU count
  16.   check.table.metadata.enabled: # To check the metadata consistency of all the tables or not, default value : false
  18. configMap: # User-defined arguments
  19.   key1: value1
  20.   key2: value2
  21.   keyx: valuex

Create a DataSource through the YamlMasterSlaveDataSourceFactory factory class:

  1. DataSource dataSource = MasterSlaveDataSourceFactory.createDataSource(yamlFile);

Orchestration

Configuration Item Explanation

  1. dataSources: # Ignore data sources configuration
  2. shardingRule: # Ignore sharding rule configuration
  3. masterSlaveRule: # Ignore master slave rule configuration
  5. orchestration:
  6.   name: # Name of orchestration instance
  7.   overwrite: # Use local configuration to overwrite registry center or not
  8.   registry: # Registry configuration
  9.     serverLists: # Registry servers list, multiple split as comma. Example: host1:2181,host2:2181
  10.     namespace: # Namespace of registry
  11.     digest: # Digest for registry. Default is not need digest.
  12.     operationTimeoutMilliseconds: # Operation timeout time in milliseconds, default value is 500 milliseconds
  13.     maxRetries: # Max number of times to retry, default value is 3
  14.     retryIntervalMilliseconds: # Time interval in milliseconds on each retry, default value is 500 milliseconds
  15.     timeToLiveSeconds: # Time to live in seconds of ephemeral keys, default value is 60 seconds

ShardingSphere-2.x

Data Sharding

Configuration Item Explanation

  1. dataSources:
  2.   db0: !!org.apache.commons.dbcp.BasicDataSource
  3.     driverClassName: org.h2.Driver
  4.     url: jdbc:h2:mem:db0;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
  5.     username: sa
  6.     password: 
  7.     maxActive: 100
  8.   db1: !!org.apache.commons.dbcp.BasicDataSource
  9.     driverClassName: org.h2.Driver
  10.     url: jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
  11.     username: sa
  12.     password: 
  13.     maxActive: 100
  15. shardingRule:
  16.   tables:
  17.     config:
  18.       actualDataNodes: db${0..1}.t_config
  19.     t_order: 
  20.       actualDataNodes: db${0..1}.t_order_${0..1}
  21.       databaseStrategy: 
  22.         standard:
  23.           shardingColumn: user_id
  24.           preciseAlgorithmClassName: io.shardingjdbc.core.yaml.fixture.SingleAlgorithm
  25.       tableStrategy: 
  26.         inline:
  27.           shardingColumn: order_id
  28.           algorithmInlineExpression: t_order_${order_id % 2}
  29.       keyGeneratorColumnName: order_id
  30.       keyGeneratorClass: io.shardingjdbc.core.yaml.fixture.IncrementKeyGenerator
  31.     t_order_item:
  32.       actualDataNodes: db${0..1}.t_order_item_${0..1}
  33.       # The strategy of binding the rest of the tables in the table is the same as the strategy of the first table
  34.       databaseStrategy: 
  35.         standard:
  36.           shardingColumn: user_id
  37.           preciseAlgorithmClassName: io.shardingjdbc.core.yaml.fixture.SingleAlgorithm
  38.       tableStrategy: 
  39.         inline:
  40.           shardingColumn: order_id
  41.           algorithmInlineExpression: t_order_item_${order_id % 2}
  42.   bindingTables:
  43.     - t_order,t_order_item
  44.   # Default database sharding strategy
  45.   defaultDatabaseStrategy:
  46.     none:
  47.   defaultTableStrategy:
  48.     complex:
  49.       shardingColumns: id, order_id
  50.       algorithmClassName: io.shardingjdbc.core.yaml.fixture.MultiAlgorithm
  51.   props:
  52.     sql.show: true

Read-Write Split

concept

In order to relieve the pressure on the database, the write and read operations are separated into different data sources. The write library is called the master library, and the read library is called the slave library. One master library can be configured with multiple slave libraries.

Supported

  1. Provides a read-write separation configuration with one master and multiple slaves, which can be used independently or with sub-databases and sub-meters.
  2. Independent use of read-write separation to support SQL transparent transmission.
  3. In the same thread and the same database connection, if there is a write operation, subsequent read operations will be read from the main library to ensure data consistency.
  4. Spring namespace.
  5. Hint-based mandatory main library routing.

Unsupported

  1. Data synchronization between the master library and the slave library.
  2. Data inconsistency caused by the data synchronization delay of the master library and the slave library.
  3. Double writing or multiple writing in the main library.

rule configuration

  1. dataSources:
  2.   db_master: !!org.apache.commons.dbcp.BasicDataSource
  3.     driverClassName: org.h2.Driver
  4.     url: jdbc:h2:mem:db_master;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
  5.     username: sa
  6.     password: 
  7.     maxActive: 100
  8.   db_slave_0: !!org.apache.commons.dbcp.BasicDataSource
  9.     driverClassName: org.h2.Driver
  10.     url: jdbc:h2:mem:db_slave_0;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
  11.     username: sa
  12.     password: 
  13.     maxActive: 100
  14.   db_slave_1: !!org.apache.commons.dbcp.BasicDataSource
  15.       driverClassName: org.h2.Driver
  16.       url: jdbc:h2:mem:db_slave_1;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
  17.       username: sa
  18.       password: 
  19.       maxActive: 100
  21. masterSlaveRule:
  22.   name: db_ms
  23.   masterDataSourceName: db_master
  24.   slaveDataSourceNames: [db_slave_0, db_slave_1]
  25.   configMap:
  26.     key1: value1

Create a DataSource through the MasterSlaveDataSourceFactory factory class:

  1. DataSource dataSource = MasterSlaveDataSourceFactory.createDataSource(yamlFile);

Orchestration

Configuration Item Explanation

Zookeeper sharding table and database Orchestration Configuration Item Explanation

  1. dataSources: Data sources configuration
  3. shardingRule: Sharding rule configuration
  5. orchestration: Zookeeper Orchestration Configuration
  6.   name: Orchestration name
  7.   overwrite: Whether to overwrite local configurations with config center configurations; if it can, each initialization should refer to local configurations
  8.   zookeeper: Registry center Configuration
  9.     namespace: Registry center namespace
  10.     serverLists: The list of servers that connect to governance instance, including IP and port number, use commas to separate, such as: host1:2181,host2:2181
  11.     baseSleepTimeMilliseconds: The initial millisecond value of the interval to wait for retry
  12.     maxSleepTimeMilliseconds: The maximum millisecond value of the interval to wait for retry
  13.     maxRetries: The maximum retry count
  14.     sessionTimeoutMilliseconds: The session timeout milliseconds
  15.     connectionTimeoutMilliseconds: The connecton timeout milliseconds
  16.     digest: Permission token to connect to Zookeeper. default no authorization is required

Etcd sharding table and database Orchestration Configuration Item Explanation

  1. dataSources: Data sources configuration
  3. shardingRule: Sharding rule configuration
  5. orchestration: Etcd Orchestration Configuration
  6.   name: Orchestration name
  7.   overwrite: Whether to overwrite local configurations with config center configurations; if it can, each initialization should refer to local configurations
  8.   etcd: Registry center Configuration
  9.     serverLists: The list of servers that connect to governance instance, including IP and port number, use commas to separate, such as: http://host1:2379,http://host2:2379
  10.     timeToLiveSeconds: Time to live seconds for ephemeral nodes
  11.     timeoutMilliseconds: The request timeout milliseconds
  12.     maxRetries: The maximum retry count
  13.     retryIntervalMilliseconds: The retry interval milliseconds

Sharding table and database Data source construction method

  1. DataSource dataSource = OrchestrationShardingDataSourceFactory.createDataSource(yamlFile);

Read-Write split Data source construction method

  1. DataSource dataSource = OrchestrationMasterSlaveDataSourceFactory.createDataSource(yamlFile);