| dataSources: |
| ds_0: !!com.zaxxer.hikari.HikariDataSource |
| username: root |
| password: |
| jdbcUrl: jdbc:mysql://ss.benchmark.rangerouting.sharding.ds0:3306/shardingsphere_benchmark?serverTimezone=UTC&useSSL=false |
| driverClassName: com.mysql.jdbc.Driver |
| connectionTimeout: 30000 |
| idleTimeout: 60000 |
| maxLifetime: 1800000 |
| maximumPoolSize: 200 |
| dataSourceProperties: |
| cachePrepStmts: true |
| prepStmtCacheSize: 250 |
| prepStmtCacheSqlLimit: 2048 |
| useLocalSessionState: true |
| rewriteBatchedStatements: true |
| cacheResultSetMetadata: true |
| cacheServerConfiguration: true |
| elideSetAutoCommits: true |
| maintainTimeStats: false |
| netTimeoutForStreamingResults: 0 |
| useServerPrepStmts: true |
| ds_1: !!com.zaxxer.hikari.HikariDataSource |
| username: root |
| password: |
| jdbcUrl: jdbc:mysql://ss.benchmark.rangerouting.sharding.ds1:3306/shardingsphere_benchmark?serverTimezone=UTC&useSSL=false |
| driverClassName: com.mysql.jdbc.Driver |
| connectionTimeout: 30000 |
| idleTimeout: 60000 |
| maxLifetime: 1800000 |
| maximumPoolSize: 200 |
| dataSourceProperties: |
| cachePrepStmts: true |
| prepStmtCacheSize: 250 |
| prepStmtCacheSqlLimit: 2048 |
| useLocalSessionState: true |
| rewriteBatchedStatements: true |
| cacheResultSetMetadata: true |
| cacheServerConfiguration: true |
| elideSetAutoCommits: true |
| maintainTimeStats: false |
| netTimeoutForStreamingResults: 0 |
| useServerPrepStmts: true |
| ds_2: !!com.zaxxer.hikari.HikariDataSource |
| username: root |
| password: |
| jdbcUrl: jdbc:mysql://ss.benchmark.rangerouting.sharding.ds2:3306/shardingsphere_benchmark?serverTimezone=UTC&useSSL=false |
| driverClassName: com.mysql.jdbc.Driver |
| connectionTimeout: 30000 |
| idleTimeout: 60000 |
| maxLifetime: 1800000 |
| maximumPoolSize: 200 |
| dataSourceProperties: |
| cachePrepStmts: true |
| prepStmtCacheSize: 250 |
| prepStmtCacheSqlLimit: 2048 |
| useLocalSessionState: true |
| rewriteBatchedStatements: true |
| cacheResultSetMetadata: true |
| cacheServerConfiguration: true |
| elideSetAutoCommits: true |
| maintainTimeStats: false |
| netTimeoutForStreamingResults: 0 |
| useServerPrepStmts: true |
| ds_3: !!com.zaxxer.hikari.HikariDataSource |
| username: root |
| password: |
| jdbcUrl: jdbc:mysql://ss.benchmark.rangerouting.sharding.ds3:3306/shardingsphere_benchmark?serverTimezone=UTC&useSSL=false |
| driverClassName: com.mysql.jdbc.Driver |
| connectionTimeout: 30000 |
| idleTimeout: 60000 |
| maxLifetime: 1800000 |
| maximumPoolSize: 200 |
| dataSourceProperties: |
| cachePrepStmts: true |
| prepStmtCacheSize: 250 |
| prepStmtCacheSqlLimit: 2048 |
| useLocalSessionState: true |
| rewriteBatchedStatements: true |
| cacheResultSetMetadata: true |
| cacheServerConfiguration: true |
| elideSetAutoCommits: true |
| maintainTimeStats: false |
| netTimeoutForStreamingResults: 0 |
| useServerPrepStmts: true |
| |
| rules: |
| - !SHARDING |
| tables: |
| sbtest: |
| actualDataNodes: ds_${0..3}.sbtest${0..99} |
| databaseStrategy: |
| standard: |
| shardingColumn: id |
| shardingAlgorithmName: database_inline |
| tableStrategy: |
| standard: |
| shardingColumn: k |
| shardingAlgorithmName: table_inline |
| keyGenerateStrategy: |
| column: id |
| keyGeneratorName: increment |
| bindingTables: |
| - sbtest |
| |
| shardingAlgorithms: |
| database_inline: |
| type: INLINE |
| props: |
| algorithm-expression: ds_${id % 4} |
| table_inline: |
| type: INLINE |
| props: |
| algorithm-expression: sbtest${k % 100} |
| keyGenerators: |
| increment: |
| type: SNOWFLAKE |
| |
| props: |
| max.connections.size.per.query: 10 |
| acceptor.size: 200 # The default value is available processors count * 2. |
| executor.size: 200 # Infinite by default. |
| query.with.cipher.column: true |
| sql.show: false |
| allow.range.query.with.inline.sharding: false |
| check.table.metadata.enabled: false |