Re: Multi tenancy : schema vs databases

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: Multi tenancy : schema vs databases
Дата
Msg-id CALd+dcei0CseoUpX-jZLvCeKnYOiKkXyOG-E-85j_0NF4-1caQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Multi tenancy : schema vs databases  (John R Pierce <pierce@hogranch.com>)
Ответы Re: Multi tenancy : schema vs databases  (Colin Morelli <colin.morelli@gmail.com>)
Список pgsql-general
On Fri, Sep 30, 2016 at 5:11 AM, John R Pierce <pierce@hogranch.com> wrote:
> On 9/30/2016 2:06 AM, Rakesh Kumar wrote:
>>
>> We require complete data isolation. Absolutely nothing should be shared
>> between two tenants.
>>
>> WHy would multiple dbs be any worse than multiple schemas in performance?
>
>
> complete?  use 1000s of seperate VM instances, one per tennant.
>

Well, VM's don't always provide 100% isolation, so separate hardware,
with each on its own VLAN seems right to me. And then make sure your
switch doesn't leak across VLANs.

Your requirements need refinement, at the least :)


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

Предыдущее
От: Igor Neyman
Дата:
Сообщение: Re: executing os commands from a function
Следующее
От: Vick Khera
Дата:
Сообщение: Re: Multi tenancy : schema vs databases