mysql5.7+sphinx plugin 源码安装

原创于 2015-12-19 00:38:03 发布 · 235 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #git #c/c++

本文介绍如何在MySQL 5.7环境下安装并配置Sphinx全文搜索插件，包括下载所需软件包、安装依赖库、编译配置及启用插件等步骤。

http://blog.163.com/zhangjie_0303/blog/static/990827062014311412958/

cd /usr/local/src


wget http://sphinxsearch.com/files/sphinx-2.2.10-release.tar.gz


wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.10.tar.gz


wget http://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz


yum -y install cmake cmake-gui ncurses-devel libaio-devel git gcc-c++


tar -xzvf sphinx-2.2.10-release.tar.gz

tar -xzvf mysql-5.7.10.tar.gz

tar -xzvf boost_1_59_0.tar.gz


cp -r sphinx-2.2.10-release/mysqlse/ mysql-5.7.10/storage/sphinx

cd mysql-5.7.10

sh BUILD/autorun.sh


cmake -DWITH_BOOST=/usr/local/src/boost_1_59_0

make


cp /path/to/ha_sphinx.so /path/to/mysql/plugin/


chown mysql.mysql /path/to/mysql/plugin/*


mysql -uroot -p


INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so';


show engines;


delete from mysql.plugin where name='SPHINX';