Jdbc update and delete

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.

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.

1 Like

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