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:

  • H2
  • PostgreSQL 9.5 and later
  • PostgreSQL 10.x
  • PostgreSQL 11.x
  • PostgreSQL 12.x
  • PostgreSQL 13.x
  • MySQL 5.6
  • MySQL 5.7
  • MySQL 8

H2 is an embedded database that is pre-configured in the default 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.