How to design a search architecture?

Question

MySQL

Good afternoon!
Tell me how best to organize:

1. Keep only the information you need for searching in elastic indexes. In the search results, pull out only the id of documents. Search by id in mysql and give to the client.
   
2. Store indexes elastica all information. According to the search results, immediately give to the client.
   

Which of the options is more productive, more reliable?

Answer 1

Storing data in elastic is a bad idea in my opinion. Use it only for searching.

Answer 2

Option 2 is faster.
we have primary data in a general purpose database.
search - in specialized.
but when he finds it, he takes it from a specialized one.
however, the presence of primary data in a general-purpose database allows you to sleep peacefully.