# Integrate elastic search with MySQL

**URL:** https://discuss.elastic.co/t/integrate-elastic-search-with-mysql/161489
**Category:** Elasticsearch
**Created:** [December 19, 2018, 10:25am UTC](https://discuss.elastic.co/t/integrate-elastic-search-with-mysql/161489 "2018-12-19T10:25:13Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Shyju\_M](https://avatars.discourse-cdn.com/v4/letter/s/898d66/32.png) [@Shyju\_M](https://discuss.elastic.co/u/Shyju_M)
#### Post date: [December 19, 2018, 10:25am UTC](https://discuss.elastic.co/t/integrate-elastic-search-with-mysql/161489/1 "2018-12-19T10:25:13Z")

</div>

I would like to integrate elastic search for my existing website to speed up the search functionality. I have seen this plugin to import data from mysql to ES [https://github.com/jprante/elasticsearch-jdbc](https://github.com/jprante/elasticsearch-jdbc)

Is the plugin handle the synchronization btw these two? How can I update(modify/delete) the ES data whenever there is a change in the existing MySQL DB

Can Logstash can be used in this scenario?

Kindly suggest

---

<div class="post-metadata">

### Author: ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [December 19, 2018, 10:40am UTC](https://discuss.elastic.co/t/integrate-elastic-search-with-mysql/161489/2 "2018-12-19T10:40:47Z")

</div>

I shared most of my thoughts 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.

---

<div class="post-metadata">

### Author: ![Shyju\_M](https://avatars.discourse-cdn.com/v4/letter/s/898d66/32.png) [@Shyju\_M](https://discuss.elastic.co/u/Shyju_M)
#### Post date: [December 19, 2018, 11:05am UTC](https://discuss.elastic.co/t/integrate-elastic-search-with-mysql/161489/3 "2018-12-19T11:05:46Z")

</div>

Thank you @dadoonet, will check

---

<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: [January 16, 2019, 11:05am UTC](https://discuss.elastic.co/t/integrate-elastic-search-with-mysql/161489/4 "2019-01-16T11:05:58Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
