Hi,
There is some information here on how to setup virtual wikis with xwiki
http://www.xwiki.com/xwiki/bin/view/Doc/HowToSetupVirtualWikis
This currently works with mysql and hasn't been tested with other DBs..
It relies on the setCatalog() function of JDBC so it should work with
most DBs..
Using setCatalog does not need a separate connection pool for each DB
even on mysql. The switch of database happens on the same connection.
It works perfectly fine and we are running this with 4400 databases on
xwiki.com
Ludovic
Sam Taha wrote:
Greetings,
I am new to xwiki and was wondering how some of the multi-company
features of xwiki work. From my readings it sounds like one must
create a separate mysql db for each new company/tenant. If this is
true would this not require a seperate database connection pools for
each company?
Are Oracle or Postgresql supported? I know with these two databases
one can create database namespaces (something mysql does not have).
This would allow the same jdbc driver to reference mulitple namespaced
schemes and thus use the same pool.
Anyway, any thoughts would be apprciated. I am looking to setup xwiki
in a multi company setup and was looking for some insight.
Thanks,
Sam
------------------------------------------------------------------------
Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
<http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yahoo.com/unlimited/>
------------------------------------------------------------------------
--
You receive this message as a subscriber of the xwiki-dev(a)objectweb.org mailing list.
To unsubscribe: mailto:xwiki-dev-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
XPertNet:
http://www.xpertnet.fr/
Blog:
http://www.ludovic.org/blog/
XWiki:
http://www.xwiki.com
Skype: ldubost AIM: nvludo Yahoo: ludovic