source main
{
type = mysql
sql_host = host
sql_user = user
sql_pass = pass
sql_db = db
sql_port = port
mysql_connect_flags = 32
sql_query_pre = SET NAMES utf8
sql_query_pre = SET SESSION query_cache_type=OFF
}
source catalog_base : main
{
sql_field_string = name
sql_field_string = code
}
source catalog : catalog_base
{
sql_query = \
select \
* \
from catalog
}
index catalog_index
{
source = catalog
path = /usr/local/sphinx/data/catalog
docinfo = extern
dict = keywords
mlock = 0
morphology = stem_ru, soundex, metaphone
min_word_len = 3
html_strip = 1
}
index catalog_rt
{
type = rt
path = /usr/local/sphinx/data/catalog_rt
rt_field = name
rt_field = code
rt_mem_limit = 256M
}
index catalog
{
type = distributed
local = catalog_index
local = catalog_rt
}