Advanced search capabilities with MySQL and Sphinx

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

Experience level: 
Beginner
Duration: 
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.


Speakers

Principal, Astellar
Biography: 
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: https://twitter.com/vfedorkov Facebook: https://www.facebook.com/vfedorkov
CEO/CTO, Sphinx Search
Biography: 
Andrew is the founder and creative force behind Sphinx, an open-source full-text search engine designed specifically for performance, scalability, and relevance.