Metadata Store¶
To use a different SQL backend, get the JDBC driver JAR for your chosen database and copy it into the plugins folder of the metadata service installation. Then edit the main configuration file (usually trac-platform.yaml) with the correct settings from below. Pool size and overflow options are always available, the values below are examples only.
Oracle support is available but not actively tested in CI due to licensing issues. If you would like support for a different SQL dialect, please get in touch.
H2 configuration
dalType: JDBC
dalProps:
dialect: H2
jdbcUrl: <path to database file>
h2.user: <username>
h2.pass: <password>
h2.schema: <schema>
pool.size: 10
pool.overflow: 5
MySQL configuration
dalType: JDBC
dalProps:
dialect: MYSQL
jdbcUrl: //<host>:<port>/<database>
mysql.user: <username>
mysql.password: <password>
pool.size: 10
pool.overflow: 5
MariaDB configuration
dalType: JDBC
dalProps:
dialect: MARIADB
jdbcUrl: //<host>:<port>/<database>
mariadb.user: <username>
mariadb.password: <password>
pool.size: 10
pool.overflow: 5
PostgreSQL configuration
dalType: JDBC
dalProps:
dialect: POSTGRESQL
jdbcUrl: //<host>:<port>/<database>
postgresql.user: <username>
postgresql.password: <password>
pool.size: 10
pool.overflow: 5
SQL Server configuration
dalType: JDBC
dalProps:
dialect: SQLSERVER
jdbcUrl: //<host>:<port>
sqlserver.databaseName: <database>
sqlserver.user: <username>
sqlserver.password: <password>
pool.size: 10
pool.overflow: 5