3 ms·

> PROBLEM Certain Vitess scaling operations fail on FK violation > SOLUTION Temporarily disable FK checks on the target shards I always found disabling FK chec

by XCSme 4y ago

> PROBLEM Certain Vitess scaling operations fail on FK violation > SOLUTION Temporarily disable FK checks on the target shards I always found disabling FK checks weird, as in, once you disable them, isn't the integrity permanently lost? Or does it check again the integrity once it's reactivated?

harshitgangal 4y ago
just the right time to ask this question. We have an RFC open to add support for foreign keys in Vitess https://github.com/vitessio/vitess/issues/12967 https://github.com/vitessio/vitess/issues/12967