CodingBingo opened a new issue #11880:
URL: https://github.com/apache/shardingsphere/issues/11880
Hi, this is bingo. These days, I am trying to use shardingsphere to replace
mycat in our system.
But I found a question about useing it. I have config a
config-sharding-socialalbum.yaml, when I connect with mysql command line, and
show tables, It shows not only what I configed in config file, but also actual
table in my first datasource. I am pretty confused about this feature, if this
is a feature, why not show actual tables in the second datasource. Hope any one
who can explain the reason of this "feature", waiting for reply.
```yaml
schemaName: social_album
dataSources:
ds_social_album:
url: jdbc:mysql://*******:3306/feeds?serverTimezone=UTC&useSSL=false
username:*****
password:******
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
rules:
- !SHARDING
tables:
social_album:
actualDataNodes: ds_social_album.social_album_${(0..9).collect{t ->
t.toString().padLeft(2, '0')}}
databaseStrategy:
none: true
tableStrategy:
standard:
shardingColumn: route_key
shardingAlgorithmName: social_album_tb_sharding
shardingAlgorithms:
social_album_tb_sharding:
type: INLINE
props:
algorithm-expression: social_album_${(route_key %
10).toString().padLeft(2, '0')}
```
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
