# Updating index from modified document

**URL:** <https://discuss.elastic.co/t/updating-index-from-modified-document/91245>\
**Category:** Elasticsearch\
**Created:** [June 29, 2017, 8:44am UTC](https://discuss.elastic.co/t/updating-index-from-modified-document/91245 "2017-06-29T08:44:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Siddhartha\_Singh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/siddhartha_singh/32/19589_2.png) [@Siddhartha\_Singh](https://discuss.elastic.co/u/Siddhartha_Singh)\
**Post date:** [June 29, 2017, 8:44am UTC](https://discuss.elastic.co/t/updating-index-from-modified-document/91245/1 "2017-06-29T08:44:44Z")

</div>

Hello,  
We have the information stored with us in spreadsheets and we use logstash 2.4.1 to stash the data into elasticsearch 2.4.4 using a configuration script that fetches the data from the MySQL local server. Now if I have about a **million entries** about people stashed into elasticsearch and about **thousand updates** to the people's permanent addresses or say their phone numbers- **what would be the best way to have the newer information updated in the elasticsearch in order to save time ?**

---

<div class="post-metadata">

**Author:** ![Rory](https://avatars.discourse-cdn.com/v4/letter/r/a183cd/32.png) [@Rory](https://discuss.elastic.co/u/Rory)\
**Post date:** [July 3, 2017, 4:09pm UTC](https://discuss.elastic.co/t/updating-index-from-modified-document/91245/2 "2017-07-03T16:09:29Z")

</div>

You will need to generate a unique id for each person, and whenever the address of the person changes just use logstash to reload the entire document using the same unique id as before. I believe Logstash has a input plugin for mysql so you can load data directly from the source instead of storing it into spreadsheets.

---

<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 31, 2017, 4:09pm UTC](https://discuss.elastic.co/t/updating-index-from-modified-document/91245/3 "2017-07-31T16:09:31Z")

</div>

Closed on July 31, 2017, 4:09pm UTC

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