MySQL Forums
Forum List  »  Data Warehouse

How to build a MySQL-powered search engine
Posted by: Matthias Mullie
Date: July 16, 2013 04:23AM

When building Fork CMS (http://www.fork-cms.com), we very much wanted to provide a built-in search module. There were 2 challenges, though:
* The search module would have to search in all other modules' data (which would live in other tables, in a non-generic way) at once
* The search module would have to scale well: data could grow very large

To search, we use MySQL's FullText tools. To make the search scale and be capable of searching all modules, we've created a "search index": a search-specific table where all textual data is duplicated.

How exactly we manage to implement this and scale it, is written in more details in this article: http://www.mullie.eu/mysql-as-a-search-engine/

Options: ReplyQuote


Subject
Views
Written By
Posted
How to build a MySQL-powered search engine
2578
July 16, 2013 04:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.