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 2020/02/25 20:37:20 UTC

[GitHub] [incubator-shardingsphere] bharathikannan-zarget opened a new issue #4478: Is this possible to just shard databases with table rule configuration?

bharathikannan-zarget opened a new issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478
 
 
   I am trying to use ShardingSphere in one of my applications.
   Is there a way I just shard databases alone without configuring table rule configurations.
   
   Example:
   ```
   For users 1 - 100 => db0, 101-200 => db1 for all the tables.
   ```
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] menghaoranss commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
menghaoranss commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-592407267
 
 
   > Hi @kimmking @dongzl
   > 
   > Is it available part of 4.0.1? Do you have an estimated timeline for release of 4.x and 5.x?
   
   @bharathikannan-zarget We will discuss later, in which release version to fix it.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-594380477
 
 
   Thanks @KomachiSion 

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] kimmking commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-596358358
 
 
   @bharathikannan-zarget Maybe we should close it now?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-593906767
 
 
   @menghaoranss As I said before, I have 100+ tables in a database. If we want to add table rules for all the tables, it becomes a manual effort for us. What I need is, i want to shard database for all the queries executed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] dongzl commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
dongzl commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-591216318
 
 
   Hi @bharathikannan-zarget , @kimmking , I understand **default table strategy with none** config only can be used after 5.0.0 version.
   
   reference issue: #4276 .
   reference pr: #4369 .

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-593879333
 
 
   @KomachiSion 
   
   ```
   db0
   
   Tables:
   | account 
   | user
   | events
   | history
   | preferences
   
   ```
   
   db1
   
   ```
   
   Tables:
   | account 
   | user
   | events
   | history
   | preferences
   ```
   
   db2
   ```
   
   Tables:
   | account 
   | user
   | events
   | history
   | preferences
   ```
   
   So let's say
   
   ```
   Rules:
   
   tenant_id < 100 => db0
   tenant_id > 100 < 200 => db1
   tenant_id > 200 < 300 => db2
   
   Sample Queries:
   
   select * from accounts where tenant_id=10;  => db0
   
   select * from history where tenant_id = 10; => db0
   
   select * from accounts where tenant_id=180; => db1
   
   select * from history where tenant_id = 180; => db1
   
   ```
   
   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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] KomachiSion commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
KomachiSion commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-593881555
 
 
   @menghaoranss's solution is ok
   
   ```
   shardingRule:
     tables:
       account:
         actualDataNodes: ds_${0..2}.account
       user:
         actualDataNodes: ds_${0..2}.user
       ....
   
     defaultDatabaseStrategy:
       inline:
           shardingColumn: tenant_id
           algorithmExpression: ds_${tenant_id / 100}
     defaultTableStrategy:
       none:
   ```

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] menghaoranss commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
menghaoranss commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-593281706
 
 
   > @bharathikannan-zarget could you provide a full sharding rule configurations of your application?
   > And do you expect the tables in the shard databases to be exactly the same ? just like:
   > 
   > ```
   > db0.user (0-100)
   > db1.user(101-200)
   > ```
   
   I suggest, you can refer to examples/sharding-jdbc-example/other-feature-example/hit-example.
   
   Use hint strategy to achieve only shard databases.
   
   The following configuration may help you:
   ```
   shardingRule:
     tables:
       t_order:
         actualDataNodes: ds_${0..1}.t_order
       t_order_item:
         actualDataNodes: ds_${0..1}.t_order_item
     bindingTables:
       - t_order,t_order_item
     broadcastTables:
       - t_address
     
     defaultDatabaseStrategy:
       hint:
         algorithmClassName: org.apache.shardingsphere.example.hint.raw.jdbc.ModuloHintShardingAlgorithm
     defaultTableStrategy:
       none:
   ```
   then you should implement yourself algorithmClass for your sharding rule of databases.
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] KomachiSion closed issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
KomachiSion closed issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478
 
 
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] KomachiSion commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
KomachiSion commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-594247141
 
 
   I understand your problem. But if you do not config shardingRule, how can ShardingSphere judge which SQLs should be shared and which SQL not?
   If you have hundreds of tables need to shard, you should config all of them to shardingRule, what ever you manual configuration files or program generate.
   
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-592681629
 
 
   Our production release is pending for this patch. If we know the release timeline, it is easier for us to postpone or think about alternatives. 
   
   Can you guys please help?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-593363892
 
 
   Hi @menghaoranss 
   
   ```
     @Bean
     StandardShardingStrategyConfiguration standardShardingStrategyConfiguration() {
       return new StandardShardingStrategyConfiguration("tenant_id", new TenantIDBasedRoutingAlgorithm());
     }
   
   
     class TenantIDBasedRoutingAlgorithm implements PreciseShardingAlgorithm<String> {
       @Override
       public String doSharding(Collection<String> collection,
           PreciseShardingValue<String> preciseShardingValue) {
         System.out.println("Sharding Value::; " + preciseShardingValue.getValue());
         return null;
       }
     }
   ```
   
   # Sharding Config
   
   ```
   @Bean
     public DataSource createDataSource() throws SQLException {
       ShardingRuleConfiguration shardingRuleConfiguration = new ShardingRuleConfiguration();
       shardingRuleConfiguration.setDefaultDatabaseShardingStrategyConfig(standardShardingStrategyConfiguration());
   
       return ShardingDataSourceFactory.createDataSource(getDataSources(), shardingRuleConfiguration, new HashMap<>(), new Properties());
     }
   ```
   
   We use database level sharding, for all the database same tables will be present. Based on the tenant id, we will route the database accordingly. I used ShardingDatabaseStrategey with no explicit table rules, i want sharding rules applied for the tables. 
   
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] KomachiSion edited a comment on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
KomachiSion edited a comment on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-596276616
 
 
   @bharathikannan-zarget any new problem? Please close issue if no more problem. We will close issue if no response more than 7 days.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] KomachiSion commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
