[xwiki-devs] Multiple remote DB for virtual wikis
Hello Dev, I am relatively new with xwiki.Is it possible with xwiki that eash wiki will have there individual remote Database.we configure main wiki data base in hibernet.cfg.xml file. when we create a wiki it creates wiki schema within the main database or same database engine.but what i want is when we create a wiki it will create the database for that wiki in another remote database server.not in the same file of main wiki database.and when we load the wiki it will use the remote database not the main wiki database.please let me know if it is possible.it would be greateful if you refer me some links if exists. BR, Sayeem
On Mon, Jun 8, 2009 at 17:06, rupok sayeem<rupsay@gmail.com> wrote:
Hello Dev,
I am relatively new with xwiki.Is it possible with xwiki that eash wiki will have there individual remote Database.we configure main wiki data base in hibernet.cfg.xml file. when we create a wiki it creates wiki schema within the main database or same database engine.but what i want is when we create a wiki it will create the database for that wiki in another remote database server.not in the same file of main wiki database.and when we load the wiki it will use the remote database not the main wiki database.please let me know if it is possible.it would be greateful if you refer me some links if exists.
XWiki does not support different databases servers by vitual wiki no. If you use MySQL you can look at mysql proxy (http://forge.mysql.com/wiki/MySQL_Proxy), it provide a mysql server interface and among other things I think it is able to forward request/response on other mysql servers depending on the database.
BR, Sayeem _______________________________________________ devs mailing list devs@xwiki.org http://lists.xwiki.org/mailman/listinfo/devs
-- Thomas Mortagne
On Jun 8, 2009, at 7:59 PM, Thomas Mortagne wrote:
On Mon, Jun 8, 2009 at 17:06, rupok sayeem<rupsay@gmail.com> wrote:
Hello Dev,
I am relatively new with xwiki.Is it possible with xwiki that eash wiki will have there individual remote Database.we configure main wiki data base in hibernet.cfg.xml file. when we create a wiki it creates wiki schema within the main database or same database engine.but what i want is when we create a wiki it will create the database for that wiki in another remote database server.not in the same file of main wiki database.and when we load the wiki it will use the remote database not the main wiki database.please let me know if it is possible.it would be greateful if you refer me some links if exists.
XWiki does not support different databases servers by vitual wiki no.
Multiple DB means clustering and this can work fine with some tuning in order to distribute the caches. It's not very convenient right now and we've planned to work on this to make it easier to use. Thanks -Vincent
If you use MySQL you can look at mysql proxy (http://forge.mysql.com/wiki/MySQL_Proxy), it provide a mysql server interface and among other things I think it is able to forward request/response on other mysql servers depending on the database.
BR, Sayeem
Hello Vincent, Is there any resourse how can we distribute the caches.by multiple db i mean each wiki will have there database on different remote location i it would be really helpful for me. BR, Sayeem
participants (3)
-
rupok sayeem -
Thomas Mortagne -
Vincent Massol