{"id":1031,"date":"2014-07-21T12:53:01","date_gmt":"2014-07-21T07:23:01","guid":{"rendered":"http:\/\/www.allerin.com\/blog\/?p=1031"},"modified":"2016-05-12T14:50:23","modified_gmt":"2016-05-12T09:20:23","slug":"multi-tenancy-in-rails","status":"publish","type":"post","link":"https:\/\/www.allerin.com\/blog\/multi-tenancy-in-rails\/","title":{"rendered":"Multi-tenancy in Rails"},"content":{"rendered":"

What Multi-tenancy means? In simple definition it is a principle in software architecture where a single instance of the application serves multiple client organizations.<\/p>\n

Here client organizations are considered as a tenant. In\u00a0a multi-tenant architecture, application is designed virtually to partition its data and configuration so that each client organization works with a customized virtual application instance.<\/p>\n

Multi-tenant application mainly has three type of users.<\/p>\n

Admins:<\/span> These are the clients who own the site and have top-level access.<\/p>\n

Managers:<\/span> These are the resources from the company. They manage the projects and users at the company level.<\/p>\n

Users:<\/span> These are the end users of this application. Here each page will be accessible to users depending on their authorizations.<\/p>\n

Advantages of Multi-tenancy:<\/strong><\/p>\n

    \n
  1. Cost savings:<\/strong> Multi-tenancy allows for cost savings by considering resources and softwares used in the application. Cost and maintenance will increased when multiplied by many customers, especially if the customers are small. Multi-tenancy reduces this overhead by sharing same power resources and softwares. Software requires the licenses and support which will increases the cost if it needs to buy for every customer (single-tenancy). Shared infrastructure leads to lower costs.<\/li>\n
  2. Scalability:<\/strong> A multi-tenant architecture makes it easy to increase capacity when more strength & power is required. When adding new hardware to the platform, the total capacity of the entire system increases\u00a0and\u00a0becomes more scalable, not for just a single client but for all the associated clients. Adding the features for a single client makes it available to other clients.<\/li>\n
  3. Service:<\/strong> In multi-tenant application monitoring and administration will be required for one platform instead of managing different sets for each client. A multi-tenant SaaS provider can deliver more efficient and effective service and support, including troubleshooting and problem resolution.<\/li>\n
  4. Upgrades:<\/strong> Upgrading the softwares version or system resources for multi-tenant applications (like dbs, servers, h\/w resources etc.) are easy since there is a single, centralized place to go to make upgradation, installation etc.<\/li>\n<\/ol>\n

    Multi-tenancy in rails can be achieved with many architectures, some of them are listed below. Main feature in multi-tenancy should be there access privacy between all the resources(Admin, Manager and User.)<\/p>\n

    Using namespaces<\/strong><\/p>\n

    # Admin controller<\/span><\/p>\n

    class Admin::ProjectsController < ApplicationController\r\n  before_action :authenticate_admin_user! # for devise gem\r\n  def show\r\n    @project = Project.find(params[:id])\r\n  end\r\nend\r\n<\/pre>\n
     <\/p>\n
    # User controller<\/span><\/p>\n
    class ProjectsController < ApplicationController\r\n  before_action :authenticate_user!\r\n  def show\r\n    # here projects are associated with a user as many associations.\r\n    @project = current_user.projects.find(params[:id]) \r\n  end\r\nend\r\n<\/pre>\n
     <\/p>\n
    # Management controller<\/span><\/p>\n
    class Management::ProjectsController < ApplicationController\r\n  before_action :authenticate_company_user!\r\n  before_action :find_company\r\n  \r\n  def show\r\n   # here projects are associated with the company as many association \r\n   # or through:users and user belongs to the company.\r\n   @project = company.projects.find(params[:id])\r\n  end\r\n\r\nprivate\r\n  # can be moved to more appropriate place\r\n  def find_company\r\n    @company = company_user.company\r\n  end\r\nend\r\n<\/pre>\n
    Using default_scope<\/strong> (Ryan Bates Multi-tenancy with Scopes)<\/em><\/p>\n
    Consider below schema:<\/span><\/p>\n
    class Company < ActiveRecord::Base\r\n  attr_accessible :name\r\n  cattr_accessor :current_id\r\nend\r\n\r\nclass ApplicationController\r\n  around_action :scope_current_company\r\n  private\r\n  def scope_current_company\r\n    Company.current_id = current_tenant.id\r\n    yield\r\n    ensure\r\n    Company.current_id = nil\r\n  end\r\nend\r\n\r\nclass User < ActiveRecord::Base\r\n  default_scope { where (:company_id => Company.current_id) }\r\nend\r\n<\/pre>\n
     <\/p>\n
    Above approach might not be feasible as it is extensively depends on class variable and if we not able to manage class variables as per thread.<\/p>\n
    Above can be achieved by using gem act_as_tenant<\/strong> https:\/\/github.com\/ErwinM\/acts_as_tenant<\/a><\/p>\n
    Separate Database<\/strong> (Apartments Method<\/em>)<\/p>\n
    In\u00a0gem apartment https:\/\/github.com\/influitive\/apartment<\/a>, we can use separate databases for each company. This makes system more secure by considering data will not be sharable to other company.<\/p>\n
    Shared Database, Shared Schema<\/strong> (Using scopes and Model partitioning<\/em>)<\/p>\n
    Sometimes we require that data of two companies can be shared within their users. We can achieve multi-tenancy by using scopes.<\/p>\n
    Consider below schema:<\/span><\/p>\n
    User |id|name|email|…|tenant_id|<\/p>\n
    Project |id|name|…|tenant_id|<\/p>\n
    The shared schema approach has the lowest hardware and backup costs, because it allows you to serve the largest number of tenants per database server. However, because multiple tenants share the same database tables, and this approach may require additional development effort in the area of security, to ensure that tenants can never access other tenant’s data, even in the event of unexpected bugs or attacks.<\/p>\n
    Advantage of the above approach is –<\/span><\/p>\n