| dataSources: |
| ds_0: !!com.zaxxer.hikari.HikariDataSource |
| username: root |
| password: |
| jdbcUrl: jdbc:mysql://ss.benchmark.singlerouting.shardingmasterslaveencrypt.master.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_0_slave_0: !!com.zaxxer.hikari.HikariDataSource |
| username: root |
| password: |
| jdbcUrl: jdbc:mysql://ss.benchmark.singlerouting.shardingmasterslaveencrypt.slave.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.singlerouting.shardingmasterslaveencrypt.master.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_1_slave_1: !!com.zaxxer.hikari.HikariDataSource |
| username: root |
| password: |
| jdbcUrl: jdbc:mysql://ss.benchmark.singlerouting.shardingmasterslaveencrypt.slave.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.singlerouting.shardingmasterslaveencrypt.master.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_2_slave_2: !!com.zaxxer.hikari.HikariDataSource |
| username: root |
| password: |
| jdbcUrl: jdbc:mysql://ss.benchmark.singlerouting.shardingmasterslaveencrypt.slave.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.singlerouting.shardingmasterslaveencrypt.master.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 |
| ds_3_slave_3: !!com.zaxxer.hikari.HikariDataSource |
| username: root |
| password: |
| jdbcUrl: jdbc:mysql://ss.benchmark.singlerouting.shardingmasterslaveencrypt.slave.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: ms_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: ms_ds_${id % 4} |
| table_inline: |
| type: INLINE |
| props: |
| algorithm-expression: sbtest${k % 100} |
| keyGenerators: |
| increment: |
| type: SNOWFLAKE |
| |
| - !ENCRYPT |
| encryptors: |
| encryptor_aes: |
| props: |
| aes-key-value: '123456abc' |
| type: AES |
| encryptor_md5: |
| type: md5 |
| tables: |
| sbtest: |
| columns: |
| c: |
| cipherColumn: c |
| encryptorName: encryptor_aes |
| pad: |
| cipherColumn: pad |
| encryptorName: encryptor_md5 |
| |
| - !MASTER_SLAVE |
| dataSources: |
| ms_ds_0: |
| name: ms_ds_0 |
| masterDataSourceName: ds_0 |
| slaveDataSourceNames: [ds_0_slave_0] |
| loadBalancerName: roundRobin |
| ms_ds_1: |
| name: ms_ds_1 |
| masterDataSourceName: ds_1 |
| slaveDataSourceNames: [ds_1_slave_1] |
| loadBalancerName: roundRobin |
| ms_ds_2: |
| name: ms_ds_2 |
| masterDataSourceName: ds_2 |
| slaveDataSourceNames: [ds_2_slave_2] |
| loadBalancerName: roundRobin |
| ms_ds_3: |
| name: ms_ds_3 |
| masterDataSourceName: ds_3 |
| slaveDataSourceNames: [ds_3_slave_3] |
| loadBalancerName: roundRobin |
| loadBalancers: |
| roundRobin: |
| type: ROUND_ROBIN |
| |
| props: |
| max.connections.size.per.query: 10 |
| acceptor.size: 200 # The default value is afalsevailable 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 |