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/09/23 03:47:32 UTC
[GitHub] [shardingsphere] marker-wu opened a new issue #12641: Where to configure AutoTables' library sub-database strategy？
marker-wu opened a new issue #12641:
URL: https://github.com/apache/shardingsphere/issues/12641
here is my config-sharding.yaml
I configured a default database strategy, but it is invalid for AutoTables
According to my configuration, this piece of data is expected to go to ds_1, but it is routed to ds_0
--
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] marker-wu commented on issue #12641: Where to configure AutoTables' library sub-database strategy in version 5.0.0-beta？
Posted by GitBox <gi...@apache.org>.
marker-wu commented on issue #12641:
URL: https://github.com/apache/shardingsphere/issues/12641#issuecomment-925661900
> > In Autotables mode, the sub-database strategy cannot be specified. Isn't this a problem?
>
> Yes, because autoTable does not need to configure databaseStrategy.
> I suggest you read the article I provided. Thank you.
Since it is an automatic sharding, why do you need to specify a table sharding strategy? Do not specify a database sharding strategy?
Is this semi-automatic？
--
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 #12641: Where to configure AutoTables' library sub-database strategy in version 5.0.0-beta？
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12641:
URL: https://github.com/apache/shardingsphere/issues/12641#issuecomment-925506488
Hi @marker-wu
If you want to control the sharding strategy yourself, you should use the `tables` configuration instead of `autoTables`.
Here is an [example](https://github.com/apache/shardingsphere/blob/master/examples/shardingsphere-proxy-example/shardingsphere-proxy-memory-example/shardingsphere-proxy-memory-local-sharding-example/src/main/resources/conf/config-sharding.yaml) showing the different configurations of tables and autoTables.
For more information about `autoTable`, you can refer to this article:
https://mp.weixin.qq.com/s/fDYqW-yJIVpkcUDNT-gsuA
--
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] marker-wu commented on issue #12641: Where to configure AutoTables' library sub-database strategy in version 5.0.0-beta？
Posted by GitBox <gi...@apache.org>.
marker-wu commented on issue #12641:
URL: https://github.com/apache/shardingsphere/issues/12641#issuecomment-925642744
> @marker-wu
> Has your problem been solved?
I used the way of tables from the beginning, and it worked very well. But later I saw the Autotables method and tried to use it, and found this 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] RaigorJiang commented on issue #12641: Where to configure AutoTables' library sub-database strategy in version 5.0.0-beta？
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12641:
URL: https://github.com/apache/shardingsphere/issues/12641#issuecomment-925654287
> In Autotables mode, the sub-database strategy cannot be specified. Isn't this a problem?
Yes, because autoTable does not need to configure databaseStrategy.
I suggest you read the article I provided. Thank you.
--
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 #12641: Where to configure AutoTables' library sub-database strategy in version 5.0.0-beta？
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12641:
URL: https://github.com/apache/shardingsphere/issues/12641#issuecomment-925647939
> I used the way of tables from the beginning, and it worked very well. But later I saw the Autotables method and tried to use it, and found this problem
This is not a problem, they are different configuration ways, and you can't mix them arbitrarily.
--
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 #12641: Where to configure AutoTables' library sub-database strategy in version 5.0.0-beta？
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12641:
URL: https://github.com/apache/shardingsphere/issues/12641#issuecomment-925628137
@marker-wu
Has your problem been solved?
--
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 #12641: Where to configure AutoTables' library sub-database strategy in version 5.0.0-beta？
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12641:
URL: https://github.com/apache/shardingsphere/issues/12641#issuecomment-925676414
@marker-wu
Sorry, you made a mistake. AutoTable does not need to configure `databaseStrategy`, nor does it have `tableStrategy`, it uses `shardingStrategy`.
Please refer to the documentation.
https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/yaml/sharding/
--
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 #12641: Where to configure AutoTables' library sub-database strategy in version 5.0.0-beta？
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12641:
URL: https://github.com/apache/shardingsphere/issues/12641#issuecomment-925824262
Hi @marker-wu
If your question is solved, we will close this issue.
--
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] marker-wu commented on issue #12641: Where to configure AutoTables' library sub-database strategy in version 5.0.0-beta？
Posted by GitBox <gi...@apache.org>.
marker-wu commented on issue #12641:
URL: https://github.com/apache/shardingsphere/issues/12641#issuecomment-925650186
> > I used the way of tables from the beginning, and it worked very well. But later I saw the Autotables method and tried to use it, and found this problem
>
> This is not a problem, they are different configuration ways, and you can't mix them arbitrarily.
In Autotables mode, the sub-database strategy cannot be specified. Isn't this a 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] marker-wu edited a comment on issue #12641: Where to configure AutoTables' library sub-database strategy in version 5.0.0-beta？
Posted by GitBox <gi...@apache.org>.
marker-wu edited a comment on issue #12641:
URL: https://github.com/apache/shardingsphere/issues/12641#issuecomment-925661900
> > In Autotables mode, the sub-database strategy cannot be specified. Isn't this a problem?
>
> Yes, because autoTable does not need to configure databaseStrategy.
> I suggest you read the article I provided. Thank you.
Since it is an automatic sharding, why do you need to specify a table sharding strategy? Do not need to specify a database sharding strategy
Is this semi-automatic？
--
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 #12641: Where to configure AutoTables' library sub-database strategy in version 5.0.0-beta？
Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #12641:
URL: https://github.com/apache/shardingsphere/issues/12641
--
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