topic Multi-tenant - Database/Schema in Alfresco Archive

Multi-tenant - Database/Schema

palashg — Thu, 03 Jun 2010 13:38:26 GMT

Hi,In Alfresco muli-tenant environment, content gets stored in its respective tenant specific file store. "But the meta-data is logically partitioned within the DB schema". Any multi-tenant cloud implementation generally follows one of the following data architecture :1) Separate database(s) - each

Re: Multi-tenant - Database/Schema

palashg — Tue, 08 Jun 2010 09:24:22 GMT

Can anybody pl respond to this from Alfresco developer community?

Re: Multi-tenant - Database/Schema

mrogers — Tue, 08 Jun 2010 16:16:50 GMT

No. There's ony one shema for multi-tennant.

Re: Multi-tenant - Database/Schema

palashg — Thu, 10 Jun 2010 08:08:44 GMT

Thanks for confirming this. But I see this might be challange for some customers who are very sensitive about their data and backup/restore process. If this is the case, we loose the flexibility of taking backup/doing restore specific to tenant. Some customers may not like this. Please let me know if I am wrong.

Re: Multi-tenant - Database/Schema

mrogers — Thu, 10 Jun 2010 08:23:57 GMT

In that case run multiple instances of Alfresco.

Re: Multi-tenant - Database/Schema

fcajve — Tue, 28 Feb 2012 10:03:48 GMT

hi,
is this limitation obsolete in alfresco 4 : is it now possible to run one instance of alfresco with multiple separate databases ?
regards,

Re: Multi-tenant - Database/Schema

mrogers — Tue, 28 Feb 2012 13:00:37 GMT

No its not obsolete.

Re: Multi-tenant - Database/Schema

lista — Fri, 08 Feb 2013 12:20:32 GMT

I don't have any experience hands on, so I'm just researching a bit, and found this piece of information on forum. I'm wondering if there's any truth to it, or am I misunderstanding something?

"Alfresco: How to point Alfresco to new database and different binaries path? Simple, you must change the /conf/Catalina/tenant1.mycompany.com/alfresco.xml file created after the first deploy of your new server. This file accepts properties like "datase.url", "root.dir", "email.server", etc."

Re: Multi-tenant - Database/Schema

jpfi — Fri, 08 Feb 2013 13:25:55 GMT

Hi,
if you use multi tenancy:
X Tenants = 1 Alfresco repository = 1 DB scheme = 1 to X ContentStores

If you need to ensure that data of different tenants is stored in different DB schemes, then you'll need to use different Alfresco Repositories.
Cheers, Jan