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 2022/10/10 06:42:06 UTC

[GitHub] [shardingsphere] wsg96321 opened a new issue, #15727: How to auto discover all resource in one schema ?

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

   version: sharding proxy v5.1.0 
   
   Hi, I have many resource in a schema like test, it names ds_1,ds_2....ds_100  and other ds_500..ds_600.  When I use distSQL with my own defined algorithm , I should use the sql like 
   
   ```
   
   CREATE SHARDING ALGORITHM hint_common (
   TYPE(NAME=COMMON_SHARD)
   );
   
   CREATE SHARDING TABLE RULE hero (
   DATANODES("ds_${1..100}.hero,ds_${500..600}"),
   DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=id,SHARDING_ALGORITHM=hint_common)
   );
   
   ```
   
   Besides, the table `hero` is in all resource . So I want to now , how to auto discover the datanodes ? like below, though it is wrong: 
   ```
   CREATE SHARDING TABLE RULE hero (
   DATANODES("*"),
   DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=id,SHARDING_ALGORITHM=hint_common)
   );
   
   or 
   
   CREATE SHARDING TABLE RULE hero (
   DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=id,SHARDING_ALGORITHM=hint_common)
   );
   ```
   
   I think it is very useful for people when one table in all resources , especially when I have to delete some dataresource in my schema. Eg. I have to delete ds_50 and ds_550 in this case , so I have to execute this sql (when I have to delete many nodes it will be so complex , though I can also use enumerate with many numbers ) : 
   ```
   ALTER SHARDING TABLE RULE hero(
   DATANODES("ds_${1..49}.hero,ds_${51..100}.hero,ds_${500..549}.hero,ds_${551..600}.hero")
   );
   ```


-- 
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 #15727: How to auto discover all resource in one schema ?

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

   This issue has been inactive for a long time, so I will close it.
   
   However I'm thinking of supporting adding MySQL instances as storage nodes, which should solve the 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.

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

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

[GitHub] [shardingsphere] github-actions[bot] commented on issue #15727: How to auto discover all resource in one schema ?

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #15727:
URL: https://github.com/apache/shardingsphere/issues/15727#issuecomment-1272350280

   Hello , this issue has not received a reply for several days.
   This issue is supposed to be closed.


-- 
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] github-actions[bot] closed issue #15727: How to auto discover all resource in one schema ?

Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #15727: How to auto discover all resource in one schema ?
URL: https://github.com/apache/shardingsphere/issues/15727


-- 
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 #15727: How to auto discover all resource in one schema ?

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #15727: How to auto discover all resource in one schema ?
URL: https://github.com/apache/shardingsphere/issues/15727


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