Recently, I got a database MySQL dump and I was thinking of importing it into elasticsearch.
The first idea which pops up was:
- install MySQL
- import the database
- read the database with Logstash and import into elasticsearch
- drop the database
- uninstall MySQL
Well. I found that some of the steps are really not needed.
I can actually use ELK stack and create a simple recipe which can be used to import SQL dump scripts without needing to actually load the data to a database and then read it again from the database.
Let’s do it!