I gave a webinar several weeks ago about Grazr's infrastructure,
lessons we learned about scaling and over-building. One thing
that I noticed a lot of interest in was how we used Sphinx to not
only improve our search, but releive the database of FULLTEXT
indices, which were a performance issue for us.
The purpose of these posts are to give you an idea of how Sphinx works, any limitations it has, and how you can use for both search functionality, as well as freeing your database from having to use FULLTEXT. I think Sphinx is a great project, and want to share info that can help promote its use.
There is a lot of information on Sphinx to share, so I'm going …