Wiki source code of Configuring the multi-tenancy feature
Version 19.5 by Vincent Massol on 2013/05/24
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | {{box cssClass="floatinginfobox" title="**Contents**"}}{{toc/}}{{/box}} | ||
| 2 | |||
| 3 | A [[multi-tenant>>http://en.wikipedia.org/wiki/Multitenancy]] setup (a.k.a "virtual mode", "multi-wiki" or "farm mode") allows you to have several wikis running on the same XWiki instance (i.e. in the same JVM). | ||
| 4 | |||
| 5 | This is implemented by having each wiki have its own schema or its own database in the DBMS (whether it's implemented as schema or databases depends on the DBMS). | ||
| 6 | |||
| 7 | The main advantage of multi-tenancy is performance optimization. A single XWiki instance on a physical machine (thus a single Servlet Container) will perform much better than having several XWiki instances running on the same machine, which wouldn't scale. As an example known XWiki multi-tenant instances host several hundreds to several thousands wikis on a single XWiki instance. | ||
| 8 | |||
| 9 | = Requirements = | ||
| 10 | |||
| 11 | The multi-tenancy feature is currently supported only on some [[DBMS>>http://en.wikipedia.org/wiki/Database]]: | ||
| 12 | * MySQL (using a different database for each subwiki) | ||
| 13 | * Oracle (using a different schema for each subwiki) | ||
| 14 | * HSQLDB (using a different schema for each subwiki) {{info}}Starting with XWiki 4.3{{/info}} | ||
| 15 | * PostgreSQL (using a different schema for each subwiki) {{info}}Starting with XWiki 5.0{{/info}} {{info}}Also note that using different databases instead of schemas is not currently supported on PostgreSQL since the JDBC driver doesn't support ##setCatalog()## for changing databases. That's because PostgreSQL connections are pointed to a specific database at connection time (see jira issue [[XWIKI-1960>>http://jira.xwiki.org/jira/browse/XWIKI-1960]] for details).{{/info}} | ||
| 16 | * [[Derby is currently not supported>>http://jira.xwiki.org/browse/XWIKI-8244]] | ||
| 17 | |||
| 18 | In addition to having a supported DBMS you'll also need: | ||
| 19 | * To choose one instance of XWiki that has been installed on your network and that wil act as the main wiki. The database name for this wiki should be ##xwiki##. If you've still got to install the XWiki instance, please refer to [[the installation guide>>AdminGuide.Installation]] and install XWiki Enterprise first. | ||
| 20 | * Admin privileges on this XWiki instance | ||
| 21 | * You need to be sure that the ##xwiki## user used to create the main database has the correct permissions to be able to create other schemas or databases since each subwiki will create a new schema/database. Refer to the [[Databases install guides>>InstallationWAR#HInstallandconfigureaRelationalDatabase]]. | ||
| 22 | |||
| 23 | = Configuration = | ||
| 24 | |||
| 25 | There's no special step to take to get the multi-tenant feature since it's a builtin feature. However, we're providing a UI for users to make it easier to create, configure and delete sub wikis. For this you need to install the [[Wiki Manager Application>>extensions:Extension.Wiki Manager Application]] (see that page for installation instructions). | ||
| 26 | |||
| 27 | You're now ready to create sub wikis by following the [[Wiki Manager Application documentation>>extensions:Extension.Wiki Manager Application]]. | ||
| 28 | |||
| 29 | = Configuration prior to XWiki 5.0 = | ||
| 30 | |||
| 31 | {{info}}These steps are no longer needed if you use XWiki 5.0 or newer.{{/info}} | ||
| 32 | |||
| 33 | * Stop your XWiki instance, edit the ##WEB-INF/xwiki.cfg## file, look for the ##xwiki.virtual## property and set it to ##1##: {{code}}xwiki.virtual=1{{/code}} | ||
| 34 | * Restart your XWiki instance |
