I am currently looking into elasticsearch to index a few things. All of
my data is stored in either a MySql or Oracle database. This brings up 2
questions to get started:
- is there a way that I can take certain data from my database and index
- how do I keep the elasticsearch index up to date when new data is added
to my db? I know this might seem like a strange question so let me clarify
a little. I understand that when I want to add new data to the index I can
just post documents which is fine. So I can post data to the index every
time something is saved/updated/deleted to my database. However what do I
do when I need to patch the data in my database? Do I need to essentially
patch the elasticsearch index as well as my database.
Thanks so much (in advance) for getting me started.