1

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 ?

bsd
  • 1,207
  • 4
  • 15
  • 28

1 Answers1

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.

metadaddy
  • 4,234
  • 1
  • 22
  • 46