Re: Multi tenancy : schema vs databases

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Multi tenancy : schema vs databases
Дата
Msg-id 20160930175831.GU5148@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Multi tenancy : schema vs databases  (Jeff Janes <jeff.janes@gmail.com>)
Список 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

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Multi tenancy : schema vs databases
Следующее
От: Rakesh Kumar
Дата:
Сообщение: Re: Multi tenancy : schema vs databases