InnoDB or MyISAM with triggers?

Question

MySQL

A database (MySQL) is being designed, most of the tables of which will be searched.
It would be nice if the search was full text.
There is an article on how to do a full-text search for InnoDB (with duplication of data in the lookup table).
Or you can make tables on MyISAM, and organize relationships between tables using triggers.
What are the pros / cons of these options in terms of speed and fault tolerance?
How justified are hybrid options?
I understand that MyISAM does not support transactions, are there other pitfalls?

Answer 1

fulltext search in muscle is the last century. do what you want and connect Sphinx for search.