Re:How Figma's databases team lived to tell the scale
by tharkun__ on Friday March 15, 2024 @08:28PM
(#39722136)
I don't see how it follows from that. "Attach" seems very generic.
But I do see now, searching for that part of the info specifically, they mention
Peppy Peppers’ orders can be migrated by running SELECT FROM orders WHERE shop_id = 1 FOR UPDATE on Pod 1’s database
Yeah that's just having the tenant id in the table directly. Oh well!
Sounds like this is just normal sharding. Completely different from having a totally separate schema like GP proposes (with that approach you don't use sharding keys at all).