Sphinx (SQL Phrase Index) is a full-text search system with support for the morphology of various languages. Allows you to quickly and flexibly search for information in the database using free text.
To order Sphinx do the following:
To use Sphinx on a site, you need to configure both Sphinx itself and the site.
After ordering Sphinx, two tabs appear on the page of this additional service:
The configuration consists of two sections:
source) - configuration of the data source and its name (in the example
type) - data source type (in the example
sql_db) — data to connect to MySQL databasewhere the information for indexing will come from.
sql_query_pre) - a request that will be before the main request for receiving data from the database (in the example
SET NAMES utf8- setting UTF-8 encoding).
sql_query) - a request to get the necessary data from the database for indexing (in the example
select id, title, content from table- columns
contentfrom the table
index) - the configuration of the index and its name (in the example
source) - the name of the data source, where the information for indexing will come from (in the example
db_source- see above).
path) - the absolute path to the file with indices (in the example
morphology) - the name of the library (in the example
stem_ru), which will be used to search for a word with different word forms - for example, by the query “dog"Will return results with options"dogs», «dog», «dogs" etc.
index_exact_words) - when used in conjunction with the directive
expand_keywordsallows you to return more relevant results on request (in the example
min_word_len) - used by default
1, but words of this length usually do not carry a semantic load (in the example
A detailed description of how Sphinx works and a list of all its parameters can be found in official documentation (English).
Below you can:
After clicking "Save configuration»:
Before using plugins to work with Sphinx, carefully read their requirements and compatibility. Most plugins have not been supported for a long time and work with Sphinx version 2.2 or lower, the hosting uses version 3.
Setting up a site to work with Sphinx is the responsibility of the site developer or involved third-party specialists.
The task is reduced to the following stages:
The site connects to Sphinx over a socket. The socket path can be found on the Sphinx control page. The port should be specified depending on the configuration of the plug-in being connected; in general, the port can be neglected by specifying it as 0 or 9312.
To view the Sphinx log do the following:
tail -f ~/.system/sphinx/searchd.log