We have a requirement to search elasticsearch and import the output into MySQL DB. Do we have any recommended options for it.
Looking around, there is a Logstash mysql output plugin in GIT. Also, the option is to possibly convert the json output to CSV file and then load it into MySQL.
This is a production setup, so I am weighing -in the pros and cons of a suitable setup, especially something officially supported by elastic.