SaaS Multi Tenant MySQL Database Architecture

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
buckit
Forum Contributor
Posts: 169
Joined: Fri Jan 01, 2010 10:21 am

SaaS Multi Tenant MySQL Database Architecture

Post by buckit »

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.
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: SaaS Multi Tenant MySQL Database Architecture

Post by califdon »

What kind of threats are you trying to protect against?
buckit
Forum Contributor
Posts: 169
Joined: Fri Jan 01, 2010 10:21 am

Re: SaaS Multi Tenant MySQL Database Architecture

Post by buckit »

Crossed data is the primary.

We keep our servers EXTREMELY secure but also to stop a single database of all critical data... in addition to the DB architecture the critical parts of the data will be encrypted.
Post Reply