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 2021/08/25 10:36:12 UTC
[GitHub] [shardingsphere] chenzw93 opened a new issue #12003: shardingsphere-jdbc actual-data-nodes needs to be dynamically configured
chenzw93 opened a new issue #12003:
URL: https://github.com/apache/shardingsphere/issues/12003
hi:
There is such a scenario: I want to use the sub-table function, whether the value of actual-data-nodes can be dynamically refreshed. That is to say how to dynamically expand the sub-table and refresh the configuration of the sub-table.
For example, I use time to divide tables. At first, actual-data-nodes configured t_call_record_${[202108]}, but later, new tables tbl_log_202109, tbl_log_202110..., how to give the newly created table shardingsphere management?
Note: The table structure of tbl_log_202108 and tbl_log_202109 are exactly the same
--
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] Comven commented on issue #12003: shardingsphere-jdbc actual-data-nodes needs to be dynamically configured
Posted by GitBox <gi...@apache.org>.
Comven commented on issue #12003:
URL: https://github.com/apache/shardingsphere/issues/12003#issuecomment-906210429
@chenzw93 I have the same 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] chenzw93 commented on issue #12003: shardingsphere-jdbc actual-data-nodes needs to be dynamically configured
Posted by GitBox <gi...@apache.org>.
chenzw93 commented on issue #12003:
URL: https://github.com/apache/shardingsphere/issues/12003#issuecomment-912320388
@avalon5666 yes, any good extension points of version 4.1.1?
--
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] chenzw93 commented on issue #12003: shardingsphere-jdbc actual-data-nodes needs to be dynamically configured
Posted by GitBox <gi...@apache.org>.
chenzw93 commented on issue #12003:
URL: https://github.com/apache/shardingsphere/issues/12003#issuecomment-908383201
--
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] chenzw93 commented on issue #12003: shardingsphere-jdbc actual-data-nodes needs to be dynamically configured
Posted by GitBox <gi...@apache.org>.
chenzw93 commented on issue #12003:
URL: https://github.com/apache/shardingsphere/issues/12003#issuecomment-908383201
@Comven
yeah, thank you
I saw the IntervalShardingAlgorithm algorithm class you were talking about, and there is another AutoIntervalShardingAlgorithm algorithm class, which only exists in the 5.0.0-beta version.
If it is version 4.1.1, the current method is to use reflection to refresh the properties in the TableRule object. It feels quite inelegant. Are there any other extension points?
--
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] avalon5666 commented on issue #12003: shardingsphere-jdbc actual-data-nodes needs to be dynamically configured
Posted by GitBox <gi...@apache.org>.
avalon5666 commented on issue #12003:
URL: https://github.com/apache/shardingsphere/issues/12003#issuecomment-911125699
@chenzw93 Sorry, I misunderstood before.
It seem you need dynamically reload sharding rule?
--
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] chenzw93 closed issue #12003: shardingsphere-jdbc actual-data-nodes needs to be dynamically configured
Posted by GitBox <gi...@apache.org>.
chenzw93 closed issue #12003:
URL: https://github.com/apache/shardingsphere/issues/12003
--
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] Comven commented on issue #12003: shardingsphere-jdbc actual-data-nodes needs to be dynamically configured
Posted by GitBox <gi...@apache.org>.
Comven commented on issue #12003:
URL: https://github.com/apache/shardingsphere/issues/12003#issuecomment-906212386
@avalon5666 I think IntervalShardingAlgorithm can't solve this problem，The chronological table should not have an upper boundary. Because time always go on.
--
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] avalon5666 commented on issue #12003: shardingsphere-jdbc actual-data-nodes needs to be dynamically configured
Posted by GitBox <gi...@apache.org>.
avalon5666 commented on issue #12003:
URL: https://github.com/apache/shardingsphere/issues/12003#issuecomment-906048241
Maybe you need IntervalShardingAlgorithm? See the [UT](https://github.com/apache/shardingsphere/blob/master/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/test/java/org/apache/shardingsphere/sharding/algorithm/sharding/datetime/IntervalShardingAlgorithmTest.java).
--
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] chenzw93 commented on issue #12003: shardingsphere-jdbc actual-data-nodes needs to be dynamically configured
Posted by GitBox <gi...@apache.org>.
chenzw93 commented on issue #12003:
URL: https://github.com/apache/shardingsphere/issues/12003#issuecomment-908385252
@avalon5666
hi, brother
Do you have a better solution?
--
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] avalon5666 edited a comment on issue #12003: shardingsphere-jdbc actual-data-nodes needs to be dynamically configured
Posted by GitBox <gi...@apache.org>.
avalon5666 edited a comment on issue #12003:
URL: https://github.com/apache/shardingsphere/issues/12003#issuecomment-906848907
You can set large upper boundary.
--
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] avalon5666 commented on issue #12003: shardingsphere-jdbc actual-data-nodes needs to be dynamically configured
Posted by GitBox <gi...@apache.org>.
avalon5666 commented on issue #12003:
URL: https://github.com/apache/shardingsphere/issues/12003#issuecomment-906848907
You can set large upper boundary, and timing update configuration.
--
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] avalon5666 commented on issue #12003: shardingsphere-jdbc actual-data-nodes needs to be dynamically configured
Posted by GitBox <gi...@apache.org>.
avalon5666 commented on issue #12003:
URL: https://github.com/apache/shardingsphere/issues/12003#issuecomment-912380149
I'm not familiar with this part of code.
Recommand to try 5.x [governance](https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/usage/governance/), because 4.x is no longer maintained.
--
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] avalon5666 edited a comment on issue #12003: shardingsphere-jdbc actual-data-nodes needs to be dynamically configured
Posted by GitBox <gi...@apache.org>.
avalon5666 edited a comment on issue #12003:
URL: https://github.com/apache/shardingsphere/issues/12003#issuecomment-906848907
@Comven You can set large upper boundary.
--
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