Elasticsearch as a primary Mysql database

[Arash_Soft]

hi
there is a past topic like this but i want to know what is the solution after 4 years
now i use mysql and i have like 6000000 row per table and high request per second and i use slim framework to build my app
because of lots of queries and request my app goes slow
what is your suggestion?

[dadoonet (David Pilato)]

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.