News for hackers. Stuff that matters.
Re:How Figma's databases team lived to tell the scale by icedchai on Thursday March 14, 2024 @06:32PM (#39709722)
I worked at a place that did this with MySQL. Every tiny, trial account got their own database. Every huge, actual customer got their own database. Migrations were kinda painful. I would think carefully about doing it this way.
Re:How Figma's databases team lived to tell the scale by freefaler on Thursday March 14, 2024 @07:03PM (#39710016)
we've been doing this for 20k databases with mysql for the last 10+ years. It solves more problems than it creates. Migrations are trickier, but you get sharding, data isolation and easier backups that way.
Re:How Figma's databases team lived to tell the scale by icedchai on Thursday March 14, 2024 @07:11PM (#39710098)
I'm not saying it's always a bad idea, you just need to think about what you're doing. This was closer to 15 years ago now. We had to develop a bunch of our own tooling, and make our own modifications to frameworks that are now ancient history.