10 Apr
2007
10 Apr
'07
8:42 p.m.
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@xwiki.com]
Sent: Tuesday, April 10, 2007 7:17 PM
To: xwiki-users(a)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 :
--
Ludovic Dubost
Blog: http://www.ludovic.org/blog/
XWiki: http://www.xwiki.com
Skype: ldubost GTalk: ldubost
AIM: nvludo Yahoo: ludovic
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(a)gmail.com>
escreveu:
mailing list.
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(a)yahoo.com.br> wrote:
__________________________________________________
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(a)objectweb.org
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(a)objectweb.org mailing list.
To unsubscribe:
mailto:xwiki-users-unsubscribe@objectweb.org
For general help:
mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page:
http://www.objectweb.org/wws
To unsubscribe:
mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@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(a)objectweb.org mailing list.
To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws