>From a business perspective, if wanting to resell OFBiz hosting, wont the >perspective of maintaining individual DB's for each client quickly become a >mega-complex undertaking with accompanying high maintenance expences? I can >only imagine trying to maintain 1,000 DB's for a small client pool of 1,000 >clients wouldn't be the easiest thing to do, so I don't think the ecomics >supports the business model of large pool of individual DB tenants easily.
Just my humble thoughts..... CC -----Original Message----- From: Mike [mailto:[email protected]] Sent: Wednesday, February 26, 2014 2:12 PM To: user Subject: Re: OFBiz Multi-tenancy Shared Database and Shared Schema initially sounds great, until you realize what a pain it will be to do backups/restores of individual tenants. Eventually, a tenant will mess up it's data and will ask you to restore back to date/time. Now you are in a real pickle, unless each tenant has it's own DB and you have a solid point-in-time DB recovery process. Something to think about. On Wed, Feb 26, 2014 at 4:45 AM, Prashant Sankhla <[email protected]>wrote: > Hello OFBizers, > > I am evaluating a proposal for development of a SaaS application using > OFBiz framework. As I understood from wiki page< > https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support > > > for > every tenant a separate data instance is created. > The requirement for us is to be able to scale up to ten thousand > tenants and more. Typically each tenant will have 1 to 10 users. > > This gives me all indication that Shared Database and Shared Schema is > the way to go in our use case. > > My question to OFBiz experts is: > > 1. Is there any other better design to achieve the use case as stated > above? > 2. Is there any implementation or guideline available for such a use > case anywhere? > > > Best Regards > Prashant >
