Search Postgresql Archives

Re: Multi tenancy : schema vs databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Via schemata if the tenants represent sub entities of the same organization.
This gives the top level mgmt the ability to have a consolidated view of the whole organization.

On 30/09/2016 12:06, Rakesh Kumar wrote:

________________________________________
From: Venkata B Nagothi <nag1010@xxxxxxxxx>
Sent: Friday, September 30, 2016 02:48
To: Rakesh Kumar
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re:  Multi tenancy : schema vs databases

On Fri, Sep 30, 2016 at 10:16 AM, Rakesh Kumar <rakeshkumar464@xxxxxxxxxxx<mailto:rakeshkumar464@xxxxxxxxxxx>> wrote:


________________________________________
From: Venkata B Nagothi <nag1010@xxxxxxxxx<mailto:nag1010@xxxxxxxxx>>
Sent: Thursday, September 29, 2016 17:25
To: Rakesh Kumar
Cc: pgsql-general@xxxxxxxxxxxxxx<mailto:pgsql-general@xxxxxxxxxxxxxx>
Subject: Re:  Multi tenancy : schema vs databases

On Fri, Sep 30, 2016 at 5:18 AM, Rakesh Kumar <rakeshkumar464@xxxxxxxxxxx<mailto:rakeshkumar464@xxxxxxxxxxx><mailto:rakeshkumar464@xxxxxxxxxxx<mailto:rakeshkumar464@xxxxxxxxxxx>>> wrote:

Hi

I would like to know which technique is better for supporting multi-tenancy=
  applications, going upto hundreds or even thousands of tenants.

1 - One database with difference schemas (one schema per tenant)
or
2 - One database per tenant.

Did you mean one database with-in a postgresql cluster ?

Yes.  Say something like this within a PG cluster

db4978
db6234
...
100s of such databases.

That would make things worst if you are going for one database per tenant. As said by John just now, it would end up in an very complex and bad design contributing to very poor performance and high maintenance overhead.
A schema per tenant would be a good idea and its hard to say without knowing the data isolation levels you require for each tenant.
========

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?






--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux