How to update an index/indice in Elasticsearch?

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.

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

1 Like