You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "zigaai (via GitHub)" <gi...@apache.org> on 2023/03/12 10:57:17 UTC

[GitHub] [shardingsphere] zigaai opened a new issue, #24562: how can i refresh the DataNodes when i add a new dataSources

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

   ## Question
   
   **For English only**, other languages will not accept.
   
   1. i find the solution in 5.1.0 version [how to config actual-data-nodes while my actual-data-nodes tables is dynamic](https://github.com/apache/shardingsphere/issues/16725)
   but in 5.3.1 version, AlgorithmProvidedShardingRuleConfiguration is not found, can i refresh the datanodes in shardingjdbc interface without sharding-proxy?
   
   2. when i want to sharding database only, it not work, i see the code, when i dont config the rules.tables, it return the ShardingIgnoreRoutingEngine; i want to config the defaultDatabaseStrategy then can make all tables invoke this DatabaseStrategy, how can i config 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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] RaigorJiang commented on issue #24562: how can i refresh the DataNodes when i add a new dataSources

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24562:
URL: https://github.com/apache/shardingsphere/issues/24562#issuecomment-1465546239

   > 1. oh, i look forward to this feature! and when this feature will implement?
   > 2. if i only sharding the database with all tables, it is very complicated. i want to sharding tables what i set default database strategy in configuration files
   
   1. This is a long-term goal, and it will face many difficulties, and the time cannot be specified
   2. The configuration provided above is already the simplest configuration, and there is no better choice **at present**. (Because of the existence of single table, users must tell SS which tables are sharding 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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] RaigorJiang closed issue #24562: how can i refresh the DataNodes when i add a new dataSources

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #24562: how can i refresh the DataNodes when i add a new dataSources
URL: https://github.com/apache/shardingsphere/issues/24562


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] zigaai commented on issue #24562: how can i refresh the DataNodes when i add a new dataSources

Posted by "zigaai (via GitHub)" <gi...@apache.org>.
zigaai commented on issue #24562:
URL: https://github.com/apache/shardingsphere/issues/24562#issuecomment-1467450250

   thanks for your reply


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] RaigorJiang commented on issue #24562: how can i refresh the DataNodes when i add a new dataSources

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24562:
URL: https://github.com/apache/shardingsphere/issues/24562#issuecomment-1467589583

   > thanks for your reply
   
   OK, you are welcome!


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] zigaai commented on issue #24562: how can i refresh the DataNodes when i add a new dataSources

Posted by "zigaai (via GitHub)" <gi...@apache.org>.
zigaai commented on issue #24562:
URL: https://github.com/apache/shardingsphere/issues/24562#issuecomment-1465333808

   1. oh, i look forward to this feature! and when this feature will implement?
   2. if i only sharding the database with all tables, it is very complicated. i want to sharding tables what i set default database strategy in configuration files


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] RaigorJiang commented on issue #24562: how can i refresh the DataNodes when i add a new dataSources

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24562:
URL: https://github.com/apache/shardingsphere/issues/24562#issuecomment-1465201911

   1. JDBC does not provide an API for dynamically modifying rules. Currently, using JDBC + Proxy DistSQL is the only official way. In the future, JDBC may also support DistSQL.
   2. Even if you use DatabaseStrategy only, you need to declare which tables are sharding tables in the sharding rule. The following method is feasible:
   ```yaml
   rules:
   - !SHARDING
      tables: # list sharding tables
        table_a:
          actualDataNodes: xxx
        table_b:
          actualDataNodes: xxx
        table_c:
          actualDataNodes: xxx
      #...
      defaultDatabaseStrategy:
        standard:
          shardingColumn: order_id
          shardingAlgorithmName: database_inline
      defaultTableStrategy:
        none:
      shardingAlgorithms:
        database_inline:
          type: INLINE
          props:
            algorithm-expression: xxx
   ```


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org