Re: Multi tenancy : schema vs databases - Mailing list pgsql-general

From Stephen Frost
Subject Re: Multi tenancy : schema vs databases
Date
Msg-id 20160930175831.GU5148@tamriel.snowman.net
Whole thread Raw
In response to Re: Multi tenancy : schema vs databases  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
* Jeff Janes (jeff.janes@gmail.com) wrote:
> On Fri, Sep 30, 2016 at 2:06 AM, Rakesh Kumar <rakeshkumar464@outlook.com>
> wrote:
> > We require complete data isolation. Absolutely nothing should be shared
> > between two tenants.
>
> Then you need different clusters per tenant.  Otherwise, the WAL records of
> different tenants are inextricably mingled together.

Different clusters are also required to have independent file-level
backups, independent roles, independent tablespaces, etc.

It's also far easier to move a single cluster from one system to another
to adjust for growth than to try and move an individual schema or
database.

Thanks!

Stephen

Attachment

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Multi tenancy : schema vs databases
Next
From: Rakesh Kumar
Date:
Subject: Re: Multi tenancy : schema vs databases