How to Create a Scalable, High Performance Full-text Search Solution with MySQL

Full Text Search is a very popular feature nowadays. Many large web sites use Full Text Search with MySQL to search thru the site content (texts, titles, names and etc). However, when the datasets are growing Full Text Search can perform much worse and use much more resources than before. In this presentation we will show how to create a high performance and scalable full text solution with MySQL, which can search thru billions of documents and terabytes of data.

From this presentation you will know:

1. How to scale your full text search

2. How to tune MySQL Full Text Search for maximum performance

3. How to optimize your full text search queries

4. How to integrate MySQL with external search engines (i.e. Sphinx Search)

5. How to perform a Full Text Search with automatic typos correction