[xwiki-users] Multiple xwiki

[Ludovic Dubost]

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