Insert MySQL table data into Elasticsearch using PHP


I just released a tool, mySQLtoes which selects mysql data from the specified table and insert it into Elasticsearch indexes. I know the most common way to insert data from mysql to elasticsearch is to use JDBC driver of Elasticsearch, but due to the environment that I was developing on I needed to do some data manipulation before inserting the data to Elasticsearch, so I decided to write a reusable piece to get this done.

You can download my tool from my github page. more details about it are available here.

Hope it helps some people out there, at the moment I do not do any mapping before inserting the data so either you need to use dynamic mappings or remap your data again after insertion to elasticsearch.

I’ll probably develop it more and add mapping functionalities if I can manage to find some free time.

Leave a Reply