How do I connect my MySQL database to Elasticsearch (Cloud)

Elastic Stack Elasticsearch
1

I'm new to Elasticsearch and have a very rough understanding of how it works, so I'm not even sure if it's right for me. Does anyone know how to establish a live feed from my MySQL database to Elasticsearch (currently served on their cloud system)? My database has many tables with relationships so I'm not sure how to incorporate the relationships in Elasticsearch either...

I essentially want users to be able to search through all the data we have in our database with ease and flexibility. Is Elasticsearch even the right tool for this kind of thing?

I'm using Graphql and Express for the backend, and React for the frontend (not that it really matters)

2

Welcome!

I shared most of my thoughts there: http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/

Basically, I'd recommend modifying the application layer if possible and send data to elasticsearch in the same "transaction" as you are sending your data to the database.

Have also a look at this "live coding" recording which is using elastic cloud as well.

3

Thank you so much, this was very helpful! I didn't realize that I'd have to implement the database synchronization myself; I thought there was a plugin for that, so I guess that's where the confusion was coming from.