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 2020/12/23 08:05:36 UTC

[GitHub] [shardingsphere] verify31 opened a new issue #8734: about broadcast table type

verify31 opened a new issue #8734:
URL: https://github.com/apache/shardingsphere/issues/8734


   ## Question
   
   what kinds of table can be config as broadcast table ? and how does  broadcast table work? 
   for example,some opetate log table can be config as broadcast 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.

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



[GitHub] [shardingsphere] verify31 commented on issue #8734: about broadcast table type

Posted by GitBox <gi...@apache.org>.
verify31 commented on issue #8734:
URL: https://github.com/apache/shardingsphere/issues/8734#issuecomment-749997779


   version:4.1.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.

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



[GitHub] [shardingsphere] verify31 commented on issue #8734: about broadcast table type

Posted by GitBox <gi...@apache.org>.
verify31 commented on issue #8734:
URL: https://github.com/apache/shardingsphere/issues/8734#issuecomment-751176354


   > [DOC](https://shardingsphere.apache.org/document/current/en/features/sharding/) will give you a hand.
   
   I have read this docoument,and not ge the right answer。


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

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



[GitHub] [shardingsphere] verify31 closed issue #8734: about broadcast table type

Posted by GitBox <gi...@apache.org>.
verify31 closed issue #8734:
URL: https://github.com/apache/shardingsphere/issues/8734


   


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

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



[GitHub] [shardingsphere] tristaZero commented on issue #8734: about broadcast table type

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #8734:
URL: https://github.com/apache/shardingsphere/issues/8734#issuecomment-750773850


   [DOC](https://shardingsphere.apache.org/document/current/en/features/sharding/) will give you a hand.


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

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



[GitHub] [shardingsphere] tristaZero closed issue #8734: about broadcast table type

Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #8734:
URL: https://github.com/apache/shardingsphere/issues/8734


   


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

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



[GitHub] [shardingsphere] verify31 commented on issue #8734: about broadcast table type

Posted by GitBox <gi...@apache.org>.
verify31 commented on issue #8734:
URL: https://github.com/apache/shardingsphere/issues/8734#issuecomment-751972501


   yes ,but I am still confused,eg,I hava one operate log table ,first I need to insert one row in this table,and then I need to insert the data in the second table,if I have db0,db1,db2,db3 4 databases,and in this scenario ,how does sharding handle it,if I hava one insert failed ,what about other theres?


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

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



[GitHub] [shardingsphere] verify31 edited a comment on issue #8734: about broadcast table type

Posted by GitBox <gi...@apache.org>.
verify31 edited a comment on issue #8734:
URL: https://github.com/apache/shardingsphere/issues/8734#issuecomment-751972501


   yes ,but I am still confused,eg,I hava one operate log table(config as  broadcast table ) ,first I need to insert one row in this table,and then I need to insert the data in the second table,if I have db0,db1,db2,db3 4 databases,and in this scenario ,how does sharding handle it,if I hava one insert failed ,what about other theres?


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

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



[GitHub] [shardingsphere] verify31 commented on issue #8734: about broadcast table type

Posted by GitBox <gi...@apache.org>.
verify31 commented on issue #8734:
URL: https://github.com/apache/shardingsphere/issues/8734#issuecomment-752892889


   All right,tks


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

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



[GitHub] [shardingsphere] tristaZero commented on issue #8734: about broadcast table type

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #8734:
URL: https://github.com/apache/shardingsphere/issues/8734#issuecomment-751656380


   I guess the following description in [1] is what you are looking for.
   
   ```
   Broadcast Table
   
   It refers to tables that exist in all sharding database sources. Their structures and data are the same in each database. It can be applied to the small data volume scenario that needs to correlate with big data volume tables to query, dictionary table for example.
   ```
   
   [1]https://shardingsphere.apache.org/document/current/en/features/sharding/concept/sql/
   


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

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



[GitHub] [shardingsphere] tristaZero commented on issue #8734: about broadcast table type

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #8734:
URL: https://github.com/apache/shardingsphere/issues/8734#issuecomment-752832985


   Hi, ShardingSphere will send the `insert` SQL to all the actual tables of this broadcast table in different databases. In most cases, it will succeed. However, if you worry about its atomicity, please use the distributed transaction (Please consult the doc). 


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

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