I wonder if it is better to shard by tenant (customer) in the first place. A bit more complexity upfront but not that much really. Tenants could initially share

I wonder if it is better to shard by tenant (customer) in the first place. A bit more complexity upfront but not that much really. Tenants could initially share a DB on different schemas. YAGNI? But you could say that about a lot of things and this also gives you other options like releasing to a subset of customers (rolling release system like LTS etc.) I work somewhere that has done this but for other driving reasons but it is a scalability dream. It is the web equivalent of desktop software running in Citrix! I haven’t seen anyone tune SQL in 4 years there whereas it has been a regular pastime everywhere else! Yes you can’t do this for social networks but you can do it for most “customer with isolated clients” type shops which is most companies.