[
https://issues.apache.org/jira/browse/NIFI-4572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Matt Burgess updated NIFI-4572:
-------------------------------
Status: Patch Available (was: In Progress)
> CaptureChangeMySQL does not return database and table info without
> DistributedMapCache
> --------------------------------------------------------------------------------------
>
> Key: NIFI-4572
> URL: https://issues.apache.org/jira/browse/NIFI-4572
> Project: Apache NiFi
> Issue Type: Improvement
> Components: Extensions
> Reporter: Matt Burgess
> Assignee: Matt Burgess
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> CaptureChangeMySQL will leverage a DistributedMapCache, when enabled, to
> store database, table, and column information for the configured MySQL
> instance. This is due to the possibly large amount of information needed to
> be stored for large tables and large numbers of tables.
> However the database and table information (not columns) is available in the
> TABLE_MAP event, associated with each MySQL transaction, and it applies to
> the entire transaction. So this information can be used to populate the
> database and table fields in the outgoing CDC events, even if the
> DistributedMapCache is not enabled/configured. This is slightly related to
> NIFI-3902, although the code locations/paths are likely different.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
