As you may know mysql fulltext search is not highly scalable. One of the options to get around this scalability limitation, which I prefer, is to use Sphinx. You can use Sphinx with out having to alter your mysql installation. But, if you would like to use from within mysql and not have to worry about how to pass data between Sphinx and MySQL, you can enable sphinxse (sphinx storage engine). It is not included with mysql by default so you will have to compile it yourself.
Here are the instructions on how to get sphinxse compiled with your mysql installation on CentOS x64. I am sure same instructions will work for other flavors but I have not tested it. I will be compiling the most current version of sphinx (0.9.8) with most current stable version of mysql (5.0.51b) at the time of the writing. Let’s get the appropriate …
[Read more]