The limitation of one OFBiz implentation handling multiple tenants depends on:
- memory available for OFBiz on the machine hosting the implementation - settings regarding the pool-size of the used (underlying) RDBMS If you want to host a solution for dozens, 100s or 1000s of clients/customers you need to High Availabilit/FailOver aspects. Clustering on various levels comes to mind. Met vriendelijke groet, Pierre Smits *Proud* *contributor* (but unfortunately without privileges)* of* Apache OFBiz <https://ofbiz.apache.org/>, since 2008 *Apache Trafodion <https://trafodion.apache.org>, Vice President* *Apache Directory <https://directory.apache.org>, PMC Member* Apache Incubator <https://incubator.apache.org>, committer Apache Steve <https://steve.apache.org>, committer On Sun, Feb 23, 2020 at 9:10 AM Jacques Le Roux < [email protected]> wrote: > Le 22/02/2020 à 18:51, Alaa Murad a écrit : > > Thanks a lot for all replies, one important feature that we need is to > be able to run unlimited companies (with Chinese Walls between them) , do > we > > really need to have a new DB for each company ? > > According to > https://www.experts-exchange.com/articles/6539/Multi-tenant-Database-Shared-Database-Separate-Schema-in-SQL-Server.html > > There are mostly 3 ways to implement multitenant Separate Databases Shared > Database, Separate Schemas Shared Database, Shared Schema > > OFBiz uses the 1st. So with this way you will have as much as *tenant* DBs > as you introduce *tenants*. Pro and cons are explained in the document > above. > > > > how that will even work, one risk that caching (from JDBC driver, or > Ofbiz itself) maybe a problem , i.e. this is not PHP were each call is > 100% > > hitting the db, in Java we cache many stuff in JVM memory ! unless this > will result in a new ofbiz instance (in JVM) in this case running ofbiz as > > SaaS will be very expensive. > > > > > > Our POS system is a SaaS and we may have 100s or 1000s of > clients/companies and we don't want to spin a new ofbiz instance for each > one ! > > There should not be worries with caching. Because with "multitenant > Separate Databases" you run only one OFBiz instance with a DB per tenant > but, > thanks to the delegator concept, OFBiz knows what data belong to what > tenant. > > This said currently there is no mechanism to automatically create tenants > DBs on fly in OFBiz. So you would need to implement that. For 100s to 1000s > client it's at the limit of reasonable. I worked for a client who hoped > for much more (up to millions). Then OFBIz is hardly suitable and a > solution > based on OFBiz in this case demands a lot of code change. > > > > > I'm confused a bit about "2 tenants" and that we need to have 2 > databases for each ! > > I hope the article above helps. > > HTH > > Jacques > > > > > > > Thanks in advance ! > > > > > > On 2/20/20 2:09 PM, Jacques Le Roux wrote: > >> Hi, > >> > >> Inline completing Pierre's answer as much as possible > >> > >> Le 20/02/2020 à 08:37, Pierre Smits a écrit : > >>> On Thu, Feb 20, 2020 at 2:15 AM Alaa Murad <[email protected]> > wrote: > >>> 2. We are planning to use ofbiz for few different companies, they all > >>> 100% independent, can we have one ofbiz instance for all of them > ?how ? > >>> > >>> In this scenario I would advice to set up 2 tenants to ensure having > >>> Chinese Walls between the 2 companies. Each tenant would have its own > >>> database, and can have different plugins in play. > >> > >> BTW, you may have as most as tenants you need > >> > >> > >>> > >>>> 3. How easy to sync/push products, invoices , payments , etc. from > our > >>>> POS --> ofbiz (i.e. can we insert invoice via APIs) > >> > >> You may follow one of the suggested ways here: > https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data > >> > >> Be sure to compare with the other different possible ways documented in > the children pages of this page and pick the one (or several) which best > >> fit/s your needs. > >> > >> > >>> > >>>> 5. I do see Arabic support implemented to some degree, but is it > full > >>>> support, for example currency format, RTL (both web and PDF) > >> > >> RTL is supported in Web, I don't think it is in PDF. Currency is > supported in both. Since we are using NotoSans font by default you can use > a very > >> large set of characters in PDF. > >> > >> You may have a look at > https://demo-trunk.ofbiz.apache.org/example/control/fonts.pdf > >> > >>>> 6. Finally, how stable/active is ofbiz ? I see 30-40 emails per > month > >>>> only in the mailing list, this make me very worry ! > >> > >> OFBiz was born in 2001, became a Top Level Project (TLP) in Apache > Software Foundation (ASF) in 2006 and was mature around 2010. > >> > >> So yes it's pretty stable and safe (security). Since OFBiz is mature > the activity as decreased with a pick around 2016 as you can see here: > >> > >> https://ofbiz.markmail.org/ > >> > >> HTH > >> > >> Jacques > >> >
