title: How to import mysql Data to Elasticsearch?
body: <p>I've been searching and reading docs on how to import mysql data to ES and get the best solution by creating logstash file and running it every minute. But at last, it wasn't efficient compared to my requirement(I have to run each query on each table in logstash which it's not practical). </p>
  
  <p>I have to import the whole MySQL Database to Elasticsearch including mappings,tables relationships and data every time a user handles my application (there are many users on the platform).   </p>
  
  <p>I've already read <a href="https://stackoverflow.com/questions/34477095/elasticsearch-replication-of-other-system-data/34477639#34477639">this link</a> but it's not helping me. Any suggestions ? Thanks </p>