You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/03/22 03:43:41 UTC
[GitHub] [incubator-shardingsphere] nevereverever commented on issue #4862:
using "" will route to all datanode
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:
users@infra.apache.org
With regards,
Apache Git Services