search

tarantool / vshard

The new generation of sharding based on virtual buckets
Other
100 stars 30 forks source link

Bucket GC and send do not account foreign keys #346

Open Gerold103 opened 2 years ago

Gerold103 commented 2 years ago

Foreign keys are supported both in SQL and in raw box API. Bucket send and GC send/delete tuples without thinking they could be attached to tuples in other spaces. Need to figure out what to do here. At least properly ban the foreign-keyed spaces from being sharded. Or try to support their sharding somehow.

sergos commented 2 years ago

The ban approach is very much looks like dictionary feature request, where holder of a FK is dictionary.

Gerold103 commented 2 years ago

The first estimation (2sp) is for deciding what to do - ban or not. If not, then find a way to keep the FKs not broken.