Best way to implement search function with innoDb

Question

I need to implement something like full-text pair search, if the index in the table of large products using innodb, MyISAM is not an option due to the lack of transactions and support for relationships.

I can come up with a couple of ways to do this: a plugin, a stored procedure, a lookup table with keys, and a copied index in MyIsam format.

How did you achieve this in the past, which is the best way (including, I did not mention) and why?

The plugin sounds expensive, the stored procedure sounds slow, and the lookup table sounds like the admiral’s nightmare.

Love to hear your views.

Answer 1

, ( ), , Lucene ( PHP, Zend_Search_Lucene)

( , , ); , , , MySQL, ( : , , : " t SQL-, )

, ; ( "" , ).

- ; , , " " DB.

Answer 2

Sphinx

Answer 3

Xapian php , , xapian , , .

" " xapian, ()