Hacker News new | ask | show | jobs
by agacera 1468 days 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/appl...

2 comments

Yes, 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.

How do you handle upgrades for single tenant databases?
We shut down the old compute and start a new one with a new version (after loads of testing and making sure it'll work).