Storage Engine

Why not use InnoDB for the index table ?

The storage engine for the index table (tx_kesearch_index) is MyISAM while all other tables use the default InnoDB storage engine. Unfortunately this prevents using ke_search in Galera Clusters.

The reasons are explained below.

If the behaviour explained below does not affect how you use ke_search, you may switch to InnoDB for tx_kesearch_index.

Search for @-character ist not supported

You cannot search for the “at”-Character in InnoDB tables:

“InnoDB full-text search does not support the use of the @ symbol in boolean full-text searches. The @ symbol is reserved for use by the @distance proximity search operator.”

Phrase search is not supported

Phrase search using double quotes (“my search word”) is not supported in InnoDB.