Re: Multi Tenancy / SaaS

I've got the same issue on a project I'm working on.  Any solutions you came up with Dylan?

On Monday, August 6, 2012 4:02:15 PM UTC-6, Dylan Jennings wrote:

Hello

I'm currently building a SaaS application using cakePHP. I've worked with cakePHP before a few times and I'm comfortable with how it all works.

So, I have an `accounts` table which holds information about each tenant, and then a `users` table aswell, which will contain the users for each account/tenant. New users will initially be added through a basic plain PHP or WordPress front-end, so there won't be the need to create new `accounts` through the cakePHP side of the app.

Just to be clear, each tenant will be on a subdomain of the main domain. For example, http://dylan.mycakeapp.dev/ could be a tenant. The front-end site will be held in the root of the site, http://mycakeapp.dev/. When new users sign up on the front-end site, their `accounts` record and a single `users` record will be created, they will get redirected to their subdomain, and the cakePHP app will take it from there.

So here's the problem. I want all tenants to share the same database, separated by an 'account_id' which will be in all tables. I'm not 100% on this, but I think the correct approach is to use the 'beforeSave', 'beforeDelete' and 'beforeFind' callbacks in the model, and simply add the `account_id` as a query condition. The problem comes when I'm trying to detect which tenant to use, because I can't use the database within the model.

Does anyone have any experience with SaaS/multi-tenancy apps in cakePHP, and can help? Thanks in advance.

Cheers

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.