# How to update an index/indice in Elasticsearch?

**URL:** https://discuss.elastic.co/t/how-to-update-an-index-indice-in-elasticsearch/63912
**Category:** Elasticsearch
**Created:** [October 25, 2016, 5:17pm UTC](https://discuss.elastic.co/t/how-to-update-an-index-indice-in-elasticsearch/63912 "2016-10-25T17:17:26Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Kulasangar\_Gowrisang](https://avatars.discourse-cdn.com/v4/letter/k/ce73a5/32.png) [@Kulasangar\_Gowrisang](https://discuss.elastic.co/u/Kulasangar_Gowrisang)
#### Post date: [October 25, 2016, 5:17pm UTC](https://discuss.elastic.co/t/how-to-update-an-index-indice-in-elasticsearch/63912/1 "2016-10-25T17:17:26Z")

</div>

I've already got my index (`response_summary`) created using `logstash`, which puts data into the index from a MySQL database.

My concern here is, how will I be able to update the index manually whenever a new set of records are being added to the database without deleting and recreating the index yet again.

Or is there a way that it can be done automatically, whenever a db change is done?

Any help could be appreciated.

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [October 26, 2016, 9:20am UTC](https://discuss.elastic.co/t/how-to-update-an-index-indice-in-elasticsearch/63912/2 "2016-10-26T09:20:17Z")

</div>

You could use the SQL row ID as the ES document ID, so that it'll just update or create, as required.

---

<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 5, 2017, 10:09pm UTC](https://discuss.elastic.co/t/how-to-update-an-index-indice-in-elasticsearch/63912/3 "2017-07-05T22:09:38Z")

</div>


