How to switch from mysql to elasticsearch?

Question

MySQL

Good afternoon, there is a rather difficult task, I would like to hear the opinion of experts. :)
There is a highly loaded project based on mysql, due to the growth, the speed of working with the database decreases.
There is an idea to switch to elasticsearch.
Actually, I want to understand the sequence of actions, especially when transferring, and how to organize the structure?
What about indexes and joins?
Thanks in advance!

Answer 1

No way. You can't "move" from a database to a search engine.
You can make a search service that will index information taken from the database
Based on this service, make a full-text and faceted search.
Leave the current database as is. Only optimize requests so that "the speed of work does not decrease"

Answer 2

long and hard work.
do you really need it?

Answer 3

It is not desirable to store important data in elasticsearch as the main database, although I think it is possible. I would recommend that you first try to optimize mysql, and where there are heavy queries, for example, a lot of joins, groupings, sortings, etc. index in es and search there already. In any case, you will have to do these brake queries in mysql, but you will only do them at the stage of indexing es