nevereverever commented on issue #4862: using "" will route to all datanode
URL: 
https://github.com/apache/incubator-shardingsphere/issues/4862#issuecomment-602143391
 
 
   I'm sure there's no problem with ''.So my split rule is fine.
   @kimmking 
   
   ```yaml
   schemaName: sharding_db
   
   dataSources:
     ds_0:
       url: 
jdbc:mysql://172.18.30.14:3310/db01?serverTimezone=UTC&useSSL=false&useServerPrepStmts=true&cachePrepStmts=true
       username: hotdb_root
       password: hotdb_root
       connectionTimeoutMilliseconds: 300000
       idleTimeoutMilliseconds: 600000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 200
     ds_1:
       url: 
jdbc:mysql://172.18.30.15:3310/db01?serverTimezone=UTC&useSSL=false&useServerPrepStmts=true&cachePrepStmts=true
       username: hotdb_root
       password: hotdb_root
       connectionTimeoutMilliseconds: 300000
       idleTimeoutMilliseconds: 600000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 200
   
   shardingRule:
     tables:
       tbperson:
         actualDataNodes: ds_${0..1}.tborder${0..4}
         databaseStrategy:
           standard:
             shardingColumn: order_id
             preciseAlgorithmClassName: 
org.apache..shardingsphere.sharding.rules.standard.SimpleHashShardingAlgorithm
     defaultDatabaseStrategy:
       none:
     defaultTableStrategy:
       none:

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

Reply via email to