title: Using elasticsearch-river-mysql to stream data from MySQL database to Elasticsearch
body: <p>I want to use <a href="https://github.com/scharron/elasticsearch-river-mysql" rel="noreferrer">elasticsearch-river-mysql</a> in order to continuously transfer data from MySQL database to ElasticSearch. I'm beginner with ES and rivers so I hope you can help me out with my questions. </p>
  
  <ol>
  <li>From what I know, the data will be streamed from the MySQL database to the ES cluster which will index it automatically. Is that correct? Are there any timeouts or limits I have to be aware of?  </li>
  <li>How the foreign key relations between the relational database tables will be translated into ES? Will the table row containing the foreign key become an inner object for an ES document or some other relation between the ES documents will be used?</li>
  <li>Are there any disadvantages in using this river for the mentioned above purpose? </li>
  <li>What will be the load on ES by implementing this? I assume that ES is powerful enough, but still I was wondering. Will the searches made on the ES cluster be affected anyhow in this scenario?</li>
  </ol>