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/13 06:40:44 UTC
[GitHub] [incubator-shardingsphere] wgy8283335 removed a comment on issue
#4665: order by not support string column when query more than one database
wgy8283335 removed a comment on issue #4665: order by not support string column when query more than one database
URL: https://github.com/apache/incubator-shardingsphere/issues/4665#issuecomment-598574794
@xiaoxiong581
```
schemaName: databasemanager
dataSources:
ds_0:
url: jdbc:mysql://192.168.137.102:3306/databasemanager?serverTimezone=UTC&useSSL=false
username: root
password: xxxxx
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
ds_1:
url: jdbc:mysql://192.168.137.102:3307/databasemanager?serverTimezone=UTC&useSSL=false
username: root
password: xxxx
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
shardingRule:
tables:
t_cluster:
actualDataNodes: ds_${0..1}.t_cluster
tableStrategy:
none:
databaseStrategy:
inline:
shardingColumn: clusterId
algorithmExpression: ds_${clusterId.hashCode().abs() % 2}
t_cluster_instance:
actualDataNodes: ds_${0..1}.t_cluster_instance
tableStrategy:
none:
databaseStrategy:
inline:
shardingColumn: clusterId
algorithmExpression: ds_${clusterId.hashCode().abs() % 2}
bindingTables:
- t_cluster,t_cluster_instance
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