[
https://issues.apache.org/jira/browse/NIFI-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17198046#comment-17198046
]
ASF subversion and git services commented on NIFI-5583:
-------------------------------------------------------
Commit 174720104872b43dbaf94a268690d986de7f6b03 in nifi's branch
refs/heads/support/nifi-1.12.x from yoshiata
[ https://gitbox.apache.org/repos/asf?p=nifi.git;h=1747201 ]
NIFI-5583: Add cdc processor for MySQL referring to GTID.
Signed-off-by: Pierre Villard <[email protected]>
This closes #2997.
> Make Change Data Capture (CDC) processor for MySQL refer to GTID
> ----------------------------------------------------------------
>
> Key: NIFI-5583
> URL: https://issues.apache.org/jira/browse/NIFI-5583
> Project: Apache NiFi
> Issue Type: Improvement
> Components: Extensions
> Affects Versions: 1.7.1
> Reporter: Yoshiaki Takahashi
> Assignee: Yoshiaki Takahashi
> Priority: Major
> Fix For: 1.13.0, 1.12.1
>
> Time Spent: 3h 10m
> Remaining Estimate: 0h
>
> When connecting to a MySQL cluster consisting of multiple hosts, existing CDC
> processor can not automatically switch to other host when the connected host
> goes down.
> The reason is that file names and positions of binary log may be different
> for each host in the same cluster.
> In such a case it is impossible to continue reading files from the same
> position.
> In order to continue reading in such cases, a processor referring to the GTID
> (Global Transaction ID) is necessary.
> GTID is ID that uniquely identifies a transaction, and it is recorded in
> binary log of MySQL.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
