What solutions would you recommend for a quick search on an Ubuntu+PHP+Nginx+MySQL server?

Question

PHP

I would like to know who uses what solutions to implement the search, except for the standard FULLTEXT mysql?
So that the solution can work quickly, search not only by words, but also by part of the word and easily work either as a PHP library or as a separate daemon, but with the ability to enter / read data there through PHP.

Answer 1

Good morning. Already 100 years ago, ElasticSearch, Solr and Sphinx appeared in our lives. It's my pleasure