StreamSets CDC origin: Mysql-Binarylog unable to get driver instance


StreamSets CDC origin: Mysql-Binarylog unable to get driver instance



I am trying to setup Mysql-BinaryLog in StreamSets, but it complains it cannot load the driver instance.



my.cnf:


[mysqld]
server-id = 223344
log_bin = mysql-bin
binlog_format = row
binlog_row_image = full
expire_logs_days = 10



Is there something else it has to be done in order for the StreamSets origin to work ?




1 Answer
1



You need to install the MySQL JDBC driver into Data Collector - follow the instructions for installing an external library, but ensure you select the MySQL BinLog stage library when uploading the JDBC driver:



enter image description here



Also, if you're using MySQL Server 5.x, please use a version 5.x MySQL JDBC driver. There are known issues trying to use the version 8.x JDBC driver with an older server.






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Popular posts from this blog

PHP contact form sending but not receiving emails

Do graphics cards have individual ID by which single devices can be distinguished?

iOS Top Alignment constraint based on screen (superview) height