Ubuntu 下安装配置 Sphinx 及 PHP 中使用

Sphinx 介绍

Sphinx 是一个可全文搜索的开源搜索引擎。最大的特点是可以有效地执行大数据的搜索。要索引的数据可以来自完全不同的源：SQL 数据库，纯文本文件，HTML文件，邮箱等

install

sudo apt-get install sphinxsearch -y

configuring Sphinx

sudo vim /etc/sphinxsearch/sphinx.conf

Sphinx 配置包含 3个必须运行的主要块。它们是 index searchd source

source

The source block contains the type of source, username and password to the MySQL server. The first column of the SQL query should be a unique id. The SQL query will run on every index and dump the data to Sphinx index file. Below are descriptions of each field and the source block itself.

• sql_query: This is the query thats dumps data to index.

source src1
{
  type          = mysql
  sql_host      = localhost
  sql_user      = root
  sql_pass      = password
  sql_db        = test
  sql_port      = 3306 # optional, default is 3306
  sql_query     = \
  SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, title, content \
  FROM documents
  sql_attr_uint     = group_id
  sql_attr_timestamp    = date_added
  sql_query_info        = SELECT * FROM documents WHERE id=$id
}

index

The index component contains the source and the path to store the data.

• source: Name of the source block. In our example, this is src1.
• path: This path to save the index.
• charset_type: This is the charset of the index.

index test1
{
  source            = src1
  path          = /var/lib/sphinxsearch/data/test1
  docinfo           = extern
  charset_type      = utf-8
}

searchd

The searchd component contains the port and other variables to run the Sphinx daemon.

• listen: This is the port which sphinx daemon will run. In our example, this is 9312.
• query_log: This path to save the query log.
• pid_file: This is path to PID file of Sphinx daemon.
• max_matches: Maximum number matches to return per search term.
• seamless_rotate: Prevents searchd stalls while rotating indexes with huge amounts of data to precache.
• preopen_indexes: Whether to forcibly preopen all indexes on startup.
• unlink_old: Whether to unlink old index copies on successful rotation.

searchd
{
  listen            = 9312   # Port to listen on
  log           = /var/log/sphinxsearch/searchd.log
  query_log     = /var/log/sphinxsearch/query.log
  read_timeout      = 5
  max_children      = 30
  pid_file      = /var/run/sphinxsearch/searchd.pid
  max_matches       = 1000
  seamless_rotate       = 1
  preopen_indexes       = 1
  unlink_old        = 1
  binlog_path       = /var/lib/sphinxsearch/data
}

adding data to the index

sudo indexer -c /etc/sphinxsearch/sphinx.conf test1
# sudo indexer --all

为了使索引保持最新，创建 cronjob

crontab -e
@hourly /usr/bin/indexer --rotate --config /etc/sphinxsearch/sphinx.conf --all

starting Sphinx

sudo searchd -c /etc/sphinxsearch/sphinx.conf

other way

默认情况下，Sphinx 守护程序已关闭。要启用 Sphinx，首先打开 /etc/default/sphinxsearch

sudo vim /etc/default/sphinxsearch

#Find the line START=no and set it to yes.
START=yes

Finally, start the Sphinx daemon.

sudo service sphinxsearch start

但是我遇到：

Job for sphinxsearch.service failed because the control process exited with error code. See "systemctl status sphinxsearch.service" and "journalctl -xe" for details

stop

sudo searchd --stop

testing search

sudo search -c /etc/sphinxsearch/sphinx.conf google

using Sphinx by PHP

install PHP extension

安装 PHP Sphinx 依赖库

sudo aptitude install libsphinxclient-dev  libsphinxclient-0.0.1 -y

安装 PHP Sphinx 扩展

sudo pecl install sphinx

在配置文件 php.ini 中添加 Sphinx 的扩展

sudo vim /etc/php5/fpm/php.ini
extension=sphinx.so

重启 php5-fpm

sudo /etc/init.d/php5-fpm restart

call in PHP

public function testSphinx()
{
    $s = new \SphinxClient;
    $s->setServer("localhost", 9312);
    $s->SetArrayResult (true);
    $s->setMatchMode(SPH_MATCH_ANY);
    $s->setMaxQueryTime(3);
    $result = $s->query("test");
    $result = $result['matches'];
    $result = array_column($result,'id');
    dump($result);
}