Multi-Tenant with MySQL or Postgress - Working?

[FGomez]

Hi All,

I wanted to know if anyone has Multi-tenant running in production (or
dev) with more then 3 tenants/clients with PostgreSql or mySql DBs?
With v13.07 or v14.12 ( I believe the domain on the script is only
available with the 'ant create-tenant' on v14.12 only).

Thanks you for the feedback.

Regards,
Fernando

[Arun Patidar-2]

Hi Fernando,

Multi-tenant functionality supports all DBs like Postgres, Mysql and
Derby. Also 'domain-name' with create-tenant target introduced in v14.12.


Thanks & Regards
---
Arun Patidar
Manager,Enterprise Software Development
HotWax Media
www.hotwaxsystems.com

On Thursday 21 May 2015 08:04 AM, FGomez wrote:

> Hi All,
>
> I wanted to know if anyone has Multi-tenant running in production (or
> dev) with more then 3 tenants/clients with PostgreSql or mySql DBs?
> With v13.07 or v14.12 ( I believe the domain on the script is only
> available with the 'ant create-tenant' on v14.12 only).
>
> Thanks you for the feedback.
>
> Regards,
> Fernando
>
>
>

[Pierre Smits]

Hi Fernando.

Multi-tenancy has been around since prior r12.x. And is working with both
PostgreSQL and MySQL.

Best regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com

On Thu, May 21, 2015 at 4:34 AM, FGomez <[hidden email]> wrote:

> Hi All,
>
> I wanted to know if anyone has Multi-tenant running in production (or dev)
> with more then 3 tenants/clients with PostgreSql or mySql DBs?
> With v13.07 or v14.12 ( I believe the domain on the script is only
> available with the 'ant create-tenant' on v14.12 only).
>
> Thanks you for the feedback.
>
> Regards,
> Fernando
>
>
>
>

[Jacques Le Roux]

More accurately multi-tenancy has been introduced in trunk in February 2010 and has been continuously improved since.
It works with all the DBMSs you can fiund in the EntityEngine.xml file.
The number of tenants depends on the material resources, not the code.
It's not a solution to scale above thousands tough (you need a DB by tenant...)
This limitation comes with the obvious advantages of having separated DBs. You can find details about these advantages on the Net, notably when it comes to backups things and guarantee access separation...

Jacques


Le 21/05/2015 07:59, Pierre Smits a écrit :

> Hi Fernando.
>
> Multi-tenancy has been around since prior r12.x. And is working with both
> PostgreSQL and MySQL.
>
> Best regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
> On Thu, May 21, 2015 at 4:34 AM, FGomez <[hidden email]> wrote:
>
>> Hi All,
>>
>> I wanted to know if anyone has Multi-tenant running in production (or dev)
>> with more then 3 tenants/clients with PostgreSql or mySql DBs?
>> With v13.07 or v14.12 ( I believe the domain on the script is only
>> available with the 'ant create-tenant' on v14.12 only).
>>
>> Thanks you for the feedback.
>>
>> Regards,
>> Fernando
>>
>>
>>
>>

[FGomez]

Jacques, Pierre and Arum

Thanks for the technical answer.

I agreed with the advantages of a DB per Tenant and the scalability of
the HW infrastructure underneath . Hence the maintenance and support
issues.
I test with v14.12 and advise.

Regards,
Fernando




Le 2015-05-21 03:09, Jacques Le Roux a écrit :

> More accurately multi-tenancy has been introduced in trunk in February
> 2010 and has been continuously improved since.
> It works with all the DBMSs you can fiund in the EntityEngine.xml file.
> The number of tenants depends on the material resources, not the code.
> It's not a solution to scale above thousands tough (you need a DB by
> tenant...)
> This limitation comes with the obvious advantages of having separated
> DBs. You can find details about these advantages on the Net, notably
> when it comes to backups things and guarantee access separation...
>
> Jacques
>
>
> Le 21/05/2015 07:59, Pierre Smits a écrit :
>> Hi Fernando.
>>
>> Multi-tenancy has been around since prior r12.x. And is working with
>> both
>> PostgreSQL and MySQL.
>>
>> Best regards,
>>
>> Pierre Smits
>>
>> *ORRTIZ.COM <http://www.orrtiz.com>*
>> Services & Solutions for Cloud-
>> Based Manufacturing, Professional
>> Services and Retail & Trade
>> http://www.orrtiz.com
>>
>> On Thu, May 21, 2015 at 4:34 AM, FGomez <[hidden email]> wrote:
>>
>>> Hi All,
>>>
>>> I wanted to know if anyone has Multi-tenant running in production
>>> (or dev)
>>> with more then 3 tenants/clients with PostgreSql or mySql DBs?
>>> With v13.07 or v14.12 ( I believe the domain on the script is only
>>> available with the 'ant create-tenant' on v14.12 only).
>>>
>>> Thanks you for the feedback.
>>>
>>> Regards,
>>> Fernando
>>>
>>>
>>>
>>>

