News for hackers. Stuff that matters.

A comment on Scaling Databases at Activision [pdf].

Re:Scaling Databases at Activision [pdf] by XCSme on Tuesday April 25, 2023 @09:40AM (#35700319)
> 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?

[ Parent | on HN ]
Re:Scaling Databases at Activision [pdf] by harshitgangal on Tuesday April 25, 2023 @10:00AM (#35700591)
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
[ Parent | on HN ]