News for hackers. Stuff that matters.
Re:Multi-Tenant Architectures by laluser on Sunday August 30, 2020 @07:14PM (#24326831)
Everything is simple when you're starting out. Over time, you'd see that users can have wildly different load patterns, which will affect how you scale and shard your database over time. It's a huge pain to manage and grow.
Re:Multi-Tenant Architectures by zepolen on Sunday August 30, 2020 @09:00PM (#24327482)
It's way easier to scale a shared app/db, anyone who tells you different hasn't had to do devops.

Rule No. 1, never shard by account_id, Pareto is just waiting you kick you in the ass. Always shard by whatever gives the best distribution of workload.

There are more rules of course.

Re:Multi-Tenant Architectures by sb8244 on Sunday August 30, 2020 @09:28PM (#24327627)
I've always considered data isolation as the #1 priority when it comes to tenancy. Does that mean that the sharding should defacto be done on the tenant ID?
Re:Multi-Tenant Architectures by pietherr on Monday August 31, 2020 @04:37AM (#24329514)
You shard for load distribution. If data isolation is #1 priority, use separate tables, schemas, database instances.
Re:Multi-Tenant Architectures by zepolen on Monday August 31, 2020 @08:25PM (#24337274)
Separate disks, separate machines hell even separate networks, proper data isolation can be super expensive to do right.