[Todd Thorner]

Thanks, Fernando, I look forward to overcoming a bit more of my
ignorance by way of e-following your progress.



On 15-05-21 08:20 AM, FGomez wrote:

> Jacques, Pierre and Arum
>
> Thanks for the technical answer.
>
> I agreed with the advantages of a DB per Tenant and the scalability of
> the HW infrastructure underneath . Hence the maintenance and support
> issues.
> I test with v14.12 and advise.
>
> Regards,
> Fernando
>
>
>
>
> Le 2015-05-21 03:09, Jacques Le Roux a écrit :
>> More accurately multi-tenancy has been introduced in trunk in February
>> 2010 and has been continuously improved since.
>> It works with all the DBMSs you can fiund in the EntityEngine.xml file.
>> The number of tenants depends on the material resources, not the code.
>> It's not a solution to scale above thousands tough (you need a DB by
>> tenant...)
>> This limitation comes with the obvious advantages of having separated
>> DBs. You can find details about these advantages on the Net, notably
>> when it comes to backups things and guarantee access separation...
>>
>> Jacques
>>
>>
>> Le 21/05/2015 07:59, Pierre Smits a écrit :
>>> Hi Fernando.
>>>
>>> Multi-tenancy has been around since prior r12.x. And is working with
>>> both
>>> PostgreSQL and MySQL.
>>>
>>> Best regards,
>>>
>>> Pierre Smits
>>>
>>> *ORRTIZ.COM <http://www.orrtiz.com>*
>>> Services & Solutions for Cloud-
>>> Based Manufacturing, Professional
>>> Services and Retail & Trade
>>> http://www.orrtiz.com
>>>
>>> On Thu, May 21, 2015 at 4:34 AM, FGomez <[hidden email]> wrote:
>>>
>>>> Hi All,
>>>>
>>>> I wanted to know if anyone has Multi-tenant running in production
>>>> (or dev)
>>>> with more then 3 tenants/clients with PostgreSql or mySql DBs?
>>>> With v13.07 or v14.12 ( I believe the domain on the script is only
>>>> available with the 'ant create-tenant' on v14.12 only).
>>>>
>>>> Thanks you for the feedback.
>>>>
>>>> Regards,
>>>> Fernando
>>>>
>>>>
>>>>
>>>>
>

[FGomez]

Hi all

Not able to  make multitenant working on postgres (nor on mysql). There
are several errors and The script 'create-tenant' hangs at the following
line:

[java] 2015-05-23 23:05:55,222 |main |ContainerLoader               |I|
Starting container dataload-container
[java] 2015-05-23 23:05:55,254 |delegator-startup-1
|DelegatorFactoryImpl          |I| Creating new delegator
[default#Tenant1] (delegator-startup-1)


I have followed these guidances  (now that a script is available to
create Tenants).

https://cwiki.apache.org/confluence/display/OFBIZ/Extension+in+Multitenancy+support

ENV
os=windows 12 R2
ofbiz release from svn co ofbiz.14.02....


Thanks for your feedback.


Regards,
Fernando




Le 2015-05-21 11:20, FGomez a écrit :

> Jacques, Pierre and Arum
>
> Thanks for the technical answer.
>
> I agreed with the advantages of a DB per Tenant and the scalability of
> the HW infrastructure underneath . Hence the maintenance and support
> issues.
> I test with v14.12 and advise.
>
> Regards,
> Fernando
>
>
>
>
> Le 2015-05-21 03:09, Jacques Le Roux a écrit :
>> More accurately multi-tenancy has been introduced in trunk in
>> February 2010 and has been continuously improved since.
>> It works with all the DBMSs you can fiund in the EntityEngine.xml file.
>> The number of tenants depends on the material resources, not the code.
>> It's not a solution to scale above thousands tough (you need a DB by
>> tenant...)
>> This limitation comes with the obvious advantages of having separated
>> DBs. You can find details about these advantages on the Net, notably
>> when it comes to backups things and guarantee access separation...
>>
>> Jacques
>>
>>
>> Le 21/05/2015 07:59, Pierre Smits a écrit :
>>> Hi Fernando.
>>>
>>> Multi-tenancy has been around since prior r12.x. And is working with
>>> both
>>> PostgreSQL and MySQL.
>>>
>>> Best regards,
>>>
>>> Pierre Smits
>>>
>>> *ORRTIZ.COM <http://www.orrtiz.com>*
>>> Services & Solutions for Cloud-
>>> Based Manufacturing, Professional
>>> Services and Retail & Trade
>>> http://www.orrtiz.com
>>>
>>> On Thu, May 21, 2015 at 4:34 AM, FGomez <[hidden email]> wrote:
>>>
>>>> Hi All,
>>>>
>>>> I wanted to know if anyone has Multi-tenant running in production
>>>> (or dev)
>>>> with more then 3 tenants/clients with PostgreSql or mySql DBs?
>>>> With v13.07 or v14.12 ( I believe the domain on the script is only
>>>> available with the 'ant create-tenant' on v14.12 only).
>>>>
>>>> Thanks you for the feedback.
>>>>
>>>> Regards,
>>>> Fernando
>>>>
>>>>
>>>>
>>>>
>

