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/11/17 08:08:52 UTC
[GitHub] [shardingsphere] liujiling1 opened a new issue #13660: Only sub-database, no table, do not want to configure each table one by one strategy
liujiling1 opened a new issue #13660:
URL: https://github.com/apache/shardingsphere/issues/13660
To achieve multi-tenancy, the structure of each data source table is completely the same, and there are many tables. I don’t want to configure each table again. Is there a 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] CrackerSuperior commented on issue #13660: Only sub-database, no table, do not want to configure each table one by one strategy
Posted by GitBox <gi...@apache.org>.
CrackerSuperior commented on issue #13660:
URL: https://github.com/apache/shardingsphere/issues/13660#issuecomment-971362468
> I don’t want to configure each table, can I only sub-database, not table. like this rules: - !SHARDING # tables: # cst_truck_scale_info: # actualDataNodes: ds_${0..1}.cst_truck_scale_info # bindingTables: # - cst_truck_scale_info broadcastTables: - sys_city defaultDatabaseStrategy: hint: shardingAlgorithmName: hint_db defaultTableStrategy: none: shardingAlgorithms: hint_db: type: HINT_DB
This seems impossible. If the table name is not configured, he will treat it as a vertical table and randomly place it in a data source
--
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] CrackerSuperior commented on issue #13660: Only sub-database, no table, do not want to configure each table one by one strategy
Posted by GitBox <gi...@apache.org>.
CrackerSuperior commented on issue #13660:
URL: https://github.com/apache/shardingsphere/issues/13660#issuecomment-971342827
Do you mean that it only divides the database without dividing the table?
--
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] liujiling1 commented on issue #13660: Only sub-database, no table, do not want to configure each table one by one strategy
Posted by GitBox <gi...@apache.org>.
liujiling1 commented on issue #13660:
URL: https://github.com/apache/shardingsphere/issues/13660#issuecomment-971354283
I don’t want to configure each table, can I only sub-database, not table.
like this
rules:
- !SHARDING
# tables:
# cst_truck_scale_info:
# actualDataNodes: ds_${0..1}.cst_truck_scale_info
# bindingTables:
# - cst_truck_scale_info
broadcastTables:
- sys_city
defaultDatabaseStrategy:
hint:
shardingAlgorithmName: hint_db
defaultTableStrategy:
none:
shardingAlgorithms:
hint_db:
type: HINT_DB
--
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] liujiling1 commented on issue #13660: Only sub-database, no table, do not want to configure each table one by one strategy
Posted by GitBox <gi...@apache.org>.
liujiling1 commented on issue #13660:
URL: https://github.com/apache/shardingsphere/issues/13660#issuecomment-971343975
Yes, can I set a unified default rule without configuring the rules for each table?
------------------ 原始邮件 ------------------
发件人: ***@***.***>;
发送时间: 2021年11月17日(星期三) 下午4:23
收件人: ***@***.***>;
抄送: ***@***.***>; ***@***.***>;
主题: Re: [apache/shardingsphere] Only sub-database, no table, do not want to configure each table one by one strategy (Issue #13660)
Do you mean that it only divides the database without dividing the table?
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub, or unsubscribe.
Triage notifications on the go with GitHub Mobile for iOS or Android.
--
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] terrymanu closed issue #13660: Only sub-database, no table, do not want to configure each table one by one strategy
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #13660:
URL: https://github.com/apache/shardingsphere/issues/13660
--
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] CrackerSuperior commented on issue #13660: Only sub-database, no table, do not want to configure each table one by one strategy
Posted by GitBox <gi...@apache.org>.
CrackerSuperior commented on issue #13660:
URL: https://github.com/apache/shardingsphere/issues/13660#issuecomment-971344981
> Yes, can I set a unified default rule without configuring the rules for each table?
> […](#)
> ------------------ 原始邮件 ------------------ 发件人: ***@***.***>; 发送时间: 2021年11月17日(星期三) 下午4:23 收件人: ***@***.***>; 抄送: ***@***.***>; ***@***.***>; 主题: Re: [apache/shardingsphere] Only sub-database, no table, do not want to configure each table one by one strategy (Issue #13660) Do you mean that it only divides the database without dividing the table? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe. Triage notifications on the go with GitHub Mobile for iOS or Android.
Yes, if your table structure is the same, you only need to configure the default sub-database rules.
--
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] CrackerSuperior commented on issue #13660: Only sub-database, no table, do not want to configure each table one by one strategy
Posted by GitBox <gi...@apache.org>.
CrackerSuperior commented on issue #13660:
URL: https://github.com/apache/shardingsphere/issues/13660#issuecomment-971350234
like this:
``` yaml
rules:
- !SHARDING
tables:
insert3:
actualDataNodes: ds_${0..1}.insert3
keyGenerateStrategy:
column: sharding
keyGeneratorName: snowflake
insert4:
actualDataNodes: ds_${0..1}.insert4
keyGenerateStrategy:
column: sharding
keyGeneratorName: snowflake
defaultDatabaseStrategy:
standard:
shardingColumn: sharding
shardingAlgorithmName: database_inline
shardingAlgorithms:
database_inline:
type: INLINE
props:
algorithm-expression: ds_${sharding % 2}
keyGenerators:
snowflake:
type: SNOWFLAKE
props:
worker-id: 123
```
--
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] terrymanu commented on issue #13660: Only sub-database, no table, do not want to configure each table one by one strategy
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #13660:
URL: https://github.com/apache/shardingsphere/issues/13660#issuecomment-997433082
User can use DistSQL to config sharding rule.
It can be easy to auto-gen DistSQL if you want.
--
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