3 ms·
You don't have to pick one or the other. We have a standard horizontally sharded database setup where large customers get their own servers while smaller ones a
by paxys 6y ago
You don't have to pick one or the other. We have a standard horizontally sharded database setup where large customers get their own servers while smaller ones are colocated.
One thing we do strictly enforce is that the schema of the entire database must be consistent, so no one-off changes or migrations per customer. Database partitioning is completely opaque from the application's perspective.