Ask Your Question

Unable to achieve CDC using MySQL Binary Log for Mariadb database.

asked 2018-01-03 01:21:52 -0600

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I am trying to use MySQL Binary Log Origin for CDC ,which worked well for mysql.

Does the same origin supports mariadb as well? If not, which of the origin need to be used for CDC with mariadb. Please, someone suggest me solution for this.


edit retag flag offensive close merge delete


Have you tried it? If so, what error did you see?

metadaddy gravatar imagemetadaddy ( 2018-01-12 13:09:29 -0600 )edit

yes I have tried,my pipeline is running without any errors.But no data is fetched. I tried updating,inserting,deleting data from table what i used as origin while i ran the pipeline.But streamsets pipeline does not show any data .

Maithri gravatar imageMaithri ( 2018-01-13 07:47:24 -0600 )edit

I created new pipeline with the same configurations as the previous pipeline,this time it gives error as unable to find driver instance !! But all the connectors are placed .

Maithri gravatar imageMaithri ( 2018-01-17 04:17:48 -0600 )edit

Thank you for your response @metadaddy

Maithri gravatar imageMaithri ( 2018-01-17 07:31:02 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2018-01-17 07:34:55 -0600

Maithri gravatar image

Though i was getting error as unable to find the driver,the issue was with the configuration file of mariadb. soln:

      /etc/mysql/my.cnf in local /etc/mysql/mariadb.cnf in server

    server-id               = 1
    log_bin                 = /var/log/mysql/mariadb-bin
    log_bin_index           = /var/log/mysql/mariadb-bin.index
    sync_binlog             = 1

making these configuration solved my issue!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2018-01-03 01:21:52 -0600

Seen: 1,964 times

Last updated: Jan 22 '18