[xwiki-users] Multiple xwiki

[Ludovic Dubost]

Hi,

One solution is to create 30 hibernate SessionFactory and use the right 
one before each query. As far as I remember it is possible to have these 
SessionFactory objects share the same JDBC connection. Creating the 
SessionFactory with the correct table names will need to modify the hbm 
file on the fly before creating the SessionFactory object.

What's sure is that this does not scale to hundreds of virtual wikis but 
it could work under 100.

Ludovic

Pavel a e'crit :
> 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:ludovic at xwiki.com] 
> Sent: Tuesday, April 10, 2007 7:17 PM
> To: xwiki-users at objectweb.org
> 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 <sergiu.dumitriu at gmail.com>
>> 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 <igor_ti at yahoo.com.br> 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
>>>>
>>>>
>>>>       
>>>>         
>>> --
>>> http://purl.org/net/sergiu
>>>     
>>> --
>>> You receive this message as a subscriber of the 
>>> xwiki-users at objectweb.org mailing list.
>>> To unsubscribe:
>>> mailto:xwiki-users-unsubscribe at objectweb.org
>>> For general help:
>>> mailto:sympa at objectweb.org?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 xwiki-users at objectweb.org
>>     
> mailing list.
>   
>> To unsubscribe: mailto:xwiki-users-unsubscribe at objectweb.org
>> For general help: mailto:sympa at objectweb.org?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
>
>
>
>
>   
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the xwiki-users at objectweb.org mailing list.
> To unsubscribe: mailto:xwiki-users-unsubscribe at objectweb.org
> For general help: mailto:sympa at objectweb.org?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