Data Transfer MySQL


(Josem Polm) #1

Hello there,

How can I transfer data from Elasticsearch to MySQL?

Best regards.


(David Pilato) #2

Nothing OOTB I think.

You need to use the Scroll API to get all documents, then send the JSON to MySQL if you just want to store JSON there.
Or extract from the Json all the values to fill your sql model.


(Josem Polm) #3

Is there a way to do that? @dadoonet


(Christian Dahlqvist) #4

I agree with David that there most likely isn't anything available out of the box. I would recommend creating a script/application using one of the language clients.


(Josem Polm) #5

Thank you for your response. :blush:

Sample would such projects help? :face_with_raised_eyebrow:


(Matt Veitas) #6

You can look at using something like this if you need to do some replication: http://debezium.io/docs/connectors/mysql/


(Josem Polm) #7

What is this?


(Josem Polm) #8

Kibana could it be a solution for this? :pray: @dadoonet @Christian_Dahlqvist


(Christian Dahlqvist) #9

No. I think you will need to develop a script that uses scan/scroll to retrieve the data and then transform it into the correct structure before writing it to your database.


(system) #10

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.