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 2022/06/05 15:31:02 UTC
[GitHub] [shardingsphere] imjcoder commented on issue #18177: #C1997Runtime exception...
imjcoder commented on issue #18177:
URL: https://github.com/apache/shardingsphere/issues/18177#issuecomment-1146834641
@zjcnb
hello,this is config
and Are there any cases that can run?
too many bugs.....
`# 使用navicate for mysql的时候显示的数据库的名称
schemaName: sharding_db
dataSources:
db0:
url: jdbc:mysql://127.0.0.1:3306/db0?serverTimezone=UTC&useSSL=false
username: root
password: root
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
db1:
url: jdbc:mysql://127.0.0.1:3306/db1?serverTimezone=UTC&useSSL=false
username: root
password: root
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
rules:
- !SHARDING
tables:
t_order:
actualDataNodes: db${0..1}.t_order${0..3}
tableStrategy:
standard:
shardingColumn: order_id
shardingAlgorithmName: userTableInline
databaseStrategy:
standard:
shardingColumn: order_id
shardingAlgorithmName: userDbInline
shardingAlgorithms:
userTableInline:
type: INLINE
props:
algorithm-expression: t_order${order_id % 4}
userDbInline:
type: INLINE
props:
algorithm-expression: db${order_id % 2}
`
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org