Bingai077 commented on issue #19290:
URL:
https://github.com/apache/shardingsphere/issues/19290#issuecomment-1194083080
@RaigorJiang
I know the cause of the problem "The logical database has disappeared".
When the rule configuration of one logical database is incomplete, all other
logical database disappear.
Such as：
create database ds;
use ds;
```
ADD RESOURCE ds_abc (
HOST=192.168.0.1,
PORT=3306,
DB=ds_abc,
USER=root,
PASSWORD=123456
);
ADD RESOURCE ds_bcd (
HOST=192.168.0.1,
PORT=3306,
DB=ds_bcd,
USER=root,
PASSWORD=123456
);
CREATE SHARDING ALGORITHM database_inline (
TYPE(NAME=inline,PROPERTIES("algorithm-expression"="ds_${tenant_code}"))
);
CREATE DEFAULT SHARDING DATABASE STRATEGY (
TYPE =
standard,SHARDING_COLUMN=tenant_code,SHARDING_ALGORITHM=database_inline
);
==================================================================
CREATE SHARDING TABLE RULE order_test (
datanodes("ds_${['abc','bcd']}.order_test")
)
CREATE SHARDING TABLE RULE user_test (
datanodes("ds_${['abc','bcd']}.user_test")
)
```
This occurs when the rules for the logical table have not been configured.
--
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]
