Management

    global rule configurations, including configure the username and password for ShardingSphere-Proxy.

    1. - !AUTHORITY
    2. users:
    3.   - root@%:root
    4.   - sharding@127.0.0.1:sharding
    5. provider:
    6.   type: ALL_PERMITTED

    /props

    A collection of multiple database connection pools, whose properties (e.g. DBCP, C3P0, Druid and HikariCP) are configured by users themselves.

    1. ds_0:
    2.   initializationFailTimeout: 1
    3.   validationTimeout: 5000
    4.   maxLifetime: 1800000
    5.   leakDetectionThreshold: 0
    6.   password: root
    7.   idleTimeout: 60000
    9.   dataSourceClassName: com.zaxxer.hikari.HikariDataSource
    10.   maximumPoolSize: 50
    11.   connectionTimeout: 30000
    12.   username: root
    13.   poolName: HikariPool-1
    14. ds_1:
    15.   initializationFailTimeout: 1
    16.   validationTimeout: 5000
    17.   maxLifetime: 1800000
    18.   leakDetectionThreshold: 0
    19.   minimumIdle: 1
    20.   password: root
    21.   idleTimeout: 60000
    22.   jdbcUrl: jdbc:mysql://127.0.0.1:3306/ds_1?serverTimezone=UTC&useSSL=false
    23.   dataSourceClassName: com.zaxxer.hikari.HikariDataSource
    24.   maximumPoolSize: 50
    26.   poolName: HikariPool-2

    /metadata/${databaseName}/versions/${versionNumber}/rules

    Use separate node storage for each table, dynamic modification of metadata content is not supported currently.

    1. name: t_order                             # Table name
    2. columns:                                  # Columns
    3.   id:                                     # Column name
    4.     caseSensitive: false
    5.     dataType: 0
    6.     generated: false
    7.     name: id
    8.     primaryKey: trues
    9.   order_id:
    10.     caseSensitive: false
    11.     dataType: 0
    12.     generated: false
    13.     name: order_id
    14.     primaryKey: false
    15. indexs:                                   # Index
    16.   t_user_order_id_index:                  # Index name

    /nodes/compute_nodes

    It is able to orchestrate replica database, delete or disable data dynamically.