[Arun Patidar-2]

Hi Fernando,

In your attached log file, there is an error as :

/org.ofbiz.base.config.GenericConfigException: File Resource not found:
E:/DEV/ofbiz.14.12/framework/entity/fieldtype/fieldtypepostnew.xml/

Use postgres settings instead of postnew in entityengine since postnew
does not support in 14.12 release. It should be 'fieldtypepostgres.xml'
file location in entityengine.

I just created a new tenant using Mysql on OFBiz trunk and it worked
fine for me.


Thanks & Regards
---
Arun Patidar
Manager,Enterprise Software Development
HotWax Media
www.hotwaxsystems.com

On Sunday 24 May 2015 12:05 PM, FGomez wrote:

> Hi all
>
> Not able to  make multitenant working on postgres (nor on mysql).
> There are several errors and The script 'create-tenant' hangs at the
> following line:
>
> [java] 2015-05-23 23:05:55,222 |main |ContainerLoader              
> |I| Starting container dataload-container
> [java] 2015-05-23 23:05:55,254 |delegator-startup-1
> |DelegatorFactoryImpl          |I| Creating new delegator
> [default#Tenant1] (delegator-startup-1)
>
>
> I have followed these guidances  (now that a script is available to
> create Tenants).
>
> https://cwiki.apache.org/confluence/display/OFBIZ/Extension+in+Multitenancy+support 
>
>
> ENV
> os=windows 12 R2
> ofbiz release from svn co ofbiz.14.02....
>
>
> Thanks for your feedback.
>
>
> Regards,
> Fernando
>
>
>
>
> Le 2015-05-21 11:20, FGomez a écrit :
>> Jacques, Pierre and Arum
>>
>> Thanks for the technical answer.
>>
>> I agreed with the advantages of a DB per Tenant and the scalability
>> of the HW infrastructure underneath . Hence the maintenance and
>> support issues.
>> I test with v14.12 and advise.
>>
>> Regards,
>> Fernando
>>
>>
>>
>>
>> Le 2015-05-21 03:09, Jacques Le Roux a écrit :
>>> More accurately multi-tenancy has been introduced in trunk in
>>> February 2010 and has been continuously improved since.
>>> It works with all the DBMSs you can fiund in the EntityEngine.xml file.
>>> The number of tenants depends on the material resources, not the code.
>>> It's not a solution to scale above thousands tough (you need a DB by
>>> tenant...)
>>> This limitation comes with the obvious advantages of having
>>> separated DBs. You can find details about these advantages on the
>>> Net, notably when it comes to backups things and guarantee access
>>> separation...
>>>
>>> Jacques
>>>
>>>
>>> Le 21/05/2015 07:59, Pierre Smits a écrit :
>>>> Hi Fernando.
>>>>
>>>> Multi-tenancy has been around since prior r12.x. And is working
>>>> with both
>>>> PostgreSQL and MySQL.
>>>>
>>>> Best regards,
>>>>
>>>> Pierre Smits
>>>>
>>>> *ORRTIZ.COM <http://www.orrtiz.com>*
>>>> Services & Solutions for Cloud-
>>>> Based Manufacturing, Professional
>>>> Services and Retail & Trade
>>>> http://www.orrtiz.com
>>>>
>>>> On Thu, May 21, 2015 at 4:34 AM, FGomez <[hidden email]> wrote:
>>>>
>>>>> Hi All,
>>>>>
>>>>> I wanted to know if anyone has Multi-tenant running in production
>>>>> (or dev)
>>>>> with more then 3 tenants/clients with PostgreSql or mySql DBs?
>>>>> With v13.07 or v14.12 ( I believe the domain on the script is only
>>>>> available with the 'ant create-tenant' on v14.12 only).
>>>>>
>>>>> Thanks you for the feedback.
>>>>>
>>>>> Regards,
>>>>> Fernando
>>>>>
>>>>>
>>>>>
>>>>>
>>
>