How to set up full text search in Sphinx?

Question

Sphinx

Can you please tell me how to properly configure the config to perform full-text search in MySQL?
There is a table in the database with a list of contacts (350000+) columns id, name. Task: find possible typos of full name and display their id. Performed a search using MATCH AGAINST for each full name.
those. I requested a list of full names and for each of them I performed a query in the MATCH AGAINST database.
after iterated over the result using levenshtein in PHP. If there was a difference of 1 character, it was written to the array.
One request took about 1-2 seconds.
The contacts database is updated every 5 minutes.
It was advised to use sphinx to execute queries, but I did not find any information on setting up a full-text search fresh in 2013.
Or is there another way to solve this problem.
A more detailed description of the task How to find and display contacts with possible typos?

Answer 1

Well, it's not that simple.
You need to install sphinxsearch on the server.
Create a config for it that will work with the database, specify in the config that sphinxsearch should index. Hang up launching it on kroner.
And then, in the php project, interact with sphinx.
This can't be described in a nutshell, you'll have to read the documentation from sphinx and from php .

Answer 2

The Sphinx website always has up-to-date documentation for 2018