News for hackers. Stuff that matters.
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.