Multiple Repositories Configuration

A default Nuxeo Platform installation is configured to use one repository. A repository:

• Encompasses the database storage for all the documents stored under one root. In the user interface it's visible as a server above the domains.
• Defines how is done the storage for the document attachments, called the binary store.

The default configuration for the repositories comes from XML files, which contain various configuration values themselves described as variables. The variables are set through nuxeo.conf configuration parameters (nuxeo.db.host, nuxeo.db.user, nuxeo.db.password, etc.).

When multiple repositories are used, we want to use different configuration parameters for each, but the default Nuxeo templates are designed for a single repository. This means that to add a second repository, some templates will have to be copied and modified to use a second set of configuration parameters.

In addition, when more than one repository is configured, certain optimizations that are valid when only one database is accessed cannot be used anymore.

Datasources Configuration

1. Deactivate the default single-datasource mode in nuxeo.conf:

   nuxeo.db.singleDataSource=
   

   This will allow the use of separate datasources for each type of database connection that Nuxeo does.

   See JDBC Datasource Configuration for information about the single-datasource mode in effect in a default Nuxeo Platform installation.

2. Configure your datasources using XA mode so as to keep a single transactional context for all database access:

   nuxeo.db.xaMode=true
   

   The templates configuring the default datasources in Nuxeo will use XA parameters for them.

3. For each additional repository, add a new file, either through custom templates, or directly in $NUXEO/nxserver/config, that defines your new datasource, like the example below.

   datasources-secondrepo-config.xml

   <?xml version="1.0"?>
   <component name="datasources-secondrepo-config">
     <extension target="org.nuxeo.runtime.datasource" point="datasources">
       <datasource name="jdbc/repository_secondrepo" xaDataSource="org.postgresql.xa.PGXADataSource"
         maxPoolSize="100" minPoolSize="5" blockingTimeoutMillis="10000">
           <property name="ServerName">localhost</property>
           <property name="PortNumber">5432</property>
           <property name="DatabaseName">secondrepo</property>
           <property name="User">nuxeo</property>
           <property name="Password">password</property>
       </datasource>
     </extension>
   </component>
   

   • The name jdbc/repository_secondrepo is important, as this name is actually  jdbc/repository_ followed by the name of the repository (secondrepo) that we will define below.
   • Of course the xaDataSource and the various property values should be filled in according to your database parameters.
     JAR Dependencies

   If you want to connect to a database that's not already in a template configured in nuxeo.conf, don't forget to put the necessary JDBC JARs in the lib/ directory of Nuxeo.