This has got to be one of the coolest things I have come across in a long time. Sphinx a standalone MySQL full-text search engine. I’ve been working with it for a couple weeks now and I must say, this thing is blazin’ fast. I was most impressed by performance on large data sets (60+ million rows). Even when preforming sorts, it’s really fast. Oh, they have a PHP API too! If you’re looking to super charge your mysql search, give it a shot!
More on this with examples later.