We’ll take close look on how to offload MySQL server with queries which may 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.
12 April 13:00 - 13:50 @
Vladimir has been helping people to scale their LAMP applications for more than 10 years, with a focus on performance optimization, architectural choices and deep knowledge of search and MySQL technologies. As a team lead on the PalominoDB European team, he provides high-profile remote DBA operational support and performance tuning on large, distributed open source database platforms. In the past he was worked with high-performance systems as a developer and team leader. He's spoken in the past at numerous OSS conferences and meet-ups in the US, EU and Russia. In his off-duty time he enjoys traveling, bicycling and photography.