# Using ElasticSearch-River-MySQL

**URL:** <https://discuss.elastic.co/t/using-elasticsearch-river-mysql/17514>\
**Category:** Elasticsearch\
**Created:** [May 14, 2014, 1:48pm UTC](https://discuss.elastic.co/t/using-elasticsearch-river-mysql/17514 "2014-05-14T13:48:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kristina\_Gancheva](https://avatars.discourse-cdn.com/v4/letter/k/8baadc/32.png) [@Kristina\_Gancheva](https://discuss.elastic.co/u/Kristina_Gancheva)\
**Post date:** [May 14, 2014, 1:48pm UTC](https://discuss.elastic.co/t/using-elasticsearch-river-mysql/17514/1 "2014-05-14T13:48:24Z")

</div>

Hi there,

I want to use elasticsearch-river-mysql[https://github.com/scharron/elasticsearch-river-mysql](https://github.com/scharron/elasticsearch-river-mysql) 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.

```
1. 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?  
2. 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?  
3. Are there any disadvantages in using this river for the mentioned  
above purpose?  
4. 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?

Thanks in advance. 🙂

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/80828bd8-17d1-4841-8f6f-d72728f6dbf0%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/80828bd8-17d1-4841-8f6f-d72728f6dbf0%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 1:29am UTC](https://discuss.elastic.co/t/using-elasticsearch-river-mysql/17514/2 "2017-07-06T01:29:28Z")

</div>

Closed on July 6, 2017, 1:29am UTC