Data Transfer MySQL

[josempolm]

Hello there,

How can I transfer data from Elasticsearch to MySQL?

Best regards.

[dadoonet (David Pilato)]

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.

[josempolm]

@dadoonet

Or extract from the Json all the values to fill your sql model.

Is there a way to do that? @dadoonet

[Christian_Dahlqvist]

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.

[josempolm]

@dadoonet

Nothing OOTB I think.

Thank you for your response.

@Christian_Dahlqvist

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.

Sample would such projects help?

[matt.veitas]

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

[josempolm]

@matt.veitas

You can look at using something like this if you need to do some replication:

What is this?

[josempolm]

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

[Christian_Dahlqvist]

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.