Installing and configuring a database for NiFi Registry

If you are installing NiFi Registry, you can install and configure an external MySQL or PostgreSQL database. By default, NiFi Registry is preconfigured to use an embedded H2 database.

H2 is an embedded database that is preconfigured in the default nifi.registry.properties file. The contents of the H2 database are stored in a file on your local file system. The H2 database location is specified as part of the JDBC URL property:

• NiFi Registry JDBC Url (nifi.registry.db.url) – jdbc:h2:./database/nifi-registry-primary

If you plan to use the H2 embedded database, you can skip the steps for installing and configuring an external database. Alternately, you may install a MySQL or PostgreSQL external database. To do this, review the following steps for either MySQL or PostgreSQL.

For a list of supported MySQL or PostgreSQL databases, see Supported NiFi Registry databases.