topic Re: How to separate database for each tenant in Alfresco in Alfresco Forum

How to separate database for each tenant in Alfresco

miroslav — Wed, 05 May 2021 12:19:42 GMT

It is possible to separate database schema / database for each tenant? (legislative requirements)

Re: How to separate database for each tenant in Alfresco

EddieMay — Fri, 07 May 2021 08:39:24 GMT

Hi @miroslav

Have you read the docs re: enterprise & multi tenant support?

Re: How to separate database for each tenant in Alfresco

miroslav — Fri, 14 May 2021 11:23:23 GMT

Thank you for the answer, I read the documentation, but I didnt find any mention of separate databases for individual tenants. In alfresco database, there is parameter "db_url" in "alf_table" (its null for each tenant). I was hoping that it possible to separate metadata.

At the moment, everything is under one database and tables are just logically partitioned. It does not meet the legislative requirements in our country for record management functionality. I will try to separate mentioned partitions using PG 13.

Re: How to separate database for each tenant in Alfresco

afaust — Fri, 14 May 2021 14:34:34 GMT

There is no support for multiple / separate databases in Alfresco multi-tenancy. The db_url parameter was added way back in anticipation of a separate database being eventually supported, but it never came to that.

Re: How to separate database for each tenant in Alfresco

miroslav — Sat, 15 May 2021 09:26:36 GMT

Thank you.