3 ms·
Depending on the cost per database, a service like this could allow one to build SAAS apps with Single Tenant model [1] in a really simple and elegant way. I a
by agacera 4y ago
Depending on the cost per database, a service like this could allow one to build SAAS apps with Single Tenant model [1] in a really simple and elegant way.
I always liked this model since it gives the best isolation and not having to code with multi-tenant in mind really simplifies development and security. But maintaing an infra for this is hard and costly.
[1] https://docs.microsoft.com/en-us/azure/architecture/isv/application-tenancy#single-tenant https://docs.microsoft.com/en-us/azure/architecture/isv/appl...
- nikita 4y agoYes, SQL Azure has customers with 10K+ tenants. I's anecdotal, but I'm pretty sure since I used to work at SQL Server! This makes it super easy.
- RedShift1 4y agoHow do you handle upgrades for single tenant databases?
- nikita 4y agoWe shut down the old compute and start a new one with a new version (after loads of testing and making sure it'll work).