KomachiSion commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-596276616
 
 
   @bharathikannan-zarget ant new problem? Please close issue if no more problem. We will close issue if no response more than 7 days.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] KomachiSion commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
KomachiSion commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-593876829
 
 
   what’s your means about 100+ same tables? Is it that you shard a logicTable to 100+ shard tables?
   If so , the `actualDataNodes: ds_${0..1}.t_order_${0..50}` will be ok. 
   
   you can search and learn about the groovy language.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] bharathikannan-zarget edited a comment on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
bharathikannan-zarget edited a comment on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-592681629
 
 
   Our production release is pending for this patch. If we know the release timeline, it is easier for us to postpone or think about alternatives. 
   
   Can you guys please help? @kimmking @dongzl 

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] bharathikannan-zarget edited a comment on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
bharathikannan-zarget edited a comment on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-593879333
 
 
   @KomachiSion 
   
   ```
   db0
   
   Tables:
   | account 
   | user
   | events
   | history
   | preferences
   
   ```
   
   db1
   
   ```
   
   Tables:
   | account 
   | user
   | events
   | history
   | preferences
   ```
   
   db2
   ```
   
   Tables:
   | account 
   | user
   | events
   | history
   | preferences
   ```
   
   So let's say
   
   ```
   Rules:
   
   tenant_id < 100 => db0
   tenant_id > 100 < 200 => db1
   tenant_id > 200 < 300 => db2
   
   Sample Queries:
   
   select * from accounts where tenant_id=10;  => db0
   
   select * from history where tenant_id = 10; => db0
   
   select * from accounts where tenant_id=180; => db1
   
   select * from history where tenant_id = 180; => db1
   
   ```
   
   This is the exact scenario i am facing, is it possible to solve using ShardingSphere?. I just want to do database level sharding for all the queries executed based on a column value.
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] menghaoranss commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
menghaoranss commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-593258245
 
 
   @bharathikannan-zarget  could you provide a full  sharding rule configurations of your application?
   And do you expect the tables in the shard databases to be exactly the same ? just like: 
   ```
   db0.user (0-100)
   db1.user(101-200)
   ```

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-593870050
 
 
   @KomachiSion 
   Thanks for your response. 
   
   I have 100+ same tables in all my databases. Is that mean, I need to add all the tables in the rule configuration for sharding?
   
   Is there anyway to configure wildcard tables, like i want to do sharding for all the tables in my database based on a column value?. Please correct me if i am wrong.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-591518061
 
 
   > Oh...I will tell Haoran to merge related pr to 4.x.
   
   Hi @kimmking , it will be really great if it is part of 4.x. I am using ShardingSphere 4.x with spring boot. 

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] menghaoranss commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
menghaoranss commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-593887767
 
 
   @bharathikannan-zarget  Did our reply solve your problem?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-593102888
 
 
   @kimmking @dongzl can you guys please help?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] KomachiSion commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
KomachiSion commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-598484730
 
 
   Close issue due to no response more than 7 days

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] kimmking commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-591368144
 
 
   Oh...I will tell Haoran to merge related pr to 4.x.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] kimmking commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-591212769
 
 
   Yes, you shoud config a default database strategy with your above rule,
   and  a default table strategy with none.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] kimmking commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-591885818
 
 
   > > Oh...I will tell Haoran to merge related pr to 4.x.
   > 
   > Hi @kimmking , it will be really great if it is part of 4.x. I am using ShardingSphere 4.x with spring boot.
   
   @menghaoranss 
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
bharathikannan-zarget commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-592151586
 
 
   Hi @kimmking @dongzl 
   
   Is it available part of 4.0.1?  Do you have an estimated timeline for release of 4.x and 5.x?
   
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] KomachiSion commented on issue #4478: Is this possible to just shard databases with table rule configuration?

Posted by GitBox <gi...@apache.org>.
KomachiSion commented on issue #4478: Is this possible to just shard databases with table rule configuration?
URL: https://github.com/apache/incubator-shardingsphere/issues/4478#issuecomment-593726260
 
 
   @bharathikannan-zarget , If you do not config tableRule, ShardingSphere can't know tables you input whether need to do shard or not.
   
   So you at least config logicTableName and actualDataNodes like 
   
   ```
   shardingRule:
     tables:
       t_order:
         actualDataNodes: ds_${0..1}.t_order
       t_order_item:
         actualDataNodes: ds_${0..1}.t_order_item
      ....
   ```
   
   And then you config your `defaultDatabaseStrategy` will be ok.
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services