Jdbc update and delete

Elastic Stack Logstash
1

Hi
I am currently using logstash-plugin-jdbc to pull data from mysql to elasticsearch. I want to know is it possible to update or delete a single document in elasticsearch by modifying mysql?

For example, I got 1000 row in mysql table, and I modify no.349 row, I just want to update no.349 in elasticsearch, which is not passing the 1000 row again.

2

Detecting row deletions is hard, but updated rows can be picked up if you have a "last modified" column that you can include in your query so that only rows modified since the last run are updated.