SaaS Multi Tenant MySQL Database Architecture
Posted: Mon Feb 07, 2011 8:24 pm
Web application that contains highly sensitive data. as a whole the data becomes more and more sensitive with the increase of tenants.
hardware is not an issue, I personal colo space with high end servers for me to do what I want with.
Separate databases for each tenant or separate tables in a single database?
I dont think a shared schema will work, even if I use views to ensure "tenant_id" relationship as not to show cross data.
I have read about 20 different articles and thought through every possibility. I just cant decide which direction to go. either way will be a versioning nightmare.
hardware is not an issue, I personal colo space with high end servers for me to do what I want with.
Separate databases for each tenant or separate tables in a single database?
I dont think a shared schema will work, even if I use views to ensure "tenant_id" relationship as not to show cross data.
I have read about 20 different articles and thought through every possibility. I just cant decide which direction to go. either way will be a versioning nightmare.