Full-Text

In a recent customer engagement we experienced a lot of corrupted (normal) indexes and also corrupted full-text indexes on InnoDB tables in a Galera Cluster (v10.4.13).

In the error log we did not see which table it was but we have only a few log entries every here and there indicating a full-table index is corrupt:

2020-07-08 22:09:03 0 [ERROR] InnoDB: (Duplicate key) writing word node to FTS auxiliary index table.
2020-07-08 22:09:06 0 [ERROR] InnoDB: (Duplicate key) writing word node to FTS auxiliary …

MySQL has also a Full-Text Search Engine built in. But this Search Engine is not as fast a you probably want to. Thus there are some alternative Full-Text Search Engines which might be working together with MySQL.

• MySQL/MyISAM Full-Text Search
• Sphinx Search
• Lucene
• MnogoSearch
• Solr (based on Lucene)
• Omikron Fact-Finder
• Ioda
• Kneobase (based on Lucene)
• Egothor
• Xapian

More information

• Wikimedia: Fulltext search engines
• Searching for Text Information in Databases

Who uses what Full-Text Search Engine …