March 18, 2019 at 8:05 am
If I want to provide data to separate customers i.e. keep it secure and isolated for each party what would be the best way to do this with SQL DB?
March 18, 2019 at 8:10 am
You are looking at a multi tenant architecture. This does not a cloud specific architecture but can sit on the cloud nicely. There is no one size fits all, but basically you would be looking at having one database per customer or group of customers, as well dedicated application components to serve this database.
Here is a link that may help put you in the right direction:
https://docs.microsoft.com/en-us/azure/sql-database/saas-tenancy-app-design-patterns
March 18, 2019 at 10:03 am
For the purpose of security, transactional isolation, and even just logical simplicity; I agree that you should consider one Azure SQL database per tenant, especially if you serve and international client base. If the databases are contained in the same resource group (this is advised), the databases can share an elastic DTU pool.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool
Another benefit of the one database per tenant model is that, if a tenant has a special legal requirement or corporate policy regarding where their data is physically hosted, then you can simply move their database to another region. However, a single DTU pool cannot span regions, so this will require at least one pool for each region.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy