Created 06-14-2023 02:29 AM
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.
Created 06-14-2023 12:16 PM
@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
Created 06-15-2023 02:22 AM
Thanks @MattWho I created https://issues.apache.org/jira/browse/NIFI-11695
Hoping for the best!