huangconghe opened a new issue, #21373:
URL: https://github.com/apache/shardingsphere/issues/21373
## Question
start spring boot fail exception Invalid binding table configuration in
ShardingRuleConfiguration
when i remove binding-tables,start spring boot success,
when i add binding-tables,start spring boot failed
my yml follow:
`
shardingsphere:
datasource:
names: ds0
ds0:
type: com.zaxxer.hikari.HikariDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url:
jdbc:mysql://10.119.156.2:3306/appdb?serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true
username: ENC(edpsIGBaMrI7PRqnGTPzFA==)
password: ENC(uoiWRL8NWcyW9/r2NoH1hQ==)
props:
# 日志显示具体的SQL
sql-show: true
rules:
# 读写分离
readwrite-splitting:
data-sources:
com0:
type: Static
load-balancer-name: my-load-balancer
props:
write-data-source-name: ds0
read-data-source-names: ds0
load-balancers:
my-load-balancer:
type: RANDOM
sharding:
tables:
bank_statement:
actual-data-nodes:
$->{['com0']}.bank_statement_$->{['HK','PRC']}_$->{0..9}
database-strategy:
standard:
sharding-column: engagement_sharding
sharding-algorithm-name: database-inline
table-strategy:
complex:
sharding-columns: engagement_sharding
sharding-algorithm-name: table-complex-inline
bank_statement_temp:
actual-data-nodes:
$->{['com0']}.bank_statement_temp_$->{['HK','PRC']}_$->{0..9}
database-strategy:
standard:
sharding-column: engagement_sharding
sharding-algorithm-name: database-inline
table-strategy:
complex:
sharding-columns: engagement_sharding
sharding-algorithm-name: table-complex-inline
sharding-algorithms:
table-inline:
type: CLASS_BASED
props:
strategy: STANDARD #标准分片类型
algorithmClassName:
com.kpmg.smart.ematching.sharding.StandardCustomTableAlgorithm
database-inline:
type: CLASS_BASED #自定义type
props:
strategy: STANDARD #标准分片类型
algorithmClassName:
com.kpmg.smart.ematching.sharding.StandardReadWriteDbAlgorithm
table-complex-inline:
type: CLASS_BASED
props:
strategy: COMPLEX #标准分片类型
algorithmClassName:
com.kpmg.smart.ematching.sharding.ComplexCustomTableAlgorithm
binding-tables:
- bank_statement,bank_statement_temp`
--
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]
