Advanced search capabilities with MySQL and Sphinx

Trends in Architecture and Design
3 April 2:00PM - 2:50PM @ Ballroom E

Experience level: 
50 minutes conference
When we're talking about implementing faceted search, auto completion, misspells correction, finding similar items and simply search across millions documents or goods on the website, MySQL built-in full-text indexes comes in mind. But as your data set grow up it may become a performance bottleneck on your website, which can be solved using Sphinx - search server optimized to run Full-Text queries up to 100 times fasters than MySQL can do. We will talk about best practices in using Sphinx with MySQL, advances search services implementations, discuss queries which are currently running on MySQL side and offload MySQL instances, what would be usual design for busy installations.


Performance consultant, Astellar
Vladimir has been helping people to scale their LAMP applications for more than 10 years, with a focus on performance optimization and operations for MySQL and Sphinx based systems. In the past he was worked with high-performance systems as a developer and team leader. In his off-duty time he enjoys traveling, bicycling and photography. Twitter: Facebook:
CEO/CTO, Sphinx Search
Andrew is the founder and creative force behind Sphinx, an open-source full-text search engine designed specifically for performance, scalability, and relevance.