You can easily load and index data from your MySQL database straight into Elasticsearch.
First install Elasticsearch and make sure it’s running.
Then open up a new terminal window and install the elasticsearch-river-jdbc plugin.
You then need to use the curl command to tell the plugin your river name (in the URI), the database host and credentials and of course the SQL query.
I recommend having each of your rivers index into a specified index. See section “Index” or “Bulk Index” on JDBC River Plugin for ElasticSearch.
Leave a Reply