# Indexing MySQL data with ElasticSearch
**URL:** https://discuss.elastic.co/t/indexing-mysql-data-with-elasticsearch/181506
**Category:** Elasticsearch
**Created:** [May 17, 2019, 4:50am UTC](https://discuss.elastic.co/t/indexing-mysql-data-with-elasticsearch/181506 "2019-05-17T04:50:18Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Natasha96](https://discuss.elastic.co/u/Natasha96)
#### Post date: [May 17, 2019, 4:50am UTC](https://discuss.elastic.co/t/indexing-mysql-data-with-elasticsearch/181506/1 "2019-05-17T04:50:18Z")
I would like to get some feedback from anyone who's had experience indexing MySQL data with ElasticSearch for full-text searching. How did you accomplish this? I've been researching this a bit and unfortunately I've noticed that ElasticSearch has no [official site](https://www.mcd-voice.me/) plugin to accomplish this although I've come across three different 3rd party tools:
- elasticsearch-river-jdbc
- go-mysql-elasticsearch
- elasticsearch-river-mysql
I'm unsure which one would be best in terms of performance although I suspect the Go tool might have an advantage due to it's compiled nature and the fact that it uses the mysql binary logs. I would appreciate any advice or examples anyone could provide me with.
Thanks!
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [May 17, 2019, 8:03am UTC](https://discuss.elastic.co/t/indexing-mysql-data-with-elasticsearch/181506/2 "2019-05-17T08:03:11Z")
You can consider logstash and its jdbc input plugin.
But if possible, I'd recommend another approach which I described there: [http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/](http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/)
Basically, I'd recommend modifying the application layer if possible and send data to elasticsearch in the same "transaction" as you are sending your data to the database.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 14, 2019, 8:03am UTC](https://discuss.elastic.co/t/indexing-mysql-data-with-elasticsearch/181506/3 "2019-06-14T08:03:21Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.