Comments on Sphinx As MySQL Storage Engine (SphinxSE)
Sphinx As MySQL Storage Engine (SphinxSE) SphinX is a great full-text search engine for MySQL. Installing the Sphinx daemon was straightforward as you can compile it from the source or use a .DEB/.RPM package but SphinxSE was a little bit tricky since it needed to be installed as a plugin on a running MySQL server. So if you use Debian or Centos and install your MySQL from a .deb or .rpm package this is how you do it.
9 Comment(s)
Comments
Thx for this article.
On ubuntu 10.04 LTSn we need to add rules for apparmor in order to install plugin in MySQL.
We did have to update the apparmor profile /etc/apparmor.d/usr.sbin.mysqld and add this line:
/usr/lib/mysql/plugin/* rm,
and restart apparmor.
This article was extremely helpful in installing SPHINX plugin.
It is more clear and helpfull than the SPHINX documentation.
Great work!
Thanks a Lot.
Thanks a lot, man!! Followed this instruction to build SphinxSE plugin though not on Linux but on FreeBSD.
It worked like a charm! I was worrying about the fact that I do manipulations on LIVE server, but it's allright. :)
I followed the instructions above but then I get this:
make[2]: Leaving directory `/app/tmp/mysql/storage/myisam'
Making all in sphinx
make[2]: Entering directory `/app/tmp/mysql/storage/sphinx'
make[2]: *** No rule to make target `all'. Stop.
make[2]: Leaving directory `/app/tmp/mysql/storage/sphinx'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/app/tmp/mysql/storage'
make: *** [all-recursive] Error 1
Any ideas on how to fix?
I'm having the same error, any ideas how to fix it?
Making all in myisam
make[2]: Entering directory `/tmp/mysql-5.1.58/storage/myisam'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/tmp/mysql-5.1.58/storage/myisam'
Making all in sphinx
make[2]: Entering directory `/tmp/mysql-5.1.58/storage/sphinx'
make[2]: *** No rule to make target `all'. Stop.
make[2]: Leaving directory `/tmp/mysql-5.1.58/storage/sphinx'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/tmp/mysql-5.1.58/storage'
make: *** [all-recursive] Error 1
I was just about to install the whole Sphinx search - when I realized that the daemon is already available as a package in Ubuntu 10.04 LTS / Lucid.
It should be as simple as :
sudo apt-get install sphinxsearch
Hope it helps someone.
Great Tutorial! Please check my post for a newer version ... Install Sphinx 2.0.4 on CentOS 6.2
we do get the error message that glibv in version 2.14 is needed, on that specific maschine 2.11 is available, do we have to compile the .so file on a maschine that is running 2.11?
Hi, is there a more recent tutorial for this article?