Schema Differences & Limitations
Due to differences across database implementations, there are two versions of the schema for NiFi Registry's metadata database. The original version supports H2 and Postgres, and a second versions supports MySQL.
MySQL has limitations on the maximum size of text columns that are part of an index, or unique key. This means the maximum length of some columns is significantly less when using MySQL vs. H2/Postgres.
 | Note |
|---|---|
If choosing to use MySQL it is important to understand these limitations and accept them. |
The following tables summarizes the schema differences in column lengths:
|
Table.Column |
H2/Postgres |
MySQL |
|
BUCKET.NAME |
1000 |
767 |
|
FLOW_SNAPSHOT.CREATED_BY |
4096 |
767 |
|
SIGNING_KEY.TENANT_IDENTITY |
4096 |
767 |
|
BUNDLE.GROUP_ID |
500 |
200 |
|
BUNDLE.ARTIFACT_ID |
500 |
200 |
|
BUNDLE_VERSION.CREATED_BY |
4096 |
767 |
|
BUNDLE_VERSION.BUILT_BY |
4096 |
767 |
|
BUNDLE_VERSION_DEPENDENCY.GROUP_ID |
500 |
200 |
|
BUNDLE_VERSION_DEPENDENCY.ARTIFACT_ID |
500 |
200 |
|
EXTENSION_PROVIDED_SERVICE_API.CLASS_NAME |
500 |
200 |
|
EXTENSION_PROVIDED_SERVICE_API.GROUP_ID |
500 |
200 |
|
EXTENSION_PROVIDED_SERVICE_API.ARTIFACT_ID |
500 |
200 |