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.
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 |
