how to load data from MYSQL to Druid.


I have installed druid on my Linux machine by following the quickstart tutorial. But the problem is how to load the data from MYSQL into druid database. And how can i get data from druid through java

I Kafka Connect wouldn’t exist, I would write a simple program which would execute a paged SQL statement to extract non-changeing data from MySql and use a Kafa producer to produce data into a Kafka topic.
Depending on the size of data in MySql - the program could be smart enough do execute coordinated parallel queries, etc…

After that, it should be simple to get data in a Druid datasource.

Sinca Kafka Connect exists, I would use it :slight_smile:


Correction: If Kafka Connect wouldn’t exist…
Correction 2: extract non-changing

Duplicated by!topic/druid-development/UMHxSRdJvY8