 | Warning The following describes changes in the low-level Nuxeo configuration files. Starting with Nuxeo 5.3.2, a template system is used to change Nuxeo configuration, and by default the files described below will be overwritten by those from the templates at each startup. See the documentation on [How to configure Nuxeo EP] for more information about templates. |
Although Nuxeo recommends PostgreSQL in a production environment, you may want to try to connect VCS to another database, MySQL for instance.
The following describes the files you need to configure to use MySQL with VCS (Visible Content Store).
Nuxeo DM needs to use table names in case insensitive mode. So you have to configure it in MySQL configuration file, my.cnf, under the [mysqld] section.
- my.cnf:
JBoss configuration
- config/default-repository-config.xml:
- datasources/default-repository-ds.xml:
Adapt this code to use your database name and set appropriate login and password.
Note that this file contains the version number of the SQL connector, here 1.6.0. Don't forget to replace it with the version number of your Nuxeo EP instance (1.6.x is a core version number, see the actual full name of the RAR inside the system directory).
- You can also configure datasources/unified-nuxeo-ds.xml to store all other data in your MySQL database:
- Don't forget to also update the datasources/nxtags-ds.xml to follow the same DB instance, the Tag Service is required to work in the same table space as the default-repository. Accordingly, this file would look like that, if you use the same configuration as the one for unified-nuxeo-ds.xml:
- If you changed the database used to store Jena data, you also have to change a property in config/sql.properties:
- Drop the appropriate JDBC driver in $JBOSS/server/default/lib, for instance mysql-connector-java-5.1.6.jar for MySQL 5.x
You can download it from here: http://dev.mysql.com/downloads/connector/j/5.1.html
- Make sure you have in $JBOSS/server/default/deploy/nuxeo.ear/system these two JARs:
- nuxeo-core-storage-sql-1.6.0.jar
- nuxeo-core-storage-sql-ra-1.6.0.rar