ElasticSearch to search in MySql databse -


What is the idea of ​​using the database as a search server and ISA? I am putting in ES areas by which I want to link search and field to mysql (for example ID). When I execute the search in ES, I will get a list of IDs in mysql and then I will meet all the objects given by ISD by IID, am I right?

If I correctly understand your question, then you should index the area that you You want to put 'search' in elastic search, along with a non-analysis primary key that will allow you to get the record. For the searches you searched for from the database, you can see the index settings To not by defining its PK , you can read about it.

Another way to synchronize your ES cluster with your MySQL database, which means that any CRUED operation against your DB will be repeated in your ES cluster. If you have an eye on you then you can choose your DB at pre-determined intervals.

Comments

Popular posts from this blog

c - Mpirun hangs when mpi send and recieve is put in a loop -

python - Apply coupon to a customer's subscription based on non-stripe related actions on the site -

java - Unable to get JDBC connection in Spring application to MySQL -