部署sphinx全文检索遇到的一些问题

最近要在系统里面加入一个全文检索，解决输入关键字，能搜索标题以及内容，使用比较成熟方案sphinx全文检索，当然也有其他方案，部署中遇到如下几个问题：

sphinx路径：把sphinx-3.1.1-612d99f-linux-amd64.tar.gz 解压到了/home/sphinx下

一、ERROR: index ‘data’: sql_connect: failed to load libmysqlclient (or libmariadb) (DSN=mysql://sphinxtest:***@192.168.0.11:3306/dbm).

yum install mysql

sudo ln -s /usr/lib64/mysql/libmysqlclient.so.18 /usr/lib64/libmysqlclient.so

二、WARNING: failed to open pid_file ‘/home/sphinx/var/log/searchd.pid’.
WARNING: indices NOT rotated.

如配置文件已经建好初始化启动sphinx

/home/sphinx/bin/searchd -c /home/sphinx/etc/sphinx.conf

mkdir -p    /home/sphinx/var/data/

mkdir -p    /home/sphinx/var/log/

三、FATAL: failed to open ‘/usr/local/var/data/binlog.lock’: 2 ‘No such file or directory’

mkdir -p    /usr/local/var/data/

文出自 “凹凸曼” 博客，请务必保留此出处 http://www.apoyl.com/?p=2729