Link: Multi-Tenant Database Architecture

http://msdn.microsoft.com/en-us/library/aa479086.aspx

I get questions like this a lot from people starting out designing their SaaS app. It came up again tonight so I thought we’d make a new category on here for Useful Links and I’d post this one up.

It’s the best overview of the primary options for multi-tenant database layouts that I’ve seen.

2 Likes

Just a note, if you decide on going with a seperate schema approach and are a Rails developer you should take a look at the discourse architecture. They use postgres which allows you to do this:

https://github.com/discourse/discourse/tree/master/vendor/gems/rails_multisite