Install MySQL with Sphinx Search Engine support

Recently I had some problems with a Sphinx search server which was upgraded through

This caused the Sphinx Storage engine inside my MySQL server fail to work.

When doing a search inside Mysql, eg by:

I got the follwoing error:

Also, when i was looking inside MySQL, to show the Engines, did not see any Sphinx engine active:

After searching my google friend, I never really found a straightforward solution to this problem. That’s why I bundled all steps I had to take to fix this problem.

I know my Shpinx was installed by enabling the ha_sphinx.so from within MySQL, but then i got this error:

Time to redo Sphinx – MySQL integration it seems…. This is because your sphinx plugin is build on the installed release version of MySQL :'(

These are the steps you need to perform to do this:

1. Look up the current installed version of MySQL

It seems that i have MySQL 5.1.63 installed on this system.

2. Download the MySQL source for THIS version and also the latest Sphinx version from the site

I got mine as follows:

Extract the archives

Copy the mysqlse directory from sphinx to mysql engine directory from the sources:

Build your sphinx files by:

Your newly created sphinx.so files can now be copied to the mysql live instyalltion directory:

* You night need some pre-requisits to perform this:

 

But 1st check your plugin dir details in

/etc/sphinx/default

or /etc/mysql/my.cnf

Time to load your sphinx plugin :