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/07/15 08:28:46 UTC
[GitHub] [shardingsphere] lijintaotzx opened a new issue #6353: Shardingsphere-proxy data sharding, How to deal with foreign keys？
lijintaotzx opened a new issue #6353:
URL: https://github.com/apache/shardingsphere/issues/6353
Newbies are just getting started with shadingsphere
I have several tables: user group, user, order, order details
Now the order table has a huge amount of data and needs to be split. I plan to use shardingsphere proxy to take orders and order details to other database and save them in many tables
However, there is a foreign key relationship between the order table and the user table. After configuring shardingsphere and created usertable , when creating the order table in the proxy, a foreign key error will always be reported. If only the table is not divided into the database, the error will not occur.
More doubts: Can't two tables with foreign key relationship be divided into two stocks?
----------------------------------------------------------------
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] kimmking closed issue #6353: Shardingsphere-proxy data sharding, How to deal with foreign keys？
Posted by GitBox <gi...@apache.org>.
kimmking closed issue #6353:
URL: https://github.com/apache/shardingsphere/issues/6353
----------------------------------------------------------------
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 edited a comment on issue #6353: Shardingsphere-proxy data sharding, How to deal with foreign keys？
Posted by GitBox <gi...@apache.org>.
tristaZero edited a comment on issue #6353:
URL: https://github.com/apache/shardingsphere/issues/6353#issuecomment-659280786
Hi @lijintaotzx
If two tables are involved, you can consider shard them with the same sharding strategy, namely `bind-table`. Please consult our official doc. However, I am not sure if `bind-table` is suitable for your case.
Best,
Trista
----------------------------------------------------------------
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 #6353: Shardingsphere-proxy data sharding, How to deal with foreign keys？
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6353:
URL: https://github.com/apache/shardingsphere/issues/6353#issuecomment-659280786
If two tables are involved, you can consider shard them with the same sharding strategy, namely `bind-table`. Please consult our official doc. However, I am not sure if `bind-table` is suitable for your case.
----------------------------------------------------------------
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