You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Pierre Smits <pi...@gmail.com> on 2015/05/21 07:59:23 UTC
Re: Multi-Tenant with MySQL or Postgress - Working?
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 <fg...@mail.com> 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
>
>
>
>
Re: Multi-Tenant with MySQL or Postgress - Working?
Posted by Arun Patidar <ar...@hotwaxsystems.com>.
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 <fg...@mail.com> 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
>>>>>
>>>>>
>>>>>
>>>>>
>>
>
Re: Multi-Tenant with MySQL or Postgress - Working?
Posted by FGomez <fg...@mail.com>.
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 <fg...@mail.com> 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
>>>>
>>>>
>>>>
>>>>
>
Re: Multi-Tenant with MySQL or Postgress - Working?
Posted by Todd Thorner <tt...@infotinuum.com>.
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 <fg...@mail.com> 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
>>>>
>>>>
>>>>
>>>>
>
Re: Multi-Tenant with MySQL or Postgress - Working?
Posted by FGomez <fg...@mail.com>.
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 <fg...@mail.com> 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
>>>
>>>
>>>
>>>
Re: Multi-Tenant with MySQL or Postgress - Working?
Posted by Jacques Le Roux <ja...@les7arts.com>.
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 <fg...@mail.com> 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
>>
>>
>>
>>