Vladimir Fedorkov

How to ensure capacity for your MySQL servers? We will quickly walk through the potential issues which can affect database capacity and see how we can detect them on the early stages.

This talk will provide you key technical highlights about Sphinx as a full text search engine from internal architecture overview to scalability and high availability strategies.

Detailed talk line up: - What is Sphinx - Internal architecture - Key full text and non-full-text functionality - Application integration - On-disk vs Real-time indexes. - Performance tricks - Scalability and high availability

We’ll take close look on how to offload MySQL server with queries which might be efficiently handled on the Sphinx side. Real-world examples for handling non-Full-Text queries including geodistance search, time segments implementation, using multi-value attributes and more. We’ll also learn how to keep massive text collections away from MySQL databases and how to utilize power of Sphinx on Full-text queries.