topic Re: It's possible to create a separate schema/database for each tenant? in Alfresco Forum

It's possible to create a separate schema/database for each tenant?

calin_chiper — Wed, 09 May 2018 07:57:42 GMT

I want to create a separate db/schema using the TenantAdminService. In the Alfresco SDK I've created a tenant using a four argument method createMethod executed as a init method:this.tenantAdminService.createTenant( "aaa.com", // username "aaa.com".toCharArray(), // password "D:

Re: It's possible to create a separate schema/database for each tenant?

afaust — Wed, 09 May 2018 08:15:27 GMT

The interface TenantAdminService contains the comment

    // experimental (unsupported)
    public void createTenant(String tenantDomain, char[] adminRawPassword, String contentRoot, String dbUrl);‍‍

It is unfortunate that this experimental API has been exposed in a public release. Within the implementation it is stated that the operation expects the schema to be already bootstrapped in the referenced dabase - it will not bootstrap the tables itself. Also, even if the DB were bootstrapped, it would not be used at runtime since the active JDBC data source is not using the DB URL stored for the tenant when creating the actual DB connections.

Re: It's possible to create a separate schema/database for each tenant?

calin_chiper — Wed, 09 May 2018 08:54:57 GMT

So actually it doesn't do anything special. It just reference a db and that's all?

Re: It's possible to create a separate schema/database for each tenant?

afaust — Wed, 09 May 2018 10:06:35 GMT

At the moment, yes. And I don't know of any plans to change that, given how multi-tenancy will likely be removed from the core of the product in an upcoming version.