Supported databases for NiFi Registry
Lists supported external databases for NiFi Registry and provides information about the embedded H2 database which is pre-configured.
If you are installing a new NiFi Registry, then you can use one of the following databases:
- PostgreSQL 9.x
- PostgreSQL 10.x
- MySQL 5.6
- MySQL 5.7
- MySQL 8
H2 is an embedded database that is pre-configured 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 (
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.