4 ms·
Understood. Currently, I manage several hundred logical databases for a B2B SaaS product. This has the potential to grow to several thousand over the course of
by leesalminen 11y ago
Understood.
Currently, I manage several hundred logical databases for a B2B SaaS product. This has the potential to grow to several thousand over the course of years.
My customers enjoy that (arbitrary) piece of mind that their data is logically separated from all else. I enjoy not having to remember to include a tenant_id clause.
Our traffic pattern is quite steady per hour of day and per customer. That, plus using RDS for horizontal scaling (fixed # of logical DBs per host) allowed us to take this route.
I suppose the decision is a matter of circumstance and preference, but I don't think this is necessarily "wrong" to do.
- beachstartup 11y agoit's going to work fine until it doesn't. that's not going to be a good day. smart people can rationalize anything.