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?
   
   
   
   
   ------------------&nbsp;原始邮件&nbsp;------------------
   发件人: ***@***.***&gt;; 
   发送时间: 2021年11月17日(星期三) 下午4:23
   收件人: ***@***.***&gt;; 
   抄送: ***@***.***&gt;; ***@***.***&gt;; 
   主题: 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?
   > […](#)
   > ------------------&nbsp;原始邮件&nbsp;------------------ 发件人: ***@***.***&gt;; 发送时间: 2021年11月17日(星期三) 下午4:23 收件人: ***@***.***&gt;; 抄送: ***@***.***&gt;; ***@***.***&gt;; 主题: 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