fengchao-GitHub opened a new issue #9219:
URL: https://github.com/apache/shardingsphere/issues/9219
version: sharding proxy 4.1.1
config-sharding.yml:
schemaName: sharding_db
dataSources:
ds1:
url:
jdbc:mysql://192.168.255.115/testdb1?serverTimezone=UTC&useSSL=false&characterEncoding=utf8
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
ds1_slave:
url:
jdbc:mysql://192.168.255.116/testdb1?serverTimezone=UTC&useSSL=false&characterEncoding=utf8
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
ds2:
url:
jdbc:mysql://192.168.255.115/testdb2?serverTimezone=UTC&useSSL=false&characterEncoding=utf8
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
ds2_slave:
url:
jdbc:mysql://192.168.255.116/testdb2?serverTimezone=UTC&useSSL=false&characterEncoding=utf8
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
shardingRule:
tables:
t_order:
actualDataNodes: ms_ds${1..2}.t_order${1..2}
databaseStrategy:
inline:
shardingColumn: uid
algorithmExpression: ms_ds${uid % 2+1}
tableStrategy:
inline:
shardingColumn: id
algorithmExpression: t_order${id % 2 + 1}
keyGenerator:
type: SNOWFLAKE
column: id
bindingTables:
- t_order
broadcastTables:
- t_user
- t_org
# defaultDataSourceName: ds1
defaultTableStrategy:
none:
masterSlaveRules:
ms_ds1:
masterDataSourceName: ds1
slaveDataSourceNames:
- ds1_slave
loadBalanceAlgorithmType: ROUND_ROBIN
ms_ds2:
masterDataSourceName: ds2
slaveDataSourceNames:
- ds2_slave
loadBalanceAlgorithmType: ROUND_ROBIN
I can`t use these sql :
select count(1) from(select * from t_order) c ;
select count(1) from (select u.id , count(1) from t_order o inner JOIN
t_user u on o.uid=u.id GROUP BY u.id )c ;
select count(1) from (select count(1) from(select * from t_order) c )b ;
----------------------------------------------------------------
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]
