our clients in one OFBiz instance Multi-Tenancy

Multi-tenancy support and how to use it

Introduction

Multi-tenancy has been introduced in OFBiz at rev 927271. Multi-tenancy is the ability to run separate data instances (tenants) from a single copy of OFBiz. Each data instance is kept in a separate database. A user logs into a data instance (or tenant) by specifying the tenant ID in the login form. Note that a default database is still used.

Tenant Databases

The datasources (= database references) are defined in the TenantDataSouces Entity not in the entityengine.xml (description below).

DBMS which does not support the “;create=true” syntax used OOTB with Derby (eg Postgres, MySql, etc.) we need to create the tenant(s) DB(s) and credentials before running the tenant(s) data installation.

Displaying the tenant Id field for connection

in framework/common/config/general.properties, change the multitenant option to Y
This will show the TenantID for login.

download general.properties file

Configuring for Multi-Tenant

The configuration files that need to be touched are the following:

• OFBIZ-HOME/framework/entity/data/TenantDemoData.xml

download TenantDemoData.xml file

TenantDemoData.xml

Per Tenant add the following: “the following code creates 3 tenants CUSTOMER1, and CUSTOMER2”

<!– CUSTOMER1 tenant configuration –>

<Tenant tenantId=”CUSTOMER1″ tenantName=”CUSTOMER1″/>

<TenantDataSource

tenantId=”CUSTOMER1″

entityGroupName=”org.ofbiz”

jdbcUri=”jdbc:postgresql://127.0.0.1/customer1_db”

jdbcUsername=”postgres”

jdbcPassword=”root” />

<TenantDataSource tenantId=”CUSTOMER1″

entityGroupName=”org.ofbiz.olap”

jdbcUri=”jdbc:postgresql://127.0.0.1/ofbizolap_customer1″

jdbcUsername=”postgres”

jdbcPassword=”root” />

<!– end of CUSTOMER1 tenant configuration –>

<!– CUSTOMER2 tenant configuration –>

<Tenant tenantId=”CUSTOMER2″ tenantName=”CUSTOMER2″/>

<TenantDataSource

tenantId=”CUSTOMER2″

entityGroupName=”org.ofbiz”

jdbcUri=”jdbc:postgresql://127.0.0.1/customer2_db”

jdbcUsername=”postgres”

jdbcPassword=”root” />

<TenantDataSource tenantId=”CUSTOMER2″

entityGroupName=”org.ofbiz.olap”

jdbcUri=”jdbc:postgresql://127.0.0.1/ofbizolap_customer2″

jdbcUsername=”postgres”

jdbcPassword=”root” />

<!– end of CUSTOMER2 tenant configuration –>

and so on for every tenant.

Loading Tenant.

To set up the databases for multi-tenancy and load the seed data only, do the following:

$ ant load-demo

$ java \-Xmx512m \-XX:MaxPermSize=128m \-jar ofbiz.jar \-install \-readers=seed \-delegator=default

$ java -Xmx512m -XX:MaxPermSize=128m -jar ofbiz.jar -install -readers=seed -delegator=default#CUSTOMER1

$ java -Xmx512m -XX:MaxPermSize=128m -jar ofbiz.jar -install -readers=seed -delegator=default#CUSTOMER2

Then load a demo product store for each tenant by the following:

$ java -Xmx512m -XX:MaxPermSize=128m -jar ofbiz.jar -install -readers=seed,demo -delegator=default#CUSTOMER1

$ java -Xmx512m -XX:MaxPermSize=128m -jar ofbiz.jar -install -readers=seed,demo -delegator=default#CUSTOMER2

and then, start OFBiz

$ java -Xmx1024M -jar ofbiz.jar

Test

success

//