I'm not aware of xwiki internals, but if data accessed purely via hibernate, do you think that one could create deployment-specific mappings with lets say prefixed table names? I.e. for 30 departments one may have 30 xwiki deployments. All instances connect to the same db. One instance => one prefix => one set of mappings => one set of tables. Could it possibly work? -----Original Message----- From: Ludovic Dubost [mailto:[email protected]] Sent: Tuesday, April 10, 2007 7:17 PM To: [email protected] Subject: Re: [xwiki-users] Multiple xwiki Hi, Solution 2 is difficult to implement and might have some issues.. You could imagine modifying the table names to include the name of the wiki. Howerve this is complex because table names are handled by hibernate so you would need to intercept table names in hibernate. Second you could end up with way to many tables in the database and hit some table number limits in the schema Ludovic Igor Regis a йcrit :
Thanks to organize my questions Sergiu Dumitriu!
I want to do the item 2. We have considered the item 3, but as I have mentioned before our DBA team probably will not let us to do this - don't ask me why :-). So the question remains: Is it possible to setup really different wiki's on the same database (server and "tables")?
--- Sergiu Dumitriu <[email protected]> escreveu:
So, you want:
1. Make the same content available using one database, but more servlet containers 2. Put different wikis inside the same internal database (one mysql/oracle/postrges... instance, one database=collection of tables) 3. Put different wikis inside the same instance of sql server, but using different internal databases (one mysql/oracle/postgres... instance, but more databases=collections of tables)
I'd recommend 3, as it puts less stress on the database (joins take much less).
1 is easy to accomplish too, but 2 will require some changes in the core.
On 4/10/07, Igor Regis <[email protected]> wrote:
Hi Vincent,
The idea is to create a xwiki instance for each corporation department; because it is a huge corporation with more than 80.000 employees and
about
30 departments (each one have a specific set of hierarchy, rules and autonomy), and each wiki may
have
thousands pages. The problem is to set up these xwiki instances accessing a unique centralized mainframe database
mgr;
since in unlikely that our DBA team will let us to create one database (table space,...) for each
xwiki
instance. We have discussed about creating a space per department, but my boos asked me to find a way to setup these multiple instances. But if it's impossible... :-)
If you need more info about the requirements, I
can
provide.
Regards, Igor Regis
-- You receive this message as a subscriber of the [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
__________________________________________________ Fale com seus amigos de graзa com o novo Yahoo! Messenger http://br.messenger.yahoo.com/
---------------------------------------------------------------------- --
-- You receive this message as a subscriber of the [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
-- Ludovic Dubost Blog: http://www.ludovic.org/blog/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost AIM: nvludo Yahoo: ludovic