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 2021/01/20 09:59:22 UTC
[GitHub] [shardingsphere] duanzonglong edited a comment on issue #6759: SHOW FULL COLUMNS get wrong
duanzonglong edited a comment on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-763481518
Hi,this is the whole yaml.
I have two tables don't need sharding,how to config?
`
schemaName: sharding_wms
dataSources:
wms_base:
url: jdbc:mysql://172.172.172.213:3360/scms_wms?useUnicode=true&characterEncoding=UTF8
username: root
password: xxxx
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 65
wms_sd0:
url: jdbc:mysql://172.172.172.213:3360/wms_sd0?useUnicode=true&characterEncoding=UTF8
username: root
password: xxxx
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 65
wms_sd1:
url: jdbc:mysql://172.172.172.213:3360/wms_sd1?useUnicode=true&characterEncoding=UTF8
username: root
password: xxxx
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 65
shardingRule:
defaultDatabaseStrategy:
standard:
shardingColumn: tenant_id
preciseAlgorithmClassName: com.hrsoft.sharding.strategy.core.DatabaseStrategy
tables:
ds_changelog_lock:
actualDataNodes: wms_base.ds_changelog_lock
databaseStrategy:
none:
tableStrategy:
none:
ds_changelog:
actualDataNodes: wms_base.ds_changelog
databaseStrategy:
none:
tableStrategy:
none:
bindingTables:
- ds_changelog_lock,ds_changelog
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