childewuque commented on issue #10938:
URL: 
https://github.com/apache/shardingsphere/issues/10938#issuecomment-866786003


   > What is the actual version? 5 is never released yet
   
   Master,downloaded on May 20
   
   I find the method in ShardingRule.java:
       private Collection<String> getExcludedTables() {
           Collection<String> result = new HashSet<>(getTables());
           result.addAll(getAllActualTables());
           result.addAll(broadcastTables);
           return result;
       }
   
   So I add all tables at actual-data-nodes for excluding other tables.
   
   sample code:
   tables:
             sharding_product:
               actual-data-nodes: 
sdb_$->{1..4}.fads_product_$->{['0','1','2','3','4','5','6','7','8','9','a','b','c','d','e','f']}$->{['0','1','2','3','4','5','6','7','8','9','a','b','c','d','e','f']},sdb_$->{1..4}.shop_product_$->{['0','1','2','3','4','5','6','7','8','9','a','b','c','d','e','f']}$->{['0','1','2','3','4','5','6','7','8','9','a','b','c','d','e','f']}
      
   ............
   very long...
   
   Do you have more better suggestions for the case:
   Only one table to shard in my project but there are too many other tables in 
the same db. 
   Thanks.


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


Reply via email to