huangxinjian opened a new issue, #19828:
URL: https://github.com/apache/shardingsphere/issues/19828

   ## Background
   
   Suppose there is the following scenario of horizontal sub-database sub-table
   
![image](https://user-images.githubusercontent.com/39627746/182534697-bb62258a-95fa-4856-9bef-0cba6c3d2312.png)
   
   In the old single database, there are many tables like `User` that are only 
divided into **databases** but not **tables**.There may be only some tables 
that require further table splitting operations, Like `order`.
   
   From my current understanding, the following configuration needs to be done
   ```java
   // divided into databases and table
   result.getTables().add(getOrderTableRuleConfiguration());
   result.getTables().add(getOrderItemTableRuleConfiguration());
   // only divided into databases
   result.getTables().add(new ShardingTableRuleConfiguration("t_user"));
   ```
   ## Question
   
   So when the business database is divided into horizontal sub-database and 
sub-table, there may be thousands of tables like User. Do we need to configure 
a tableRule for each table?
   
   I coludn't find the answer on doc. 
   
   
   I wonder if there is a default sub-database or sub-table routing rule? If a 
table is not configured, it will be routed according to the default global 
routing rules
   


-- 
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]

Reply via email to