Manual initial import and then watch changes

[DendisPatrik]

So I have a table with huge amount of data and I want to import this data to ClickHouse. I tried to run mysql_ch_replicator to initial replication and import all data from MySQL but with way it could be weeks to replicate all of them. So then I thought that could be faster if I import data manually and then I'll use mysql_ch_replicator to just watch changes and add new rows. But when I tried replicator just ignored then and it tried to replicate all data from scratch. Is there any workaround how to handle this case properly?

Thanks

[jayakarthik-jk]

+1

[VladimirDVV]

+1

[bakwc]

Implemented here #240 - added config option skip_initial_replication, with this option you responsible for creating all the structure and initial data copy yourself. So mysql_ch_replicator will only handle new events.
Available in v0.1.11 release
PS. Don't forget to add a _version column to every table in CH, otherwise it won't work.