How Nifi could read encrypted Binlogs ?

[#1]

I currently use Nifi changecaptureMysql processor to read Binlogs from Mysql 5.7. (encryption not supported)

I got to know that Mysql 8.0 supports binlogs to be encrypted. and soon I want to upgrade.

Currently Nifi is able to read un-encrypted bin logs successfully, with just DB username and password.

Can someone please help me understand what changes to be done to the processor configuration that it will read encrypted Binlogs ? Do we need to provide any keys ? to decrypt the logs ? Please suggest.

[#2]

@SandyClouds 

The changeCaptureMySQL processor uses a third party client for connecting  to SWL and reading the binlogs.
https://github.com/zendesk/mysql-binlog-connector-java

I don't see that this client library has the ability to read encrypted binlogs. 

I encourage you to open an Apache NiFI jira for this product improvement to see if there is other interest for this within the Apache NiFi community.  Such an improvement may require identifying a different client library that can support the new encrypted binlogs capability offered in MySQL 8.0+.  

If you found that the provided solution(s) assisted you with your query, please take a moment to login and click Accept as Solution below each response that helped.

Thank you,

Matt

[#3]

Thanks @MattWho I created https://issues.apache.org/jira/browse/NIFI-11695

Hoping for the best!