[jira] [Commented] (NIFI-5583) Make Change Data Capture (CDC) processor for MySQL refer to GTID

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/NIFI-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17197602#comment-17197602 ] 

ASF subversion and git services commented on NIFI-5583:
-------------------------------------------------------

Commit fc610eaeda8369988ef65be1e39f53fd7627a9cb in nifi's branch refs/heads/main from yoshiata
[ https://gitbox.apache.org/repos/asf?p=nifi.git;h=fc610ea ]

NIFI-5583: Add cdc processor for MySQL referring to GTID.

Signed-off-by: Pierre Villard <pi...@gmail.com>

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: New Feature
>          Components: Extensions
>    Affects Versions: 1.7.1
>            Reporter: Yoshiaki Takahashi
>            Assignee: Yoshiaki Takahashi
>            Priority: Major
>          Time Spent: 2h 40m
>  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)